Question 1

Chart axes are a series of lines that span across the chart at regular intervals.

Accepted Answer

A) True 
 B)False  False

Question 2

Sean needs to insert an Excel worksheet in a Word file and to store the document data within the Word file.He should do which of the following?

Accepted Answer

A)  Embed the Excel file in the word document. 
B)  Create a link to the Excel file in the Word document. 
C)  Take a screenshot of the Excel file and paste it in the Word document. 
D)  Copy the text from the Excel file and paste it in the Word document. 
A)  Embed the Excel file in the word document. 
B)  Create a link to the Excel file in the Word document. 
C)  Take a screenshot of the Excel file and paste it in the Word document. 
D)  Copy the text from the Excel file and paste it in the Word document. A

Question 3

Katie needs to change the minimum and maximum values on an axis.She should do which of the following?

Accepted Answer

A)  Switch the data rows and columns. 
B)  Edit the chart data. 
C)  Format the chart legend. 
D)  Format the chart axis. 
A)  Switch the data rows and columns. 
B)  Edit the chart data. 
C)  Format the chart legend. 
D)  Format the chart axis. D

Question 4

Word is unable to publish a blog post document directly to a website.

Accepted Answer

A) True 
 B)False

Question 5

To insert a PDF in a Word document without storing the PDF data within the Word document,which of the following should be done?

Accepted Answer

A)  Embed the PDF in the word document. 
B)  Create a link to the PDF in the Word document. 
C)  Take a screenshot of the PDF and paste it in the Word document. 
D)  Copy the text from the PDF and paste it in the Word document. 
A)  Embed the PDF in the word document. 
B)  Create a link to the PDF in the Word document. 
C)  Take a screenshot of the PDF and paste it in the Word document. 
D)  Copy the text from the PDF and paste it in the Word document.

Question 6

Ashley needs to change the color of gridlines in a chart.She should do which of the following?

Accepted Answer

A)  Click the desired grid line and then select the desired color. 
B)  Click the desired axis and then select the desired color. 
C)  Click the desired line and then select the desired color. 
D)  Click the desired point and then select the desired color. 
A)  Click the desired grid line and then select the desired color. 
B)  Click the desired axis and then select the desired color. 
C)  Click the desired line and then select the desired color. 
D)  Click the desired point and then select the desired color.

Question 7

To identify differences between two versions of a document,which of the following should be done?

Accepted Answer

A)  Use the Smart Lookup command. 
B)  Use the Researcher command. 
C)  Use the Combine command. 
D)  Use the Compare command. 
A)  Use the Smart Lookup command. 
B)  Use the Researcher command. 
C)  Use the Combine command. 
D)  Use the Compare command.

Question 8

To show document revisions in balloons,which of the following should be done?

Accepted Answer

A)  Click Show Revisions in Balloons 
B)  Click Show All Revisions Inline 
C)  Click Show Only Comments and Formatting in Balloons 
A)  Click Show Revisions in Balloons 
B)  Click Show All Revisions Inline 
C)  Click Show Only Comments and Formatting in Balloons

Question 9

To add text to the top of a chart,which of the following should be done?

Accepted Answer

A)  Add data labels. 
B)  Add an axis title. 
C)  Add a chart legend. 
D)  Add a chart title. 
A)  Add data labels. 
B)  Add an axis title. 
C)  Add a chart legend. 
D)  Add a chart title.

Question 10

John is working on a document with tracked changes.To move the insertion point to the previous tracked change in the document,he should do which of the following?

Accepted Answer

A)  Click Next in the Changes group of the Review tab. 
B)  Click Previous in the Changes group of the Review tab. 
C)  Click Next in the Comments group of the Review tab. 
D)  Click Previous in the Comments group of the Review tab. 
A)  Click Next in the Changes group of the Review tab. 
B)  Click Previous in the Changes group of the Review tab. 
C)  Click Next in the Comments group of the Review tab. 
D)  Click Previous in the Comments group of the Review tab.

Question 11

To insert a document property in a header,first which of the following should be done?

Accepted Answer

A)  Click the Link button. 
B)  Click the Icons button. 
C)  Click the Chart button. 
D)  Click the Quick Parts button. 
A)  Click the Link button. 
B)  Click the Icons button. 
C)  Click the Chart button. 
D)  Click the Quick Parts button.

Question 12

Susan is working on a document with tracked changes.She wants to see the document as if all changes have been made.Which of the following options should she select?

Accepted Answer

A)  No Markup 
B)  All Markup 
C)  Simple Markup 
D)  Original 
A)  No Markup 
B)  All Markup 
C)  Simple Markup 
D)  Original

Question 13

Axis titles help viewers interpret a chart by specifying units and other information about the data.

Accepted Answer

A) True 
 B)False

Question 14

