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

Adam is working on a document with track changes.He needs to see the final version of a document with inline markups.He should select which of the following display options?

(Multiple Choice)

4.9/5

(36)

Question 21

Karen is working on a report and she needs to include a chart that she created in Excel.She wants the chart to look exactly as it appears in the Excel Workbook.When pasting the chart into the Word document,she should use which of the following paste options?

(Multiple Choice)

4.9/5

(33)

Question 22

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

(Multiple Choice)

4.9/5

(29)

Question 23

To insert a PDF in a Word document and store the PDF data within the Word file,which of the following should be done?

(Multiple Choice)

4.8/5

(38)

Question 24

To change a bar chart to a line chart,change the chart style.

(True/False)

4.8/5

(43)

Question 25

Katie is comparing two documents in Word using the compare command.She wants to see a sentence from the original document.She should do which of the following? Select all that apply.

(Multiple Choice)

4.8/5

(34)

Question 26

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

(Multiple Choice)

4.9/5

(38)

Question 27

To quickly change the color palette of a chart,which of the following should be done?

(Multiple Choice)

4.9/5

(32)

Question 28

Jane has a PowerPoint slide that she would like to display in a Word document.She should do which of the following?

(Multiple Choice)

4.8/5

(35)

Question 29

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

(True/False)

4.8/5

(33)

Question 30

To have text appear alongside each axis in a chart,which of the following should be done?

(Multiple Choice)

4.7/5

(31)

Question 31

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

(True/False)

5.0/5

(29)

Question 32

Jenna needs to create a table that appears like a calendar in a Word document.She should do which of the following?

(Multiple Choice)

4.8/5

(41)

Question 33

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

(True/False)

5.0/5

(29)

Question 34

To copy a chart from one document and paste it in another document while retaining the original appearance,which of the following paste options should be selected?

(Multiple Choice)

4.8/5

(35)

Question 35

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?

(Multiple Choice)

4.8/5

(35)

Question 36

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

(Multiple Choice)

4.8/5

(40)

Question 37

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

(Multiple Choice)

4.9/5

(40)

Question 38

Jacki needs to create a blog post using Word.She should do which of the following?

(Multiple Choice)

4.9/5

(37)

Question 39

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

(Multiple Choice)

4.9/5

(34)

Question 40

Showing 21 - 40 of 67

Adam is working on a document with track changes.He needs to see the final version of a document with inline markups.He should select which of the following display options?

Karen is working on a report and she needs to include a chart that she created in Excel.She wants the chart to look exactly as it appears in the Excel Workbook.When pasting the chart into the Word document,she should use which of the following paste options?

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

To insert a PDF in a Word document and store the PDF data within the Word file,which of the following should be done?

To change a bar chart to a line chart,change the chart style.

Katie is comparing two documents in Word using the compare command.She wants to see a sentence from the original document.She should do which of the following? Select all that apply.

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

To quickly change the color palette of a chart,which of the following should be done?

Jane has a PowerPoint slide that she would like to display in a Word document.She should do which of the following?

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

To have text appear alongside each axis in a chart,which of the following should be done?

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

Jenna needs to create a table that appears like a calendar 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.

To copy a chart from one document and paste it in another document while retaining the original appearance,which of the following paste options should be selected?

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?

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

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

Jacki needs to create a blog post using Word.She should do which of the following?

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