Question 1

Chloe is experimenting with different layouts for a table. To try out different widths for a column, she should do which of the following?

Accepted Answer

A)  Select Draw Table and modify the table as desired. 
B)  Drag the column border to resize the width to an approximate value. 
C)  Select the column and press Delete. 
D)  Select the column and press Split Cells. 
A)  Select Draw Table and modify the table as desired. 
B)  Drag the column border to resize the width to an approximate value. 
C)  Select the column and press Delete. 
D)  Select the column and press Split Cells.

Question 2

Jayla needs a column to be exactly 2.5 inches wide. She should do which of the following?

Accepted Answer

A)  Select the column, then enter the desired width in the Width text box. 
B)  Select the column, then enter the desired height in the Height text box. 
C)  Drag the column border to adjust the width. 
D)  Drag the column border to adjust the height. 
A)  Select the column, then enter the desired width in the Width text box. 
B)  Select the column, then enter the desired height in the Height text box. 
C)  Drag the column border to adjust the width. 
D)  Drag the column border to adjust the height.

Question 3

To set a different first page footer, select the Different first page option.

Accepted Answer

A) True 
 B)False

Question 4

To create a master document, which of the following should be done?

Accepted Answer

A)  Start a Word document and then insert the desired subdocuments. 
B)  Start a Word document and then insert the desired citations. 
C)  Start a Word document and then insert the desired linked objects. 
D)  Start a Word document and then insert the desired embedded objects. 
A)  Start a Word document and then insert the desired subdocuments. 
B)  Start a Word document and then insert the desired citations. 
C)  Start a Word document and then insert the desired linked objects. 
D)  Start a Word document and then insert the desired embedded objects.

Question 5

Susan needs a paragraph to automatically start on a new page. She should do which of the following?

Accepted Answer

A)  Enable the widow and orphan control option. 
B)  Enable the keep with next option. 
C)  Enable the page break before option. 
D)  Enable the don't hyphenate option. 
A)  Enable the widow and orphan control option. 
B)  Enable the keep with next option. 
C)  Enable the page break before option. 
D)  Enable the don't hyphenate option.

Question 6

To insert a list of figures in a document, which of the following should be done?

Accepted Answer

A)  Click the Insert Caption button. 
B)  Click the Table of Contents button. 
C)  Click the Insert Table of Authorities button. 
D)  Click the Insert Table of Figures button. 
A)  Click the Insert Caption button. 
B)  Click the Table of Contents button. 
C)  Click the Insert Table of Authorities button. 
D)  Click the Insert Table of Figures button.

Question 7

To change a bar chart to a line chart, change the chart style.

Accepted Answer

A) True 
 B)False

Question 8

To allow people to sign a document, which of the following should be done?

Accepted Answer

A)  Add a document header. 
B)  Add a digital signature to the document. 
C)  Add a hyperlink to the document. 
D)  Add a signature line to the document. 
A)  Add a document header. 
B)  Add a digital signature to the document. 
C)  Add a hyperlink to the document. 
D)  Add a signature line to the document.

Question 9

To specify different odd and even pages for footers, modify the footers individually.

Accepted Answer

A) True 
 B)False

Question 10

Angel needs all text with the Subtitle style to appear orange. She should do which of the following?

Accepted Answer

A)  Modify the font color of the Subtitle style. 
B)  Manually find all instances of text with the Subtitle style and change the font color. 
C)  Search by formatting to locate all text with the Subtitle style and change the font color of each instance. 
A)  Modify the font color of the Subtitle style. 
B)  Manually find all instances of text with the Subtitle style and change the font color. 
C)  Search by formatting to locate all text with the Subtitle style and change the font color of each instance.

Question 11

To add headings to a document while in Outline view, which of the following should be done?

Accepted Answer

A)  Enter text and then demote the text to body text. 
B)  Insert a subdocument in the desired location. 
C)  Enter text and then promote or demote the text to the desired level. 
D)  Enter text and then apply the Normal paragraph style. 
A)  Enter text and then demote the text to body text. 
B)  Insert a subdocument in the desired location. 
C)  Enter text and then promote or demote the text to the desired level. 
D)  Enter text and then apply the Normal paragraph style.

Question 12

To have text appear at the bottom of each page in a document, do which of the following?

Accepted Answer

A)  Double-click the footer region of the page and enter the desired text. 
B)  Manually enter the desired text at the bottom of each page. 
C)  Double-click the header region of the page and enter the desired text. 
D)  Insert an endnote with the desired text. 
A)  Double-click the footer region of the page and enter the desired text. 
B)  Manually enter the desired text at the bottom of each page. 
C)  Double-click the header region of the page and enter the desired text. 
D)  Insert an endnote with the desired text.

Question 13

Word allows you to specify the distance of a footer from the edge of a page.

Accepted Answer

A) True 
 B)False

Question 14

To add a subdocument to a master document, which of the following should be done? Select all that apply.

Accepted Answer

