Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

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 6

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 7

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 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

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 12

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 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

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.

Question 17

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 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 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 20

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.

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

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

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

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

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.

To remove the line around a table,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?

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

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

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?

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 create columns and rows in a table using the cursor,first which of the following should be done?

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

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

To quickly change the shading,borders,and font colors of a table,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?

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 position text midway between the top,bottom,left,and right of a table cell,select the cell and click Align Top Left.

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?

Getting Started With Excel: Tracking Miscellaneous Expenses for a Conference

Formatting Workbook Text and Data: Creating a Sales Report

Analyzing and Charting Financial Data: Preparing an Investment Report

Generating Reports From Multiple Worksheets and Workbooks: Summarizing Profit and Lo

Managing Data With Data Tools: Analyzing Employment Data

Summarizing Data With Pivottables: Preparing a Social Media Marketing Report

Performing What-If Analyses: Maximizing Profits With the Right Product Mix

Exploring Financial Tools and Functions: Analyzing a Business Plan

Analyzing Data With Business Intelligence Tools: Presenting Sales and Revenue Data

Filters

Exam 3: Performing Calculations With Formulas and Functions: Staffing a Call Center

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

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

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

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

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.

To remove the line around a table,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?

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

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

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?

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 create columns and rows in a table using the cursor,first which of the following should be done?

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

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

To quickly change the shading,borders,and font colors of a table,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?

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 position text midway between the top,bottom,left,and right of a table cell,select the cell and click Align Top Left.

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?

Getting Started With Excel: Tracking Miscellaneous Expenses for a Conference

Formatting Workbook Text and Data: Creating a Sales Report

Analyzing and Charting Financial Data: Preparing an Investment Report

Generating Reports From Multiple Worksheets and Workbooks: Summarizing Profit and Lo

Managing Data With Data Tools: Analyzing Employment Data

Summarizing Data With Pivottables: Preparing a Social Media Marketing Report

Performing What-If Analyses: Maximizing Profits With the Right Product Mix

Exploring Financial Tools and Functions: Analyzing a Business Plan

Analyzing Data With Business Intelligence Tools: Presenting Sales and Revenue Data

Filters