Question 1

In order to see who has permission to open, copy, or change your workbook, click the File tab and review the information area.

Accepted Answer

A) True 
 B)False

Question 2

A summary query calculates statistics about ____.

Accepted Answer

A)  one record 
B)  groups of records 
C)  one field 
D)  groups of fields

Question 3

You can use PowerPoint or Word to create handouts of PowerPoint slides.

Accepted Answer

A) True 
 B)False

Question 4

When you paste text from Word into PowerPoint, you can choose to ____ it or not.

Accepted Answer

A)  hide 
B)  comment on 
C)  lock 
D)  link

Question 5

Which of the following resizing methods lets you see how the graphic looks as you modify it?

Accepted Answer

A)  Entering an exact height or width in the text boxes in the Size group on the Picture Tools Format tab. 
B)  Changing the scale of the graphic using the Size tab in the Layout dialog box. 
C)  Changing the scale of the graphic using the tools on the Picture Tools Format tab. 
D)  Dragging a sizing handle.

Question 6

To add a shape fill to an object, click the Drawing Tools Design tab, and then click the Shape Fill list arrow in the Shape Styles group. ____________________​

Accepted Answer

A) True 
 B)False

Question 7

Excel charts can be embedded or linked in PowerPoint.

Accepted Answer

A) True 
 B)False

Question 8

You can add tick marks in the  ____pane.

Accepted Answer

A)  Title 
B)  Chart Options 
C)  Format Axis 
D)  Format Chart

Question 9

Which function should you use to calculate the monthly payment on a loan?

Accepted Answer

A)  PMT 
B)  LOAN 
C)  PAY 
D)  RATE

Question 10

Sort orders defined in Query Design View are not saved with the query object.

Accepted Answer

A) True 
 B)False

Question 11

When a file is linked to PowerPoint and you want to edit it in its source program, PowerPoint must be closed.

Accepted Answer

A) True 
 B)False

Question 12

Use the Picture Tools _____ tab to size, crop, position, and adjust a graphic.​

Accepted Answer

A) Design 
B) Format 
C) Layout 
D) Adjust

Question 13

Choose In Line With Text to change a floating graphic to a(n) inline graphic. _________________________

Accepted Answer

A) True 
 B)False

Question 14

You can create custom theme colors by clicking the Colors button in the _____ group.​

Accepted Answer

A) Background 
B)  Master Layout 
C)  Edit Master 
D) Edit Themes

Question 15

When the comparison operator Null is used as criteria in the query design grid, the query finds records in which ____.

Accepted Answer

A)  the value is not equal to the text "Null" 
B)  the field value is equal to the text "Null" 
C)  any value has been entered for a field 
D)  no value has been entered for a field

Question 16

___________________gridlines identify minor units on the axis and are usually identified by tick marks.

Accepted Answer

The answer of ___________________gridlines identify minor units on the axis...

Question 17

Which tab is used for modifying a chart?

Accepted Answer

A)  Chart Tools Design 
B)  Excel 
C)  Excel Tools 
D)  Modify Chart

Question 18

The > comparison operator means ____.

Accepted Answer

A)  greater than 
B)  greater than or equal to 
C)  less than 
D)  less than or equal to

Question 19

You cannot add 3-dimensional effect​s to a shape.

Accepted Answer

A) True 
 B)False

Question 20

A(n) ____________________ is a set of display and/or print settings that you can name and save and then access at a later time.

Accepted Answer

The answer of A(n) ____________________ is a set of display...

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

In order to see who has permission to open, copy, or change your workbook, click the File tab and review the information area.

A summary query calculates statistics about ____.

You can use PowerPoint or Word to create handouts of PowerPoint slides.

When you paste text from Word into PowerPoint, you can choose to ____ it or not.

Which of the following resizing methods lets you see how the graphic looks as you modify it?

To add a shape fill to an object, click the Drawing Tools Design tab, and then click the Shape Fill list arrow in the Shape Styles group. ____________________

Excel charts can be embedded or linked in PowerPoint.

You can add tick marks in the ____pane.

Which function should you use to calculate the monthly payment on a loan?

Sort orders defined in Query Design View are not saved with the query object.

When a file is linked to PowerPoint and you want to edit it in its source program, PowerPoint must be closed.

Use the Picture Tools _____ tab to size, crop, position, and adjust a graphic.

Choose In Line With Text to change a floating graphic to a(n) inline graphic. _________________________

You can create custom theme colors by clicking the Colors button in the _____ group.

When the comparison operator Null is used as criteria in the query design grid, the query finds records in which ____.

___________________gridlines identify minor units on the axis and are usually identified by tick marks.

Which tab is used for modifying a chart?

The > comparison operator means ____.

You cannot add 3-dimensional effects to a shape.

A(n) ____________________ is a set of display and/or print settings that you can name and save and then access at a later time.

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

In order to see who has permission to open, copy, or change your workbook, click the File tab and review the information area.

A summary query calculates statistics about ____.

You can use PowerPoint or Word to create handouts of PowerPoint slides.

When you paste text from Word into PowerPoint, you can choose to ____ it or not.

Which of the following resizing methods lets you see how the graphic looks as you modify it?

To add a shape fill to an object, click the Drawing Tools Design tab, and then click the Shape Fill list arrow in the Shape Styles group. ____________________​

Excel charts can be embedded or linked in PowerPoint.

You can add tick marks in the ____pane.

Which function should you use to calculate the monthly payment on a loan?

Sort orders defined in Query Design View are not saved with the query object.

When a file is linked to PowerPoint and you want to edit it in its source program, PowerPoint must be closed.

Use the Picture Tools _____ tab to size, crop, position, and adjust a graphic.​

Choose In Line With Text to change a floating graphic to a(n) inline graphic. _________________________

You can create custom theme colors by clicking the Colors button in the _____ group.​

When the comparison operator Null is used as criteria in the query design grid, the query finds records in which ____.

___________________gridlines identify minor units on the axis and are usually identified by tick marks.

Which tab is used for modifying a chart?

The > comparison operator means ____.

You cannot add 3-dimensional effect​s to a shape.

A(n) ____________________ is a set of display and/or print settings that you can name and save and then access at a later time.

To add a shape fill to an object, click the Drawing Tools Design tab, and then click the Shape Fill list arrow in the Shape Styles group. ____________________

Use the Picture Tools _____ tab to size, crop, position, and adjust a graphic.

You can create custom theme colors by clicking the Colors button in the _____ group.

You cannot add 3-dimensional effects to a shape.