Question 1

Jordan wants a warm color palette for his SmartArt.He should do which of the following?

Accepted Answer

A)  Click the Change Colors button and select the desired option. 
B)  Click the Text Effects button and select the desired option. 
C)  Click the Shape Effects button and select the desired option. 
D)  Click the Change Shape button and select the desired option. 
A)  Click the Change Colors button and select the desired option. 
B)  Click the Text Effects button and select the desired option. 
C)  Click the Shape Effects button and select the desired option. 
D)  Click the Change Shape button and select the desired option.

Question 2

To change the shading of a cell in a table,which of the following should be done first?

Accepted Answer

A)  Select the table. 
B)  Select the desired column. 
C)  Select the desired row. 
D)  Select the desired cell. 
A)  Select the table. 
B)  Select the desired column. 
C)  Select the desired row. 
D)  Select the desired cell.

Question 3

To insert a picture from your desktop,click the Online Pictures button.

Accepted Answer

A) True 
 B)False

Question 4

Cameron needs to brighten and increase the contrast of a picture.He should do which of the following?

Accepted Answer

A)  Click the Corrections button and select the desired option. 
B)  Click the Color button and select the desired option. 
C)  Click the Artistic Effects button and select the desired option. 
D)  Click the Change Picture button and select the desired option. 
A)  Click the Corrections button and select the desired option. 
B)  Click the Color button and select the desired option. 
C)  Click the Artistic Effects button and select the desired option. 
D)  Click the Change Picture button and select the desired option.

Question 5

Jasmine needs a double underline to appear beneath a word.She should change the underline style.

Accepted Answer

A) True 
 B)False

Question 6

Aniyah needs to insert the date and time in her document.She should do which of the following?

Accepted Answer

A)  Click the Insert Date and Time button and select the desired option. 
B)  Click the Cross-reference button. 
C)  Click the Table button and select the desired option. 
D)  Click the Link button and select the desired option. 
A)  Click the Insert Date and Time button and select the desired option. 
B)  Click the Cross-reference button. 
C)  Click the Table button and select the desired option. 
D)  Click the Link button and select the desired option.

Question 7

One of the pictures in Destiny's document is covered up by another picture.To make the obscured picture visible,she should do which of the following?

Accepted Answer

A)  Set the text wrapping of the obscured picture to In Front of Text. 
B)  Set the text wrapping of the obscured picture to Behind Text. 
C)  Send the obscured picture to the back. 
D)  Bring the obscured picture to the front. 
A)  Set the text wrapping of the obscured picture to In Front of Text. 
B)  Set the text wrapping of the obscured picture to Behind Text. 
C)  Send the obscured picture to the back. 
D)  Bring the obscured picture to the front.

Question 8

To clear all formatting from a picture,which of the following should be done?

Accepted Answer

A)  Click Reset Picture. 
B)  Select the picture and press DELETE. 
C)  Select the picture and press ESC. 
D)  Click Corrections and select the desired option. 
A)  Click Reset Picture. 
B)  Select the picture and press DELETE. 
C)  Select the picture and press ESC. 
D)  Click Corrections and select the desired option.

Question 9

To resize a shape nonproportionally,which of the following should be done?

Accepted Answer

A)  Click and drag the corner sizing handle. 
B)  Select the Lock aspect ratio check box and then enter values. 
C)  Click and drag a middle sizing handle. 
D)  ALT+SHIFT-Click and drag the corner sizing handle. 
A)  Click and drag the corner sizing handle. 
B)  Select the Lock aspect ratio check box and then enter values. 
C)  Click and drag a middle sizing handle. 
D)  ALT+SHIFT-Click and drag the corner sizing handle.

Question 10

To right-align text using a tab character,which of the following should be done?

Accepted Answer

A)  Click the Orientation button and select the desired option. 
B)  Create a tab stop and set the alignment option to Right. 
C)  Click the Align Right button in the Paragraph group. 
D)  Click the Align button and select Align Right. 
A)  Click the Orientation button and select the desired option. 
B)  Create a tab stop and set the alignment option to Right. 
C)  Click the Align Right button in the Paragraph group. 
D)  Click the Align button and select Align Right.

Question 11

To view the document at 100%,which of the following should be done? Select all that apply.

Accepted Answer

A)  Click the 100% button. 
B)  Click the One Page button. 
C)  Click the Zoom button and select 100%. 
D)  Click the Page Width button. 
A)  Click the 100% button. 
B)  Click the One Page button. 
C)  Click the Zoom button and select 100%. 
D)  Click the Page Width button.

Question 12

To quickly change the colors,fonts,and effects in a document,which of the following should be done?

Accepted Answer

A)  Click the Watermark button and select the desired option. 
B)  Select a Style from the Styles group. 
C)  Click the Themes button and select the desired option. 
D)  Click the Page Borders button and select the desired option. 
A)  Click the Watermark button and select the desired option. 
B)  Select a Style from the Styles group. 
C)  Click the Themes button and select the desired option. 
D)  Click the Page Borders button and select the desired option.

Question 13

Gabrielle opened a document that has a large number of tab stops in undesired locations.She wants the tab stops removed.She should do which of the following?

Accepted Answer

A)  Remove all tab characters from the document. 
B)  Remove all paragraph characters from the document. 
C)  Insert new tab stops in the document. 
D)  Clear all tab stops from the document. 
A)  Remove all tab characters from the document. 
B)  Remove all paragraph characters from the document. 
C)  Insert new tab stops in the document. 
D)  Clear all tab stops from the document.

