Question 1

To sort the rows in a table, click the Formula button.

Accepted Answer

A) True 
 B)False  False

Question 2

Sydney has created a table with two columns to store the name and address of clients. She needs to add additional information about phone numbers. She should do which of the following?

Accepted Answer

A)  Add a column. 
B)  Add a row. 
C)  Create a new table. 
D)  Add comments to the table. 
A)  Add a column. 
B)  Add a row. 
C)  Create a new table. 
D)  Add comments to the table. A

Question 3

To automatically resize the columns in a table to fit the contents of cells, which of the following should be done?

Accepted Answer

A)  Click Distribute Columns. 
B)  Click Distribute Rows. 
C)  Click AutoFit Contents. 
D)  Click Align, then Distribute Horizontally. 
A)  Click Distribute Columns. 
B)  Click Distribute Rows. 
C)  Click AutoFit Contents. 
D)  Click Align, then Distribute Horizontally. C

Question 4

Laila needs to change the formatting of a table. To do so, which of the following does she need to do first?

Accepted Answer

A)  Select a row in the table. 
B)  Select the table. 
C)  Select a column in the table. 
A)  Select a row in the table. 
B)  Select the table. 
C)  Select a column in the table.

Question 5

To move a list item to a higher level, which of the following should be done?

Accepted Answer

A)  Promote the item. 
B)  Demote the item. 
C)  Insert a right tab stop. 
D)  Insert a left tab stop. 
A)  Promote the item. 
B)  Demote the item. 
C)  Insert a right tab stop. 
D)  Insert a left tab stop.

Question 6

Makayla needs to select the entire line of cells in a table going from left to right. She needs to select a column.

Accepted Answer

A) True 
 B)False

Question 7

Anthony needs all the rows in a table to be the same height. He should do which of the following?

Accepted Answer

A)  Distribute the rows. 
B)  Distribute the columns. 
C)  AutoFit Contents. 
D)  AutoFit Window. 
A)  Distribute the rows. 
B)  Distribute the columns. 
C)  AutoFit Contents. 
D)  AutoFit Window.

Question 8

To have text appear at the top of every page in a document, insert a footer.

Accepted Answer

False - bo

Question 9

Joan needs to calculate the average of a column of cells in a table. She should do which of the following?

Accepted Answer

A)  Insert Document Info in the table. 
B)  Insert a Quick Part in the table. 
C)  Convert the table to text. 
D)  Insert a formula in the table. 
A)  Insert Document Info in the table. 
B)  Insert a Quick Part in the table. 
C)  Convert the table to text. 
D)  Insert a formula in the table.

Question 10

Text in the header appears at the top of each page in a document.

Accepted Answer

A) True 
 B)False

Question 11

To remove 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)  Distribute the table's rows. 
B)  Distribute the table's columns. 
C)  Delete a table row. 
D)  Delete a table column. 
A)  Distribute the table's rows. 
B)  Distribute the table's columns. 
C)  Delete a table row. 
D)  Delete a table column.

Question 12

Jeremiah has inserted a table and needs to fill it with data. After entering a value, he should do which of the following to advance the curser to the next cell in the table?

Accepted Answer

A)  Press TAB. 
B)  Press ENTER. 
C)  Press ESC. 
D)  Press INSERT. 
A)  Press TAB. 
B)  Press ENTER. 
C)  Press ESC. 
D)  Press INSERT.

Question 13

To create a different header 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 header. 
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 header.

Question 14

To sort a series of paragraphs in a document alphabetically by the first word in each paragraph, which of the following should be done?

Accepted Answer

A)  Click the Equation button in the Symbols group. 
B)  Click the Symbol button in the Symbols group. 
C)  Click the Show/Hide ¶ button in the Paragraph group. 
D)  Click the Sort button in the Paragraph group. 
A)  Click the Equation button in the Symbols group. 
B)  Click the Symbol button in the Symbols group. 
C)  Click the Show/Hide ¶ button in the Paragraph group. 
D)  Click the Sort button in the Paragraph group.

