Question 1

Kevin needs to sort a table by the table's first column. He should do which of the following?

Accepted Answer

A)  Click Distribute Columns. 
B)  Click AutoFit and then select the desired option. 
C)  Modify the table properties. 
D)  Click Sort and then select the desired option. 
A)  Click Distribute Columns. 
B)  Click AutoFit and then select the desired option. 
C)  Modify the table properties. 
D)  Click Sort and then select the desired option.

Question 2

To move a list item to a lower level, promote the list item.

Accepted Answer

A) True 
 B)False

Question 3

To insert a preformatted table template in a document, Insert a Quick Table.

Accepted Answer

A) True 
 B)False

Question 4

To remove the line around a table, modify the table shading.

Accepted Answer

A) True 
 B)False

Question 5

To prevent Word from hyphenating words in all capital letters, change the line numbering options.

Accepted Answer

A) True 
 B)False

Question 6

Use the Go To command to go to the next section.

Accepted Answer

A) True 
 B)False

Question 7

To move a list item to a lower level, demote the list item.

Accepted Answer

A) True 
 B)False

Question 8

Tyler created a table that spans across multiple pages. To have the header row appear at the top of each page, he should do which of the following?

Accepted Answer

A)  Select the header row and then click Repeat Header Rows. 
B)  Copy the header row and paste it in the top row of every page. 
C)  Select the header row and click Distribute Rows. 
D)  Select the header and click Insert Below. 
A)  Select the header row and then click Repeat Header Rows. 
B)  Copy the header row and paste it in the top row of every page. 
C)  Select the header row and click Distribute Rows. 
D)  Select the header and click Insert Below.

Question 9

Jane needs to add additional stages to a cyclical SmartArt diagram. She should do which of the following?

Accepted Answer

A)  Add a shape to the SmartArt diagram. 
B)  Add a bullet to the SmartArt diagram. 
C)  Change the SmartArt layout. 
D)  Change the SmartArt style. 
A)  Add a shape to the SmartArt diagram. 
B)  Add a bullet to the SmartArt diagram. 
C)  Change the SmartArt layout. 
D)  Change the SmartArt style.

Question 10

To create a different footer for the first page of a document, which of the following should be done?

Accepted Answer

A)  Select the Different First Page option. 
B)  Select the Different Odd & Even Pages option. 
C)  Select the Show Document Text option. 
D)  It is not possible to have a unique first page footer. 
A)  Select the Different First Page option. 
B)  Select the Different Odd & Even Pages option. 
C)  Select the Show Document Text option. 
D)  It is not possible to have a unique first page footer.

Question 11

To duplicate a table row, first select the row and then do which of the following?

Accepted Answer

A)  Click the Cut button. 
B)  Click the Copy button. 
C)  Click the Paste button. 
A)  Click the Cut button. 
B)  Click the Copy button. 
C)  Click the Paste button.

Question 12

Jacki needs a SmartArt object to be 4" tall and 3" wide. She should do which of the following?

Accepted Answer

A)  Enter the desired position in the absolute position text boxes. 
B)  Enter the desired dimensions in the width and height text boxes. 
C)  Drag the rotation handle. 
D)  Drag the sizing handle. 
A)  Enter the desired position in the absolute position text boxes. 
B)  Enter the desired dimensions in the width and height text boxes. 
C)  Drag the rotation handle. 
D)  Drag the sizing handle.

Question 13

To prevent Word from hyphenating words that are in all capital letters, which of the following should be done?

Accepted Answer

A)  Apply a document theme. 
B)  Apply a text effect. 
C)  Change the text style. 
D)  Change the hyphenation options. 
A)  Apply a document theme. 
B)  Apply a text effect. 
C)  Change the text style. 
D)  Change the hyphenation options.

Question 14

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 15

To view two windows side-by-side, press the Split button.

Accepted Answer

A) True 
 B)False

Question 16

Nathan needs more room to add another entry in a table. To do so, he should insert a row.

Accepted Answer

A) True 
 B)False

Question 17

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 18

To position text midway between the top, bottom, left, and right of a table cell, select the cell and click Align Top Left.

Accepted Answer

A) True 
 B)False

Question 19

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 20

To quickly go to the next section of a document, which of the following should be done?

Accepted Answer

A)  Use the Go To command. 
B)  Use the Smart Lookup command. 
C)  Use the Selection pane. 
D)  Use Results in the Navigation pane. 
A)  Use the Go To command. 
B)  Use the Smart Lookup command. 
C)  Use the Selection pane. 
D)  Use Results in the Navigation pane.

Kevin needs to sort a table by the table's first column. He should do which of the following?

To move a list item to a lower level, promote the list item.

To insert a preformatted table template in a document, Insert a Quick Table.

To remove the line around a table, modify the table shading.

To prevent Word from hyphenating words in all capital letters, change the line numbering options.

Use the Go To command to go to the next section.

To move a list item to a lower level, demote the list item.

Tyler created a table that spans across multiple pages. To have the header row appear at the top of each page, he should do which of the following?

Jane needs to add additional stages to a cyclical SmartArt diagram. She should do which of the following?

To create a different footer for the first page of a document, which of the following should be done?

To duplicate a table row, first select the row and then do which of the following?

Jacki needs a SmartArt object to be 4" tall and 3" wide. She should do which of the following?

To prevent Word from hyphenating words that are in all capital letters, which of the following should be done?

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

To view two windows side-by-side, press the Split button.

Nathan needs more room to add another entry in a table. To do so, he should insert a row.

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

To position text midway between the top, bottom, left, and right of a table cell, select the cell and click Align Top Left.

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

To quickly go to the next section of a document, which of the following should be done?

Getting Started With Excel

Formatting Workbook Text and Data

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Filters

Exam 3: Performing Calculations With Formulas and Functions

Kevin needs to sort a table by the table's first column. He should do which of the following?

To move a list item to a lower level, promote the list item.

To insert a preformatted table template in a document, Insert a Quick Table.

To remove the line around a table, modify the table shading.

To prevent Word from hyphenating words in all capital letters, change the line numbering options.

Use the Go To command to go to the next section.

To move a list item to a lower level, demote the list item.

Tyler created a table that spans across multiple pages. To have the header row appear at the top of each page, he should do which of the following?

Jane needs to add additional stages to a cyclical SmartArt diagram. She should do which of the following?

To create a different footer for the first page of a document, which of the following should be done?

To duplicate a table row, first select the row and then do which of the following?

Jacki needs a SmartArt object to be 4" tall and 3" wide. She should do which of the following?

To prevent Word from hyphenating words that are in all capital letters, which of the following should be done?

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

To view two windows side-by-side, press the Split button.

Nathan needs more room to add another entry in a table. To do so, he should insert a row.

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

To position text midway between the top, bottom, left, and right of a table cell, select the cell and click Align Top Left.

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

To quickly go to the next section of a document, which of the following should be done?

Getting Started With Excel

Formatting Workbook Text and Data

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Filters