Exam 6: Illustrating Documents With Graphics Managing Workbook Dataimproving Queriesenhancing Chartsintegrating Word, Excel, Access, and Powerpoint

You are creating a brochure for a local florist. They would like you to add a photograph of flowers to the brochure. How can you change the picture, which is currently an inline graphic, to a floating graphic?

To open two instances of one Excel workbook, you need to open it twice from its original location.

Which query wizard helps you build a crosstab query?

You cannot crop a graphic to fit a shape, such as an oval.​

You can use the Text Box button in the Text group or the ____________________ button in the Illustrations group to create a text box.​

If you copy text from Word and paste it into PowerPoint, the pasted text becomes a ____ that you can then format and position using PowerPoint tools.

Cells in the data entry area are generally locked.

____________________ is information that describes data.

A select query is the most common type of query.

To open two instances of one Excel workbook, you open the file and then create a new window using the New Window button in the Window group.

You want to add the PaymentDate field from the Payments table to the query grid. Describe how you can do this.

Which type of query retrieves data from one or more linked tables and displays the results in a datasheet?

To show and hide custom views, you click the Add View button in the Custom Views dialog box.

A word or object in a worksheet that, when clicked, displays, or "jumps to," another location is called a(n) ____________________.

You can split an Excel worksheet into multiple ____________________ using the Split button in the Window group on the View tab.

The object you create with a source program is called the destination file.

If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.

The cell lock option does not change the way a user interacts with a worksheet until the protection feature is activated.

____ queries summarize data in which one or more fields are chosen for the row headings, another for the column heading, and yet another for the field summarized within the datasheet itself.

You create WordArt using the WordArt button in the ____ group on the Insert tab.