A)  Click the Lock Document button. 
B)  Click the Collapse Subdocuments button. 
C)  Click the Insert Subdocument button. 
D)  Click the Create Subdocument button. 
A)  Click the Lock Document button. 
B)  Click the Collapse Subdocuments button. 
C)  Click the Insert Subdocument button. 
D)  Click the Create Subdocument button.

Question 15

To center text between the top and bottom of a page, change the vertical alignment of the page.

Accepted Answer

A) True 
 B)False

Question 16

To create two simultaneous views of a document, do which of the following?

Accepted Answer

A)  Click the Split button. 
B)  Click the Arrange All button. 
C)  Click the Multiple Pages button. 
D)  Click the Read Mode button. 
A)  Click the Split button. 
B)  Click the Arrange All button. 
C)  Click the Multiple Pages button. 
D)  Click the Read Mode button.

Question 17

Amy created a contract that she needs people to sign. She should do which of the following?

Accepted Answer

A)  Add a digital signature to the document. 
B)  Add a signature line to the document. 
C)  Add a hyperlink to the document. 
D)  Add a document header. 
A)  Add a digital signature to the document. 
B)  Add a signature line to the document. 
C)  Add a hyperlink to the document. 
D)  Add a document header.

Question 18

To ensure a document with a table can be interpreted by people with vision impairment, make sure to do which of the following?

Accepted Answer

A)  Add alt text to the table. 
B)  Apply a table style to the table. 
C)  Sort the data in the table. 
D)  Convert the table to text. 
A)  Add alt text to the table. 
B)  Apply a table style to the table. 
C)  Sort the data in the table. 
D)  Convert the table to text.

Question 19

To include a subdocument's text directly within the master document, which of the following should be done?

Accepted Answer

A)  Unlink the subdocument. 
B)  Lock the document. 
C)  Collapse the subdocument. 
D)  Insert a subdocument. 
A)  Unlink the subdocument. 
B)  Lock the document. 
C)  Collapse the subdocument. 
D)  Insert a subdocument.

Question 20

To insert text that electronically refers the reader to another part of the document, which of the following should be done?

Accepted Answer

A)  Insert a cross reference. 
B)  Insert a citation. 
C)  Insert a caption. 
D)  Insert WordArt. 
A)  Insert a cross reference. 
B)  Insert a citation. 
C)  Insert a caption. 
D)  Insert WordArt.

Chloe is experimenting with different layouts for a table. To try out different widths for a column, she should do which of the following?

Jayla needs a column to be exactly 2.5 inches wide. She should do which of the following?

To set a different first page footer, select the Different first page option.

To create a master document, which of the following should be done?

Susan needs a paragraph to automatically start on a new page. She should do which of the following?

To insert a list of figures in a document, which of the following should be done?

To change a bar chart to a line chart, change the chart style.

To allow people to sign a document, which of the following should be done?

To specify different odd and even pages for footers, modify the footers individually.

Angel needs all text with the Subtitle style to appear orange. She should do which of the following?

To add headings to a document while in Outline view, which of the following should be done?

To have text appear at the bottom of each page in a document, do which of the following?

Word allows you to specify the distance of a footer from the edge of a page.

To add a subdocument to a master document, which of the following should be done? Select all that apply.

To center text between the top and bottom of a page, change the vertical alignment of the page.

To create two simultaneous views of a document, do which of the following?

Amy created a contract that she needs people to sign. She should do which of the following?

To ensure a document with a table can be interpreted by people with vision impairment, make sure to do which of the following?

To include a subdocument's text directly within the master document, which of the following should be done?

To insert text that electronically refers the reader to another part of the document, which of the following should be done?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

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

Filters

Exam 10: Analyzing Data With Business Intelligence Tools

Chloe is experimenting with different layouts for a table. To try out different widths for a column, she should do which of the following?

Jayla needs a column to be exactly 2.5 inches wide. She should do which of the following?

To set a different first page footer, select the Different first page option.

To create a master document, which of the following should be done?

Susan needs a paragraph to automatically start on a new page. She should do which of the following?

To insert a list of figures in a document, which of the following should be done?

To change a bar chart to a line chart, change the chart style.

To allow people to sign a document, which of the following should be done?

To specify different odd and even pages for footers, modify the footers individually.

Angel needs all text with the Subtitle style to appear orange. She should do which of the following?

To add headings to a document while in Outline view, which of the following should be done?

To have text appear at the bottom of each page in a document, do which of the following?

Word allows you to specify the distance of a footer from the edge of a page.

To add a subdocument to a master document, which of the following should be done? Select all that apply.

To center text between the top and bottom of a page, change the vertical alignment of the page.

To create two simultaneous views of a document, do which of the following?

Amy created a contract that she needs people to sign. She should do which of the following?

To ensure a document with a table can be interpreted by people with vision impairment, make sure to do which of the following?

To include a subdocument's text directly within the master document, which of the following should be done?

To insert text that electronically refers the reader to another part of the document, which of the following should be done?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

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

Filters