Question 14

Imani needs to duplicate a picture in her document.She should do which of the following?

Accepted Answer

A)  Copy and paste the picture. 
B)  Rotate the picture. 
C)  Change the picture. 
D)  Reset the picture. 
A)  Copy and paste the picture. 
B)  Rotate the picture. 
C)  Change the picture. 
D)  Reset the picture.

Question 15

Kennedy needs to rotate a picture by 45 degrees.She should do which of the following?

Accepted Answer

A)  Flip the picture horizontally. 
B)  Flip the picture vertically. 
C)  Specify the amount of rotation in the Layout dialogue box. 
A)  Flip the picture horizontally. 
B)  Flip the picture vertically. 
C)  Specify the amount of rotation in the Layout dialogue box.

Question 16

To add a line around a shape,add a shape outline.

Accepted Answer

A) True 
 B)False

Question 17

To have a picture appear behind text,change the text wrapping of the picture.

Accepted Answer

A) True 
 B)False

Question 18

To create a hierarchy diagram,which of the following should be done?

Accepted Answer

A)  Click the SmartArt button and select the desired option. 
B)  Click the Chart button and select the desired option. 
C)  Click the Shapes button and select the desired option. 
D)  Click the Table button and select the desired option. 
A)  Click the SmartArt button and select the desired option. 
B)  Click the Chart button and select the desired option. 
C)  Click the Shapes button and select the desired option. 
D)  Click the Table button and select the desired option.

Question 19

Tiana wants a line to appear around a paragraph.She should do which of the following?

Accepted Answer

A)  Add a paragraph border. 
B)  Add paragraph shading. 
C)  Apply a text effect. 
D)  Apply a character style. 
A)  Add a paragraph border. 
B)  Add paragraph shading. 
C)  Apply a text effect. 
D)  Apply a character style.

Question 20

Joseph needs to remove the formatting from a selection of text.He should do which of the following?

Accepted Answer

A)  Select the text and press DEL. 
B)  Select the text and press ESC. 
C)  Select the text and click Cut. 
D)  Select the text and click Clear All Formatting. 
A)  Select the text and press DEL. 
B)  Select the text and press ESC. 
C)  Select the text and click Cut. 
D)  Select the text and click Clear All Formatting.

Jordan wants a warm color palette for his SmartArt.He should do which of the following?

To change the shading of a cell in a table,which of the following should be done first?

To insert a picture from your desktop,click the Online Pictures button.

Cameron needs to brighten and increase the contrast of a picture.He should do which of the following?

Jasmine needs a double underline to appear beneath a word.She should change the underline style.

Aniyah needs to insert the date and time in her document.She should do which of the following?

One of the pictures in Destiny's document is covered up by another picture.To make the obscured picture visible,she should do which of the following?

To clear all formatting from a picture,which of the following should be done?

To resize a shape nonproportionally,which of the following should be done?

To right-align text using a tab character,which of the following should be done?

To view the document at 100%,which of the following should be done? Select all that apply.

To quickly change the colors,fonts,and effects in a document,which of the following should be done?

Gabrielle opened a document that has a large number of tab stops in undesired locations.She wants the tab stops removed.She should do which of the following?

Imani needs to duplicate a picture in her document.She should do which of the following?

Kennedy needs to rotate a picture by 45 degrees.She should do which of the following?

To add a line around a shape,add a shape outline.

To have a picture appear behind text,change the text wrapping of the picture.

To create a hierarchy diagram,which of the following should be done?

Tiana wants a line to appear around a paragraph.She should do which of the following?

Joseph needs to remove the formatting from a selection of text.He should do which of the following?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, Visual Basic for Applications Vba, and Collaboration Features in Excel

Filters

Exam 3: Working With Large Worksheets, Charting, and What-If Analysis

Jordan wants a warm color palette for his SmartArt.He should do which of the following?

To change the shading of a cell in a table,which of the following should be done first?

To insert a picture from your desktop,click the Online Pictures button.

Cameron needs to brighten and increase the contrast of a picture.He should do which of the following?

Jasmine needs a double underline to appear beneath a word.She should change the underline style.

Aniyah needs to insert the date and time in her document.She should do which of the following?

One of the pictures in Destiny's document is covered up by another picture.To make the obscured picture visible,she should do which of the following?

To clear all formatting from a picture,which of the following should be done?

To resize a shape nonproportionally,which of the following should be done?

To right-align text using a tab character,which of the following should be done?

To view the document at 100%,which of the following should be done? Select all that apply.

To quickly change the colors,fonts,and effects in a document,which of the following should be done?

Gabrielle opened a document that has a large number of tab stops in undesired locations.She wants the tab stops removed.She should do which of the following?

Imani needs to duplicate a picture in her document.She should do which of the following?

Kennedy needs to rotate a picture by 45 degrees.She should do which of the following?

To add a line around a shape,add a shape outline.

To have a picture appear behind text,change the text wrapping of the picture.

To create a hierarchy diagram,which of the following should be done?

Tiana wants a line to appear around a paragraph.She should do which of the following?

Joseph needs to remove the formatting from a selection of text.He should do which of the following?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, Visual Basic for Applications Vba, and Collaboration Features in Excel

Filters