Question 1

To quickly change the appearance of a chart,change the chart style.

Accepted Answer

A) True 
 B)False

Question 2

To send a viewable version of a document to a collaborator who does not have Microsoft Office or Adobe Acrobat installed,which of the following should be done?

Accepted Answer

A)  Email the document as an XPS file. 
B)  Email the document as a PDF file. 
C)  Email the document as a Word file. 
D)  Email the document as an XML file. 
A)  Email the document as an XPS file. 
B)  Email the document as a PDF file. 
C)  Email the document as a Word file. 
D)  Email the document as an XML file.

Question 3

A legend is an area of a chart that helps describe each of the parts that help make up a chart.

Accepted Answer

A) True 
 B)False

Question 4

You can create a blog post in Word using a template.

Accepted Answer

A) True 
 B)False

Question 5

To copy a table from one document to another document while retaining the original formatting,use which of the following paste options?

Accepted Answer

A)  Keep Source Formatting. 
B)  Merge Formatting. 
C)  Use Destination Styles. 
D)  Keep Text Only. 
A)  Keep Source Formatting. 
B)  Merge Formatting. 
C)  Use Destination Styles. 
D)  Keep Text Only.

Question 6

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 7

Which of the following definitions describes an XPS file?

Accepted Answer

A)  A portable file format developed by Microsoft that defines the layout,appearance,and printing information for a document. 
B)  A portable file format developed by Adobe Systems that defines the layout,appearance,and printing information for a document. 
C)  A file format that describes the layout and appearance of a webpage. 
D)  A file format that describes the formatting of a webpage. 
A)  A portable file format developed by Microsoft that defines the layout,appearance,and printing information for a document. 
B)  A portable file format developed by Adobe Systems that defines the layout,appearance,and printing information for a document. 
C)  A file format that describes the layout and appearance of a webpage. 
D)  A file format that describes the formatting of a webpage.

Question 8

Kim has an Excel worksheet that she would like to display in a Word document.She should do which of the following?

Accepted Answer

A)  Take a screenshot of the Excel worksheet and paste it in the Word document. 
B)  Copy text from the Excel worksheet and paste it in the Word document. 
C)  Insert the Word document as an object in the Excel worksheet. 
D)  Insert the Excel worksheet as an object in the Word document. 
A)  Take a screenshot of the Excel worksheet and paste it in the Word document. 
B)  Copy text from the Excel worksheet and paste it in the Word document. 
C)  Insert the Word document as an object in the Excel worksheet. 
D)  Insert the Excel worksheet as an object in the Word document.

Question 9

Use the Combine command to compare and identify the differences between two saved versions of a document.

Accepted Answer

A) True 
 B)False

Question 10

Aaron is working on a document that contains Excel documents inserted as linked objects.He made a change to one of the Excel documents.To ensure the Word document reflects this change,he should do which of the following?

Accepted Answer

A)  Update the linked objects. 
B)  Break the link. 
C)  Change the link source. 
A)  Update the linked objects. 
B)  Break the link. 
C)  Change the link source.

Question 11

Gabrielle accidentally deleted several paragraphs in her document.To restore her work,she should do which of the following?

Accepted Answer

A)  Recover unsaved changes using the Info screen of the File tab. 
B)  Retype the missing paragraphs. 
C)  Save the document,close it,and then reopen it. 
D)  Inspect the document. 
A)  Recover unsaved changes using the Info screen of the File tab. 
B)  Retype the missing paragraphs. 
C)  Save the document,close it,and then reopen it. 
D)  Inspect the document.

Question 12

Karen is working on a document that she received from her editor.She wants to incorporate all the changes that the editor made to the document.She should do which of the following?

Accepted Answer

A)  Use the Combine command. 
B)  Use the Compare command. 
C)  Reject all changes. 
D)  Accept all changes. 
A)  Use the Combine command. 
B)  Use the Compare command. 
C)  Reject all changes. 
D)  Accept all changes.

Question 13

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 14

Karen needs to remove all changes applied to a document with track changes.She should do which of the following?

Accepted Answer

A)  Accept all changes. 
B)  Reject all changes. 
C)  Use the Compare command. 
D)  Use the Combine command. 
A)  Accept all changes. 
B)  Reject all changes. 
C)  Use the Compare command. 
D)  Use the Combine command.

Question 15

Sharon has copied text from a website that she plans to paste in a Word document.She wants the text to match the formatting of other text in the document.She should do which of the following?

Accepted Answer

