Question 1

Kayla needs a paragraph border to have a shadow appearance.She should do which of the following?

Accepted Answer

A)  Click the Theme Effects button and select the desired option. 
B)  Insert a 3D Model. 
C)  Click the Text Effects and Typography button and select the desired option. 
D)  Change the type of paragraph border in the Borders and Shading dialogue box. 
A)  Click the Theme Effects button and select the desired option. 
B)  Insert a 3D Model. 
C)  Click the Text Effects and Typography button and select the desired option. 
D)  Change the type of paragraph border in the Borders and Shading dialogue box. D

Question 2

Imani needs to rearrange a picture in her document.The picture has Square text wrapping.She should do which of the following?

Accepted Answer

A)  Click and drag the picture to the desired location. 
B)  CTRL+Click and drag the picture to the desired location. 
C)  CTRL+SHIFT+Click and drag the picture to the desired location. 
D)  CTRL+ALT+Click and drag the picture to the desired location. 
A)  Click and drag the picture to the desired location. 
B)  CTRL+Click and drag the picture to the desired location. 
C)  CTRL+SHIFT+Click and drag the picture to the desired location. 
D)  CTRL+ALT+Click and drag the picture to the desired location. A

Question 3

Isaiah needs to insert a copyright symbol (©).He should do which of the following?

Accepted Answer

A)  Insert a citation. 
B)  Insert a symbol from the Symbol gallery. 
C)  Insert a cross-reference. 
D)  Insert a footnote. 
A)  Insert a citation. 
B)  Insert a symbol from the Symbol gallery. 
C)  Insert a cross-reference. 
D)  Insert a footnote. B

Question 4

To have a shape appear at the top and center of a page,which of the following should be done?

Accepted Answer

A)  Click the Position button and select Position in Top and Center with Square Text Wrapping. 
B)  Click the Wrap Text button and select Square. 
C)  Click the Align button and select Top. 
D)  Click the Align button and select Distribute Vertically. 
A)  Click the Position button and select Position in Top and Center with Square Text Wrapping. 
B)  Click the Wrap Text button and select Square. 
C)  Click the Align button and select Top. 
D)  Click the Align button and select Distribute Vertically.

Question 5

To specify the exact dimensions of a shape,which of the following should be done?

Accepted Answer

A)  Enter the height in the Shape Height text box and enter the width in the Shape Width text box. 
B)  Drag one of the sizing handles. 
C)  Click the Position button and select the desired option. 
D)  Click the Align button and select the desired option. 
A)  Enter the height in the Shape Height text box and enter the width in the Shape Width text box. 
B)  Drag one of the sizing handles. 
C)  Click the Position button and select the desired option. 
D)  Click the Align button and select the desired option.

Question 6

Joshua needs stylized text in his document to be normal,unformatted text.He should do which of the following?

Accepted Answer

A)  Press the Format Painter button. 
B)  Apply the Heading 1 style. 
C)  Press the Clear All Formatting button. 
D)  Apply the Strong style. 
A)  Press the Format Painter button. 
B)  Apply the Heading 1 style. 
C)  Press the Clear All Formatting button. 
D)  Apply the Strong style.

Question 7

Tom clicked and dragged the rotation handle above a picture.This resulted in which of the following?

Accepted Answer

A)  Flipped the shape vertically. 
B)  Flipped the shape horizontally. 
C)  Rotated the shape to an exact value. 
D)  Rotated the shape to an approximate value. 
A)  Flipped the shape vertically. 
B)  Flipped the shape horizontally. 
C)  Rotated the shape to an exact value. 
D)  Rotated the shape to an approximate value.

Question 8

To rotate a picture 90 degrees,flip the picture horizontally.

Accepted Answer

A) True 
 B)False

Question 9

To create a cycle diagram in a document,which of the following should be done?

Accepted Answer

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

Question 10

To create a new page in a document,click the Multiple Pages button.

Accepted Answer

A) True 
 B)False

Question 11

To quickly change the shading,borders,and font colors of a table,which of the following should be done?

Accepted Answer

A)  Apply a Table Style. 
B)  Apply Theme Effects. 
C)  Apply Text Effects. 
D)  Insert a Watermark. 
A)  Apply a Table Style. 
B)  Apply Theme Effects. 
C)  Apply Text Effects. 
D)  Insert a Watermark.

Question 12

To enable a table to be interpreted by a screen reader,which of the following should be done?

Accepted Answer

A)  Apply a table style to the table. 
B)  Sort the data in the table. 
C)  Convert the table to text. 
D)  Add alt text to the tables. 
A)  Apply a table style to the table. 
B)  Sort the data in the table. 
C)  Convert the table to text. 
D)  Add alt text to the tables.

Question 13

Hailey wants to resize a picture using percentages of its original size.She should do which of the following?

Accepted Answer

A)  Select the Lock aspect ratio check box before entering the percentages. 
B)  Select the Absolute option and then enter the percentages. 
C)  Clear the Lock aspect ratio check box and then use the Scale option. 
D)  Select the Relative option and then enter the percentages. 
A)  Select the Lock aspect ratio check box before entering the percentages. 
B)  Select the Absolute option and then enter the percentages. 
C)  Clear the Lock aspect ratio check box and then use the Scale option. 
D)  Select the Relative option and then enter the percentages.

Question 14

To create a horizontal mirror reflection of a picture,which of the following should be done?

Accepted Answer

A)  Click Rotate and select Flip Horizontal. 
B)  Click Rotate and select Rotate Left 90°. 
C)  Click Align and select Distribute Horizontally. 
A)  Click Rotate and select Flip Horizontal. 
B)  Click Rotate and select Rotate Left 90°. 
C)  Click Align and select Distribute Horizontally.

