Question 1

To right-justify text at a tab stop, change the tab stop alignment options.

Accepted Answer

A) True 
 B)False

Question 2

To add a predesigned page to the front of a document that displays the document title and other relevant information, which of the following should be done?

Accepted Answer

A)  Add a table of authorities. 
B)  Add a table of contents. 
C)  Add a cross-reference. 
D)  Add a cover page. 
A)  Add a table of authorities. 
B)  Add a table of contents. 
C)  Add a cross-reference. 
D)  Add a cover page.

Question 3

To add a line around the outside of a table, which of the following should be done?

Accepted Answer

A)  Modify the table border. 
B)  Modify the table shading. 
C)  Modify the table alignment. 
D)  Modify the cell margins. 
A)  Modify the table border. 
B)  Modify the table shading. 
C)  Modify the table alignment. 
D)  Modify the cell margins.

Question 4

Joseph created a table with columns labeled Name, City, and Telephone. He wants to sort the table by City and then by name. He should do which of the following?

Accepted Answer

A)  Click Sort and select the desired options. 
B)  Click AutoFit and select the desired options. 
C)  Click Split Table. 
D)  Click Properties and select the desired options. 
A)  Click Sort and select the desired options. 
B)  Click AutoFit and select the desired options. 
C)  Click Split Table. 
D)  Click Properties and select the desired options.

Question 5

To resize SmartArt to exact dimensions, drag one of the sizing handles.

Accepted Answer

A) True 
 B)False

Question 6

Jamie needs to copy and paste a large amount of information between two documents. She should do which of the following?

Accepted Answer

A)  Enter Multiple Pages view. 
B)  Enter Draft view. 
C)  Create split views. 
D)  View the documents side by side. 
A)  Enter Multiple Pages view. 
B)  Enter Draft view. 
C)  Create split views. 
D)  View the documents side by side.

Question 7

Jeremiah needs to organize information in his document using rows and columns. He should insert a table.

Accepted Answer

A) True 
 B)False

Question 8

Alexis needs the text after a tab character to be moved further to the right. She should do which of the following?

Accepted Answer

A)  Move the appropriate tab stop to the right. 
B)  Remove the tab stop. 
C)  Insert space characters to move the text to the right. 
D)  Insert tab characters to move the text to the right. 
A)  Move the appropriate tab stop to the right. 
B)  Remove the tab stop. 
C)  Insert space characters to move the text to the right. 
D)  Insert tab characters to move the text to the right.

Question 9

To remove the line around a table, which of the following should be done?

Accepted Answer

A)  Remove the table top border. 
B)  Remove the table bottom border. 
C)  Remove the table inside border. 
D)  Remove the table outside border. 
A)  Remove the table top border. 
B)  Remove the table bottom border. 
C)  Remove the table inside border. 
D)  Remove the table outside border.

Question 10

To quickly change the colors, fonts, and effects in a document, change the document style.

Accepted Answer

False - th

Question 11

To create a dotted line border around a table, which of the following should be done?

Accepted Answer

A)  Change the border width. 
B)  Change the table shading. 
C)  Change the border style. 
D)  Change the border color. 
A)  Change the border width. 
B)  Change the table shading. 
C)  Change the border style. 
D)  Change the border color.

Question 12

Chloe notices that when she inserts a tab character, her insertion point moves to the right side of the page and the text she enters is right-justified. She does not want tab characters to behave this way. She should do which of the following?

Accepted Answer

A)  Change the paragraph justification. 
B)  Remove the tab stop. 
C)  Remove the paragraph. 
D)  Change the paragraph spacing. 
A)  Change the paragraph justification. 
B)  Remove the tab stop. 
C)  Remove the paragraph. 
D)  Change the paragraph spacing.

Question 13

To view an outline representation of information in a SmartArt object, which of the following should be done?

Accepted Answer

A)  Show the Smart Lookup pane. 
B)  Show the Researcher pane. 
C)  Show the SmartArt text pane. 
D)  Show the Navigation pane. 
A)  Show the Smart Lookup pane. 
B)  Show the Researcher pane. 
C)  Show the SmartArt text pane. 
D)  Show the Navigation pane.

Question 14

Gabriel needs the first column in a table to have special formatting. He should do which of the following?

Accepted Answer

A)  Check the First Column box in the Table Style Options group. 
B)  Check the Last Column box in the Table Style Options group. 
C)  Check the Banded Columns box in the Table Style Options group. 
A)  Check the First Column box in the Table Style Options group. 
B)  Check the Last Column box in the Table Style Options group. 
C)  Check the Banded Columns box in the Table Style Options group.

Question 15

Brandon needs the outside border of a table to be red. He should do which of the following?

Accepted Answer