Ashley sent a Word document to multiple collaborators for review.After receiving the reviewed documents back from the collaborators,she now wants to view all the changes and comments in a single document.She should do which of the following?

Accepted Answer

A)  Use the Combine command. 
B)  Use the Compare command. 
C)  Enable track changes in each of the documents. 
D)  Check each of the documents for accessibility. 
A)  Use the Combine command. 
B)  Use the Compare command. 
C)  Enable track changes in each of the documents. 
D)  Check each of the documents for accessibility.

Question 15

To correct a data error in a chart,which of the following should be done?

Accepted Answer

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

Question 16

To make a document read-only,check the document for accessibility.

Accepted Answer

A) True 
 B)False

Question 17

Danielle wants a legend to appear below a chart.She should do which of the following?

Accepted Answer

A)  Set the legend position to top. 
B)  Set the legend position to bottom. 
C)  Set the legend position to left. 
D)  Set the legend position to right. 
A)  Set the legend position to top. 
B)  Set the legend position to bottom. 
C)  Set the legend position to left. 
D)  Set the legend position to right.

Question 18

To show document revisions inline,which of the following should be done?

Accepted Answer

A)  Click Show Revisions in Balloons 
B)  Click Show All Revisions Inline 
C)  Click Show Only Comments and Formatting in Balloons 
A)  Click Show Revisions in Balloons 
B)  Click Show All Revisions Inline 
C)  Click Show Only Comments and Formatting in Balloons

Question 19

To change the color scheme of a chart,select the chart and click Change Colors.

Accepted Answer

A) True 
 B)False

Question 20

To quickly change the appearance of a chart without changing the way information is represented,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.

Chart axes are a series of lines that span across the chart at regular intervals.

Sean needs to insert an Excel worksheet in a Word file and to store the document data within the Word file.He should do which of the following?

Katie needs to change the minimum and maximum values on an axis.She should do which of the following?

Word is unable to publish a blog post document directly to a website.

To insert a PDF in a Word document without storing the PDF data within the Word document,which of the following should be done?

Ashley needs to change the color of gridlines in a chart.She should do which of the following?

To identify differences between two versions of a document,which of the following should be done?

To show document revisions in balloons,which of the following should be done?

To add text to the top of a chart,which of the following should be done?

John is working on a document with tracked changes.To move the insertion point to the previous tracked change in the document,he should do which of the following?

To insert a document property in a header,first which of the following should be done?

Susan is working on a document with tracked changes.She wants to see the document as if all changes have been made.Which of the following options should she select?

Axis titles help viewers interpret a chart by specifying units and other information about the data.

Ashley sent a Word document to multiple collaborators for review.After receiving the reviewed documents back from the collaborators,she now wants to view all the changes and comments in a single document.She should do which of the following?

To correct a data error in a chart,which of the following should be done?

To make a document read-only,check the document for accessibility.

Danielle wants a legend to appear below a chart.She should do which of the following?

To show document revisions inline,which of the following should be done?

To change the color scheme of a chart,select the chart and click Change Colors.

To quickly change the appearance of a chart without changing the way information is represented,which of the following should be done?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Formula Auditing, Data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, Visual Basic for Applications Vba, and Collaboration Features in Excel

Filters

Exam 8: Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Chart axes are a series of lines that span across the chart at regular intervals.

Sean needs to insert an Excel worksheet in a Word file and to store the document data within the Word file.He should do which of the following?

Katie needs to change the minimum and maximum values on an axis.She should do which of the following?

Word is unable to publish a blog post document directly to a website.

To insert a PDF in a Word document without storing the PDF data within the Word document,which of the following should be done?

Ashley needs to change the color of gridlines in a chart.She should do which of the following?

To identify differences between two versions of a document,which of the following should be done?

To show document revisions in balloons,which of the following should be done?

To add text to the top of a chart,which of the following should be done?

John is working on a document with tracked changes.To move the insertion point to the previous tracked change in the document,he should do which of the following?

To insert a document property in a header,first which of the following should be done?

Susan is working on a document with tracked changes.She wants to see the document as if all changes have been made.Which of the following options should she select?

Axis titles help viewers interpret a chart by specifying units and other information about the data.

Ashley sent a Word document to multiple collaborators for review.After receiving the reviewed documents back from the collaborators,she now wants to view all the changes and comments in a single document.She should do which of the following?

To correct a data error in a chart,which of the following should be done?

To make a document read-only,check the document for accessibility.

Danielle wants a legend to appear below a chart.She should do which of the following?

To show document revisions inline,which of the following should be done?

To change the color scheme of a chart,select the chart and click Change Colors.

To quickly change the appearance of a chart without changing the way information is represented,which of the following should be done?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Formula Auditing, Data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, Visual Basic for Applications Vba, and Collaboration Features in Excel

Filters