Question 1

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?

Accepted Answer

The answer of You are creating a brochure for a...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Which query wizard helps you build a crosstab query?

Accepted Answer

A)  Select Query Wizard 
B)  Crosstab Query Wizard 
C)  Simple Query Wizard 
D)  Find Aggregates Query Wizard

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

The answer of You can use the Text Box button...

Question 6

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.

Accepted Answer

A)  text placeholder 
B)  text box 
C)  vector graphic 
D)  bitmap graphic

Question 7

Cells in the data entry area are generally locked.

Accepted Answer

A) True 
 B)False

Question 8

____________________ is information that describes data.

Accepted Answer

The answer of ____________________ is information that describes data....

Question 9

A select query is the most common type of query.

Accepted Answer

A) True 
 B)False

Question 10

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.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

The answer of You want to add the PaymentDate field...

Question 12

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

Accepted Answer

A)  Common 
B)  Select 
C)  Linking 
D)  Web

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of A word or object in a worksheet...

Question 15

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

Accepted Answer

The answer of You can split an Excel worksheet into...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

____ 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.

Accepted Answer

The answer of ____ queries summarize data in which one...

Question 20

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

Accepted Answer

A)  Text 
B)  Illustrations 
C)  Graphics 
D)  Picture

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.

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.