A)  Change the border Pen Color to red and then select the Outside Borders option. 
B)  Change the border Pen Color to red and then select the Inside Borders option. 
C)  Change the shading Color to red and then select the Outside Borders option. 
D)  Change the shading Color to red and then select the Inside Borders option. 
A)  Change the border Pen Color to red and then select the Outside Borders option. 
B)  Change the border Pen Color to red and then select the Inside Borders option. 
C)  Change the shading Color to red and then select the Outside Borders option. 
D)  Change the shading Color to red and then select the Inside Borders option.

Question 16

To view the edges of cells in a table, click View Gridlines

Accepted Answer

A) True 
 B)False

Question 17

Use the Navigation pane to view a list of headings in a document.

Accepted Answer

A) True 
 B)False

Question 18

Sydney is working on a table that has no border lines. She is having a difficult time seeing where cells begin and end. She should do which of the following?

Accepted Answer

A)  Add shading to the table. 
B)  Click View Gridlines. 
C)  Change the cell margins. 
D)  Split the table. 
A)  Add shading to the table. 
B)  Click View Gridlines. 
C)  Change the cell margins. 
D)  Split the table.

Question 19

To create columns and rows in a table using the cursor, first which of the following should be done?

Accepted Answer

A)  Click Split Cells. 
B)  Click Split Table. 
C)  Click Merge Cells. 
D)  Click Draw Table. 
A)  Click Split Cells. 
B)  Click Split Table. 
C)  Click Merge Cells. 
D)  Click Draw Table.

Question 20

To position text midway between the top, bottom, left, and right of a table cell, which of the following should be done?

Accepted Answer

A)  Select the cell and click Align Bottom Center. 
B)  Select the cell and click Align Center Right. 
C)  Select the cell and click Align Center Left. 
D)  Select the cell and click Align Center. 
A)  Select the cell and click Align Bottom Center. 
B)  Select the cell and click Align Center Right. 
C)  Select the cell and click Align Center Left. 
D)  Select the cell and click Align Center.

To right-justify text at a tab stop, change the tab stop alignment options.

To add a predesigned page to the front of a document that displays the document title and other relevant information, which of the following should be done?

To add a line around the outside of a table, which of the following should be done?

Joseph created a table with columns labeled Name, City, and Telephone. He wants to sort the table by City and then by name. He should do which of the following?

To resize SmartArt to exact dimensions, drag one of the sizing handles.

Jamie needs to copy and paste a large amount of information between two documents. She should do which of the following?

Jeremiah needs to organize information in his document using rows and columns. He should insert a table.

Alexis needs the text after a tab character to be moved further to the right. She should do which of the following?

To remove the line around a table, which of the following should be done?

To quickly change the colors, fonts, and effects in a document, change the document style.

To create a dotted line border around a table, which of the following should be done?

Chloe notices that when she inserts a tab character, her insertion point moves to the right side of the page and the text she enters is right-justified. She does not want tab characters to behave this way. She should do which of the following?

To view an outline representation of information in a SmartArt object, which of the following should be done?

Gabriel needs the first column in a table to have special formatting. He should do which of the following?

Brandon needs the outside border of a table to be red. He should do which of the following?

To view the edges of cells in a table, click View Gridlines

Use the Navigation pane to view a list of headings in a document.

Sydney is working on a table that has no border lines. She is having a difficult time seeing where cells begin and end. She should do which of the following?

To create columns and rows in a table using the cursor, first which of the following should be done?

To position text midway between the top, bottom, left, and right of a table cell, 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 right-justify text at a tab stop, change the tab stop alignment options.

To add a predesigned page to the front of a document that displays the document title and other relevant information, which of the following should be done?

To add a line around the outside of a table, which of the following should be done?

Joseph created a table with columns labeled Name, City, and Telephone. He wants to sort the table by City and then by name. He should do which of the following?

To resize SmartArt to exact dimensions, drag one of the sizing handles.

Jamie needs to copy and paste a large amount of information between two documents. She should do which of the following?

Jeremiah needs to organize information in his document using rows and columns. He should insert a table.

Alexis needs the text after a tab character to be moved further to the right. She should do which of the following?

To remove the line around a table, which of the following should be done?

To quickly change the colors, fonts, and effects in a document, change the document style.

To create a dotted line border around a table, which of the following should be done?

Chloe notices that when she inserts a tab character, her insertion point moves to the right side of the page and the text she enters is right-justified. She does not want tab characters to behave this way. She should do which of the following?

To view an outline representation of information in a SmartArt object, which of the following should be done?

Gabriel needs the first column in a table to have special formatting. He should do which of the following?

Brandon needs the outside border of a table to be red. He should do which of the following?

To view the edges of cells in a table, click View Gridlines

Use the Navigation pane to view a list of headings in a document.

Sydney is working on a table that has no border lines. She is having a difficult time seeing where cells begin and end. She should do which of the following?

To create columns and rows in a table using the cursor, first which of the following should be done?

To position text midway between the top, bottom, left, and right of a table cell, 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