Question 15

Jasmine needs a floating picture to be exactly 2" from the left side of the page and 4" from the top side of the page.She should specify an absolute position for the picture.

Accepted Answer

A) True 
 B)False

Question 16

Sydney needs to resize a picture so that it is exactly 2 inches tall and 3 inches wide.She should do which of the following?

Accepted Answer

A)  Drag one of the sizing handles. 
B)  Click the Position button and select the desired option. 
C)  Enter the height in the Shape Height text box and enter the width in the Shape Width text box. 
D)  Click the Align button and select the desired option. 
A)  Drag one of the sizing handles. 
B)  Click the Position button and select the desired option. 
C)  Enter the height in the Shape Height text box and enter the width in the Shape Width text box. 
D)  Click the Align button and select the desired option.

Question 17

To quickly change the fill,outline,and effect of a shape,which of the following should be done?

Accepted Answer

A)  Apply a Character Style. 
B)  Apply a Paragraph Style. 
C)  Apply a Theme Effect. 
D)  Apply a Shape Style. 
A)  Apply a Character Style. 
B)  Apply a Paragraph Style. 
C)  Apply a Theme Effect. 
D)  Apply a Shape Style.

Question 18

To ensure that a document can be read by people with visual impairment,which of the following should be done?

Accepted Answer

A)  Check the document for accessibility. 
B)  Check the document for spelling and grammar errors. 
C)  Inspect the document. 
D)  Check the document for compatibility. 
A)  Check the document for accessibility. 
B)  Check the document for spelling and grammar errors. 
C)  Inspect the document. 
D)  Check the document for compatibility.

Question 19

To create a duplicate copy of a picture in a document,which of the following should be done? Select all that apply.

Accepted Answer

A)  Select the picture,click Copy,then click Paste. 
B)  Select the picture,then click and drag the picture to the desired location. 
C)  Select the picture,click Cut,then click Paste. 
D)  Select the picture,then CTRL+click and drag the picture to the desired location. 
A)  Select the picture,click Copy,then click Paste. 
B)  Select the picture,then click and drag the picture to the desired location. 
C)  Select the picture,click Cut,then click Paste. 
D)  Select the picture,then CTRL+click and drag the picture to the desired location.

Question 20

To ensure a document with tables can be interpreted by people with vision impairment,make sure to add appropriate alt text to the tables in the document.

Accepted Answer

A) True 
 B)False

Kayla needs a paragraph border to have a shadow appearance.She should do which of the following?

Imani needs to rearrange a picture in her document.The picture has Square text wrapping.She should do which of the following?

Isaiah needs to insert a copyright symbol (©).He should do which of the following?

To have a shape appear at the top and center of a page,which of the following should be done?

To specify the exact dimensions of a shape,which of the following should be done?

Joshua needs stylized text in his document to be normal,unformatted text.He should do which of the following?

Tom clicked and dragged the rotation handle above a picture.This resulted in which of the following?

To rotate a picture 90 degrees,flip the picture horizontally.

To create a cycle diagram in a document,which of the following should be done?

To create a new page in a document,click the Multiple Pages button.

To quickly change the shading,borders,and font colors of a table,which of the following should be done?

To enable a table to be interpreted by a screen reader,which of the following should be done?

Hailey wants to resize a picture using percentages of its original size.She should do which of the following?

To create a horizontal mirror reflection of a picture,which of the following should be done?

Jasmine needs a floating picture to be exactly 2" from the left side of the page and 4" from the top side of the page.She should specify an absolute position for the picture.

Sydney needs to resize a picture so that it is exactly 2 inches tall and 3 inches wide.She should do which of the following?

To quickly change the fill,outline,and effect of a shape,which of the following should be done?

To ensure that a document can be read by people with visual impairment,which of the following should be done?

To create a duplicate copy of a picture in a document,which of the following should be done? Select all that apply.

To ensure a document with tables can be interpreted by people with vision impairment,make sure to add appropriate alt text to the tables in the document.

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

Kayla needs a paragraph border to have a shadow appearance.She should do which of the following?

Imani needs to rearrange a picture in her document.The picture has Square text wrapping.She should do which of the following?

Isaiah needs to insert a copyright symbol (©).He should do which of the following?

To have a shape appear at the top and center of a page,which of the following should be done?

To specify the exact dimensions of a shape,which of the following should be done?

Joshua needs stylized text in his document to be normal,unformatted text.He should do which of the following?

Tom clicked and dragged the rotation handle above a picture.This resulted in which of the following?

To rotate a picture 90 degrees,flip the picture horizontally.

To create a cycle diagram in a document,which of the following should be done?

To create a new page in a document,click the Multiple Pages button.

To quickly change the shading,borders,and font colors of a table,which of the following should be done?

To enable a table to be interpreted by a screen reader,which of the following should be done?

Hailey wants to resize a picture using percentages of its original size.She should do which of the following?

To create a horizontal mirror reflection of a picture,which of the following should be done?

Jasmine needs a floating picture to be exactly 2" from the left side of the page and 4" from the top side of the page.She should specify an absolute position for the picture.

Sydney needs to resize a picture so that it is exactly 2 inches tall and 3 inches wide.She should do which of the following?

To quickly change the fill,outline,and effect of a shape,which of the following should be done?

To ensure that a document can be read by people with visual impairment,which of the following should be done?

To create a duplicate copy of a picture in a document,which of the following should be done? Select all that apply.

To ensure a document with tables can be interpreted by people with vision impairment,make sure to add appropriate alt text to the tables in the document.

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