Exam 7: Summarizing Data With Pivottables

To add a data point to an X Y Scatter chart, 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?

Jane needs to recolor a line in a Line chart. She should do which of the following?

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

Sharon needs to send a Word document to a client. The Word document contains a link to an Excel file. She does not want to send the Excel file with the Word document. She should do which of the following?

Bookmark names cannot include which of the following characters?

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 add a bar to a bar chart, which of the following should be done?

To view revisions and formatting in balloons, select the Show Only Comments and Formatting in Balloons option.

Amy needs to create a copy of a chart in a document. She should do which of the following? Select all that apply.

To create a page color, 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.

To go to a bookmark in a document, which of the following should be done?

To ensure linked objects in a document are up-to-date, click Update Link.

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?

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

To display information on coordinate axes, insert a SmartArt object.

To have text appear over a hyperlink when you hover your mouse over the link, which of the following should be done?

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

A chart title is positioned vertically alongside the vertical chart axis.