Question 1

Jasmine wants a term in an index to appear subordinate to another term in the index. She should do which of the following?

Accepted Answer

A)  Use the Source Manager dialog box to edit sources as needed. 
B)  Use the Cross-reference dialog box to create a cross-reference for the desired term. 
C)  Use the Create Source dialog box to create a source for the desired term. 
D)  Use the Mark Index Entry dialog box to establish the desired term as a subentry. 
A)  Use the Source Manager dialog box to edit sources as needed. 
B)  Use the Cross-reference dialog box to create a cross-reference for the desired term. 
C)  Use the Create Source dialog box to create a source for the desired term. 
D)  Use the Mark Index Entry dialog box to establish the desired term as a subentry.

Question 2

To add information about the horizontal and vertical extent of a chart, which of the following should be done?

Accepted Answer

A)  Add axes to the chart. 
B)  Add a trendline to the chart. 
C)  Add error bars to the chart. 
D)  Add a legend to the chart. 
A)  Add axes to the chart. 
B)  Add a trendline to the chart. 
C)  Add error bars to the chart. 
D)  Add a legend to the chart.

Question 3

To ensure a document index is up-to-date, which of the following should be done?

Accepted Answer

A)  Update the index. 
B)  Check the document for spelling and grammar errors. 
C)  Inspect the document. 
D)  Turn on track changes. 
A)  Update the index. 
B)  Check the document for spelling and grammar errors. 
C)  Inspect the document. 
D)  Turn on track changes.

Question 4

To display an equation in a document, which of the following should be done?

Accepted Answer

A)  Click the Insert SmartArt button. 
B)  Click the Insert an Equation button. 
C)  Click the Insert a Symbol button. 
D)  Click the Insert WordArt button. 
A)  Click the Insert SmartArt button. 
B)  Click the Insert an Equation button. 
C)  Click the Insert a Symbol button. 
D)  Click the Insert WordArt button.

Question 5

To change page numbering to Roman numerals, which of the following should be done?

Accepted Answer

A)  Click the Symbol button and select the desired option. 
B)  Select the Different First Page option. 
C)  Manually enter the page numbers as Roman numerals. 
D)  Format the page numbers. 
A)  Click the Symbol button and select the desired option. 
B)  Select the Different First Page option. 
C)  Manually enter the page numbers as Roman numerals. 
D)  Format the page numbers.

Question 6

To return to Print Layout view from Outline view, click Close Outline view.

Accepted Answer

A) True 
 B)False

Question 7

Inspect a document to locate graphic objects in the document.

Accepted Answer

A) True 
 B)False

Question 8

Place the cursor on the desired heading and then click the plus symbol in the Outlining tab to expand the heading.

Accepted Answer

A) True 
 B)False

Question 9

To include an alphabetical list of terms at the end of a document, which of the following should be done?

Accepted Answer

A)  Insert a references list. 
B)  Insert an index. 
C)  Insert a table of contents. 
D)  Insert a footer. 
A)  Insert a references list. 
B)  Insert an index. 
C)  Insert a table of contents. 
D)  Insert a footer.

Question 10

To only see the highest level headings in a document, select Level 9 in the Show Level drop down box.

Accepted Answer

A) True 
 B)False

Question 11

To view pages one atop the other, enter One Page view.

Accepted Answer

A) True 
 B)False

Question 12

To change a line chart to a bar chart, which of the following should be done?

Accepted Answer

A)  Change the chart style. 
B)  Change the chart type. 
C)  Edit the chart data. 
D)  Refresh the chart data. 
A)  Change the chart style. 
B)  Change the chart type. 
C)  Edit the chart data. 
D)  Refresh the chart data.

Question 13

To display a document as continuous text and page breaks denoted by dotted lines, switch to Draft view.

Accepted Answer

A) True 
 B)False

Question 14

Sharon needs to view a document as continuous text with page breaks denoted by dotted lines. She should do which of the following?

Accepted Answer

A)  Switch to Read Mode. 
B)  Switch to Print Layout view. 
C)  Switch to Web Layout view. 
D)  Switch to Draft view. 
A)  Switch to Read Mode. 
B)  Switch to Print Layout view. 
C)  Switch to Web Layout view. 
D)  Switch to Draft view.

Jasmine wants a term in an index to appear subordinate to another term in the index. She should do which of the following?

To add information about the horizontal and vertical extent of a chart, which of the following should be done?

To ensure a document index is up-to-date, which of the following should be done?

To display an equation in a document, which of the following should be done?

To change page numbering to Roman numerals, which of the following should be done?

To return to Print Layout view from Outline view, click Close Outline view.

Inspect a document to locate graphic objects in the document.

Place the cursor on the desired heading and then click the plus symbol in the Outlining tab to expand the heading.

To include an alphabetical list of terms at the end of a document, which of the following should be done?

To only see the highest level headings in a document, select Level 9 in the Show Level drop down box.

To view pages one atop the other, enter One Page view.

To change a line chart to a bar chart, which of the following should be done?

To display a document as continuous text and page breaks denoted by dotted lines, switch to Draft view.

Sharon needs to view a document as continuous text with page breaks denoted by dotted lines. She should do which of the following?

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

Jasmine wants a term in an index to appear subordinate to another term in the index. She should do which of the following?

To add information about the horizontal and vertical extent of a chart, which of the following should be done?

To ensure a document index is up-to-date, which of the following should be done?

To display an equation in a document, which of the following should be done?

To change page numbering to Roman numerals, which of the following should be done?

To return to Print Layout view from Outline view, click Close Outline view.

Inspect a document to locate graphic objects in the document.

Place the cursor on the desired heading and then click the plus symbol in the Outlining tab to expand the heading.

To include an alphabetical list of terms at the end of a document, which of the following should be done?

To only see the highest level headings in a document, select Level 9 in the Show Level drop down box.

To view pages one atop the other, enter One Page view.

To change a line chart to a bar chart, which of the following should be done?

To display a document as continuous text and page breaks denoted by dotted lines, switch to Draft view.

Sharon needs to view a document as continuous text with page breaks denoted by dotted lines. She should do which of the following?

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