Question 1

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

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

To copy text from one document to another document while retaining the original appearance, which of the following should be done?

Accepted Answer

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

Question 4

To share a document via a hyperlink in an email, which of the following should be done?

Accepted Answer

A)  Share the document via OneDrive. 
B)  Send the document as an email attachment. 
C)  Save the document to a portable hard drive. 
D)  Export the document as a PDF. 
A)  Share the document via OneDrive. 
B)  Send the document as an email attachment. 
C)  Save the document to a portable hard drive. 
D)  Export the document as a PDF.

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

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

To enable people to immediately scroll to a bookmark by clicking text in a document, which of the following should be done?

Accepted Answer

A)  Select the desired text and insert a hyperlink to the desired bookmark. 
B)  Select the desired text and apply a text effect. 
C)  Mark the desired text as an index entry. 
D)  Mark the desired text as a citation for a table of authorities. 
A)  Select the desired text and insert a hyperlink to the desired bookmark. 
B)  Select the desired text and apply a text effect. 
C)  Mark the desired text as an index entry. 
D)  Mark the desired text as a citation for a table of authorities.

Question 10

To view revisions to a document, select All Markup.

Accepted Answer

A) True 
 B)False

Question 11

To add numerical information about data in a chart, which of the following should be done?

Accepted Answer

A)  Add data labels to the chart. 
B)  Add error bars to the chart. 
C)  Add gridlines to the chart. 
D)  Add a trendline to the chart. 
A)  Add data labels to the chart. 
B)  Add error bars to the chart. 
C)  Add gridlines to the chart. 
D)  Add a trendline to the chart.

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Joe needs to email a viewable document to a client who may or may not have Microsoft Office installed. He should do which of the following?

Accepted Answer

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

Question 14

To view a list of the comments in a document, which of the following should be done?

Accepted Answer

A)  Display the Reviewing pane. 
B)  Display the Researcher pane. 
C)  Display the Navigation pane. 
D)  Display the Editor pane. 
A)  Display the Reviewing pane. 
B)  Display the Researcher pane. 
C)  Display the Navigation pane. 
D)  Display the Editor pane.

Question 15

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 insert a citation.

Accepted Answer

False - hyperlink
Fa

Question 16

To edit the source data of a linked chart, 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

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 18

To publish a document on the internet, save it as an HTML file.

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

Accepted Answer

A) True 
 B)False

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

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

To copy text from one document to another document while retaining the original appearance, which of the following should be done?

To share a document via a hyperlink in an email, which of the following should be done?

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

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

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

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 enable people to immediately scroll to a bookmark by clicking text in a document, which of the following should be done?

To view revisions to a document, select All Markup.

To add numerical information about data in a chart, which of the following should be done?

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

Joe needs to email a viewable document to a client who may or may not have Microsoft Office installed. He should do which of the following?

To view a list of the comments in 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 insert a citation.

To edit the source data of a linked chart, which of the following should be done?

Which of the following definitions describes an XPS file?

To publish a document on the internet, save it as an HTML file.

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

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

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

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Filters

Exam 7: Summarizing Data With Pivottables

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

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

To copy text from one document to another document while retaining the original appearance, which of the following should be done?

To share a document via a hyperlink in an email, which of the following should be done?

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

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

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

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 enable people to immediately scroll to a bookmark by clicking text in a document, which of the following should be done?

To view revisions to a document, select All Markup.

To add numerical information about data in a chart, which of the following should be done?

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

Joe needs to email a viewable document to a client who may or may not have Microsoft Office installed. He should do which of the following?

To view a list of the comments in 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 insert a citation.

To edit the source data of a linked chart, which of the following should be done?

Which of the following definitions describes an XPS file?

To publish a document on the internet, save it as an HTML file.

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

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

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

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Filters

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