Question 15

Joan wants to remove a line of cells going from the top of a table to the bottom of the table. She should delete a row from the table.

Accepted Answer

A) True 
 B)False

Question 16

Jenna needs to create a table that appears like a calendar in a Word document. She should do which of the following?

Accepted Answer

A)  Insert a date picker content control. 
B)  Insert a calendar based quick table. 
C)  Insert a SmartArt object. 
D)  Insert a quick part. 
A)  Insert a date picker content control. 
B)  Insert a calendar based quick table. 
C)  Insert a SmartArt object. 
D)  Insert a quick part.

Question 17

To promote and demote headings using the Navigation pane, first right-click the desired heading.

Accepted Answer

A) True 
 B)False

Question 18

To join two cells into a single cell, which of the following should be done?

Accepted Answer

A)  Click the Merge Cells button. 
B)  Click the Distribute Rows button. 
C)  Click the Split Cells button. 
D)  Click the Split Table button. 
A)  Click the Merge Cells button. 
B)  Click the Distribute Rows button. 
C)  Click the Split Cells button. 
D)  Click the Split Table button.

Question 19

To add cells to a table going from left to right, insert a column.

Accepted Answer

False - ro

Question 20

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.

To sort the rows in a table, click the Formula button.

Sydney has created a table with two columns to store the name and address of clients. She needs to add additional information about phone numbers. She should do which of the following?

To automatically resize the columns in a table to fit the contents of cells, which of the following should be done?

Laila needs to change the formatting of a table. To do so, which of the following does she need to do first?

To move a list item to a higher level, which of the following should be done?

Makayla needs to select the entire line of cells in a table going from left to right. She needs to select a column.

Anthony needs all the rows in a table to be the same height. He should do which of the following?

To have text appear at the top of every page in a document, insert a footer.

Joan needs to calculate the average of a column of cells in a table. She should do which of the following?

Text in the header appears at the top of each page in a document.

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

Jeremiah has inserted a table and needs to fill it with data. After entering a value, he should do which of the following to advance the curser to the next cell in the table?

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

To sort a series of paragraphs in a document alphabetically by the first word in each paragraph, which of the following should be done?

Joan wants to remove a line of cells going from the top of a table to the bottom of the table. She should delete a row from the table.

Jenna needs to create a table that appears like a calendar in a Word document. She should do which of the following?

To promote and demote headings using the Navigation pane, first right-click the desired heading.

To join two cells into a single cell, which of the following should be done?

To add cells to a table going from left to right, insert a column.

To right-align text using a tab character, 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

To sort the rows in a table, click the Formula button.

Sydney has created a table with two columns to store the name and address of clients. She needs to add additional information about phone numbers. She should do which of the following?

To automatically resize the columns in a table to fit the contents of cells, which of the following should be done?

Laila needs to change the formatting of a table. To do so, which of the following does she need to do first?

To move a list item to a higher level, which of the following should be done?

Makayla needs to select the entire line of cells in a table going from left to right. She needs to select a column.

Anthony needs all the rows in a table to be the same height. He should do which of the following?

To have text appear at the top of every page in a document, insert a footer.

Joan needs to calculate the average of a column of cells in a table. She should do which of the following?

Text in the header appears at the top of each page in a document.

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

Jeremiah has inserted a table and needs to fill it with data. After entering a value, he should do which of the following to advance the curser to the next cell in the table?

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

To sort a series of paragraphs in a document alphabetically by the first word in each paragraph, which of the following should be done?

Joan wants to remove a line of cells going from the top of a table to the bottom of the table. She should delete a row from the table.

Jenna needs to create a table that appears like a calendar in a Word document. She should do which of the following?

To promote and demote headings using the Navigation pane, first right-click the desired heading.

To join two cells into a single cell, which of the following should be done?

To add cells to a table going from left to right, insert a column.

To right-align text using a tab character, 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