Question 1

To return to editing the main document after modifying a header, which of the following should be done? Select all that apply.

Accepted Answer

A)  Double click in the main part of the document. 
B)  CTRL+Click in the main part of the document. 
C)  Click the Next button in the Navigation group of the Header & Footer Tools tab. 
D)  Click the Close Header and Footer button. 
A)  Double click in the main part of the document. 
B)  CTRL+Click in the main part of the document. 
C)  Click the Next button in the Navigation group of the Header & Footer Tools tab. 
D)  Click the Close Header and Footer button.

Question 2

Jonah has finished editing the footer of a document. In order to return to the body of the document, he can do which of the following? Select all that apply.

Accepted Answer

A)  Press ALT+F4. 
B)  Press the Close Header and Footer button in the Close group of the Header & Footer Tools Design tab. 
C)  Double-click anywhere in the body of the document. 
D)  Press ESC. 
A)  Press ALT+F4. 
B)  Press the Close Header and Footer button in the Close group of the Header & Footer Tools Design tab. 
C)  Double-click anywhere in the body of the document. 
D)  Press ESC.

Question 3

Alexis needs to remove an entry going from left to right in a table. She first needs to do which of the following?

Accepted Answer

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

Question 4

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 5

To add a line around the outside of a table, modify the table shading.

Accepted Answer

A) True 
 B)False

Question 6

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 7

To remove a line or cells going from right to left in a table, which of the following should be done?

Accepted Answer

A)  Delete a table row. 
B)  Delete a table column. 
C)  Delete a table cell. 
A)  Delete a table row. 
B)  Delete a table column. 
C)  Delete a table cell.

Question 8

You can demote and promote headings in the Navigation pane.

Accepted Answer

A) True 
 B)False

Question 9

To join two cells into a single cell, click Merge Cells.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)  Change the theme fonts. 
B)  Change page orientation. 
C)  Apply text effects. 
D)  Apply shading. 
A)  Change the theme fonts. 
B)  Change page orientation. 
C)  Apply text effects. 
D)  Apply shading.

Question 11

To duplicate a table row, first select the row and then click the Cut button.

Accepted Answer

A) True 
 B)False

Question 12

To quickly change the set of fonts in a document, change the theme fonts.

Accepted Answer

A) True 
 B)False

Question 13

To duplicate the contents of a line of cells going from the top of a table to the bottom of the table, which of the following should be done?

Accepted Answer

A)  Copy and paste the desired table column. 
B)  Cut and paste the desired table column. 
C)  Copy and paste the desired table row. 
D)  Cut and paste the desired table row. 
A)  Copy and paste the desired table column. 
B)  Cut and paste the desired table column. 
C)  Copy and paste the desired table row. 
D)  Cut and paste the desired table row.

Question 14

To add a predesigned page at the beginning of a document, insert a cover page.

Accepted Answer

A) True 
 B)False

Question 15

To insert a text box, click the SmartArt button.

Accepted Answer

A) True 
 B)False

Question 16

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 17

Rihanna needs to read through a document without distractions. Which view should she use?

Accepted Answer

A)  Read Mode 
B)  Print Layout 
C)  Web Layout 
D)  Outline View 
A)  Read Mode 
B)  Print Layout 
C)  Web Layout 
D)  Outline View

Question 18

Angel needs to move a row of data from the top of a table to the bottom of a table. She should do which of the following?

Accepted Answer

A)  Sort the table. 
B)  Split the table. 
C)  Move the table row. 
D)  Move the table column. 
A)  Sort the table. 
B)  Split the table. 
C)  Move the table row. 
D)  Move the table column.

Question 19

To insert blank page, insert a continuous section break.

Accepted Answer

A) True 
 B)False

Question 20

Brianna needs the rows in a table to alternate colors. She should do which of the following?

Accepted Answer

A)  Manually apply alternating fill colors to each row. 
B)  Select the table and apply a table style with banded rows. 
C)  Modify the table border style. 
D)  Click Distribute Rows. 
A)  Manually apply alternating fill colors to each row. 
B)  Select the table and apply a table style with banded rows. 
C)  Modify the table border style. 
D)  Click Distribute Rows.

To return to editing the main document after modifying a header, which of the following should be done? Select all that apply.

Jonah has finished editing the footer of a document. In order to return to the body of the document, he can do which of the following? Select all that apply.

Alexis needs to remove an entry going from left to right in a table. She first needs to do which of the following?

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

To add a line around the outside of a table, modify the table shading.

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?

To remove a line or cells going from right to left in a table, which of the following should be done?

You can demote and promote headings in the Navigation pane.

To join two cells into a single cell, click Merge Cells.

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

To duplicate a table row, first select the row and then click the Cut button.

To quickly change the set of fonts in a document, change the theme fonts.

To duplicate the contents of a line of cells going from the top of a table to the bottom of the table, which of the following should be done?

To add a predesigned page at the beginning of a document, insert a cover page.

To insert a text box, click the SmartArt button.

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

Rihanna needs to read through a document without distractions. Which view should she use?

Angel needs to move a row of data from the top of a table to the bottom of a table. She should do which of the following?

To insert blank page, insert a continuous section break.

Brianna needs the rows in a table to alternate colors. She should do which of the following?

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

To return to editing the main document after modifying a header, which of the following should be done? Select all that apply.

Jonah has finished editing the footer of a document. In order to return to the body of the document, he can do which of the following? Select all that apply.

Alexis needs to remove an entry going from left to right in a table. She first needs to do which of the following?

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

To add a line around the outside of a table, modify the table shading.

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?

To remove a line or cells going from right to left in a table, which of the following should be done?

You can demote and promote headings in the Navigation pane.

To join two cells into a single cell, click Merge Cells.

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

To duplicate a table row, first select the row and then click the Cut button.

To quickly change the set of fonts in a document, change the theme fonts.

To duplicate the contents of a line of cells going from the top of a table to the bottom of the table, which of the following should be done?

To add a predesigned page at the beginning of a document, insert a cover page.

To insert a text box, click the SmartArt button.

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

Rihanna needs to read through a document without distractions. Which view should she use?

Angel needs to move a row of data from the top of a table to the bottom of a table. She should do which of the following?

To insert blank page, insert a continuous section break.

Brianna needs the rows in a table to alternate colors. She should do which of the following?

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