A)  Keep Text Only 
B)  Picture 
C)  Keep Source Formatting 
D)  Use Destination Theme 
A)  Keep Text Only 
B)  Picture 
C)  Keep Source Formatting 
D)  Use Destination Theme

Question 16

To update an Excel chart inserted into a Word document,which of the following should be done?

Accepted Answer

A)  Click Edit Data. 
B)  Click Select Data. 
C)  Click Refresh Data. 
D)  Click Switch Row/Column. 
A)  Click Edit Data. 
B)  Click Select Data. 
C)  Click Refresh Data. 
D)  Click Switch Row/Column.

Question 17

Data labels specify the numerical values of data in a chart.

Accepted Answer

A) True 
 B)False

Question 18

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 19

Kevin has a weblink in a document.He wants people to be able to CTRL+click the weblink to access the corresponding website.He should do which of the following?

Accepted Answer

A)  Add a table. 
B)  Add an endnote. 
C)  Add a citation. 
D)  Add a hyperlink. 
A)  Add a table. 
B)  Add an endnote. 
C)  Add a citation. 
D)  Add a hyperlink.

Question 20

To add a border around a chart,add a shape outline to the chart.
​

Accepted Answer

A) True 
 B)False

To quickly change the appearance of a chart,change the chart style.

To send a viewable version of a document to a collaborator who does not have Microsoft Office or Adobe Acrobat installed,which of the following should be done?

A legend is an area of a chart that helps describe each of the parts that help make up a chart.

You can create a blog post in Word using a template.

To copy a table from one document to another document while retaining the original formatting,use which of the following paste options?

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

Which of the following definitions describes an XPS file?

Kim has an Excel worksheet that she would like to display in a Word document.She should do which of the following?

Use the Combine command to compare and identify the differences between two saved versions of a document.

Aaron is working on a document that contains Excel documents inserted as linked objects.He made a change to one of the Excel documents.To ensure the Word document reflects this change,he should do which of the following?

Gabrielle accidentally deleted several paragraphs in her document.To restore her work,she should do which of the following?

Karen is working on a document that she received from her editor.She wants to incorporate all the changes that the editor made to the document.She should do which of the following?

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

Karen needs to remove all changes applied to a document with track changes.She should do which of the following?

Sharon has copied text from a website that she plans to paste in a Word document.She wants the text to match the formatting of other text in the document.She should do which of the following?

To update an Excel chart inserted into a Word document,which of the following should be done?

Data labels specify the numerical values of data in a chart.

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

Kevin has a weblink in a document.He wants people to be able to CTRL+click the weblink to access the corresponding website.He should do which of the following?

To add a border around a chart,add a shape outline to the chart.

Getting Started With Excel: Tracking Miscellaneous Expenses for a Conference

Formatting Workbook Text and Data: Creating a Sales Report

Performing Calculations With Formulas and Functions: Staffing a Call Center

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

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 7: Summarizing Data With Pivottables: Preparing a Social Media Marketing Report

To quickly change the appearance of a chart,change the chart style.

To send a viewable version of a document to a collaborator who does not have Microsoft Office or Adobe Acrobat installed,which of the following should be done?

A legend is an area of a chart that helps describe each of the parts that help make up a chart.

You can create a blog post in Word using a template.

To copy a table from one document to another document while retaining the original formatting,use which of the following paste options?

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

Which of the following definitions describes an XPS file?

Kim has an Excel worksheet that she would like to display in a Word document.She should do which of the following?

Use the Combine command to compare and identify the differences between two saved versions of a document.

Aaron is working on a document that contains Excel documents inserted as linked objects.He made a change to one of the Excel documents.To ensure the Word document reflects this change,he should do which of the following?

Gabrielle accidentally deleted several paragraphs in her document.To restore her work,she should do which of the following?

Karen is working on a document that she received from her editor.She wants to incorporate all the changes that the editor made to the document.She should do which of the following?

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

Karen needs to remove all changes applied to a document with track changes.She should do which of the following?

Sharon has copied text from a website that she plans to paste in a Word document.She wants the text to match the formatting of other text in the document.She should do which of the following?

To update an Excel chart inserted into a Word document,which of the following should be done?

Data labels specify the numerical values of data in a chart.

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

Kevin has a weblink in a document.He wants people to be able to CTRL+click the weblink to access the corresponding website.He should do which of the following?

To add a border around a chart,add a shape outline to the chart. ​

Getting Started With Excel: Tracking Miscellaneous Expenses for a Conference

Formatting Workbook Text and Data: Creating a Sales Report

Performing Calculations With Formulas and Functions: Staffing a Call Center

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

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

To add a border around a chart,add a shape outline to the chart.