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

Question 1

To insert a preformatted table template in a document,Insert a Quick Table.

Answer 1

True

Question 2

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

Answer 2

False

Question 3

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

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

Answer 3

A

Question 4

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

Question 5

To keep a record of changes made to a document,enable the Word Count option.

Question 6

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

Question 7

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

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 8

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?

A) Keep Text Only
B) Merge formatting
C) Keep Source Formatting & Embed Workbook
D) Use Destination Theme & Embed Workbook

Question 9

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

Question 10

To add a data point to an X Y Scatter chart,which of the following should be done? Change the chart style.

A) Switch the rows and columns.
B) Enter chart data.
C) Change the chart style.
D) Change the chart type.

Question 11

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

Question 12

To ensure that the correct author information is included in documents,keep the Word user name up-to-date.

Question 13

To create a copy of a chart in a document,use the Cut and Paste commands.

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

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

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

Question 21

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

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

Question 22

Karen is working on a document with tracked changes.When she clicks Next in the Changes group of the Review tab,which of the following is true?

A) The insertion point will move to the next tracked change,bypassing any comments.
B) The insertion point will move to the next comment,bypassing any edits.
C) The insertion point will move to the next tracked change,which might be a comment or an edit.

Question 23

Jasmine wants a line to appear around a chart,she should do which of the following?

A) Modify the text outline of the chart.
B) Modify the text fill of the chart.
C) Add a shape outline to the chart.
D) Add a shape fill to the chart.

Question 24

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

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

Question 25

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

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

Question 26

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

A) Use the Blog post template.
B) Use the Fax cover sheet template.
C) Use the Business letter template.
D) Use the Report design template.

Question 27

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

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 28

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

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

Question 29

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?

A) Keep Source Formatting & Embed Workbook
B) Use Destination Theme & Embed Workbook
C) Keep Text Only.
D) Merge formatting.

Question 30

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

A) Insert a date picker content control.
B) Insert a calendar based quick table.
C) Insert a SmartArt object.
D) Insert a quick part.

Question 31

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?

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

Question 32

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

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

Question 33

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?

A) Delete the data in the Excel file before sending the Word document.
B) Edit the data in the Excel file before sending the Word document.
C) Refresh the data in the Excel object before sending the Word document.
D) Break the link to the Excel file before sending the Word document.

Question 34

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?

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 35

Aaron needs to see the tracked changes from Katherine,one of his editors.The file has been modified by multiple people.He should do which of the following?

A) Show markup only from Katherine.
B) Show markup from all reviewers.
C) Restrict document editing.
D) Reject all changes.

Question 36

Jane received a document that has tracked changes.To view the insertions and deletions,she should do which of the following?

A) View all markup.
B) View original.
C) View no markup.
D) View simple markup.

Question 37

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

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 38

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

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

Question 39

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

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

Question 40

To add information about the horizontal and vertical extent of a chart,which of the following should be done?

A) Add axes to the chart.
B) Add a trendline to the chart.
C) Add error bars to the chart.
D) Add a legend to the chart.

Question 41

Aaron needs to copy a chart from an Excel file and paste it into a Word document.He wants the chart to retain its original formatting.He should select which of the following paste options?

A) Keep Text Only.
B) Merge formatting.
C) Keep Source Formatting & Embed Workbook
D) Use Destination Theme & Embed Workbook

Question 42

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

A) Click the Change Colors button.
B) Click the Change Chart Type button.
C) Click the Switch Row/Column button.
D) Click the Quick Layout button.

Question 43

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?

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

Question 44

Adam is working on a document with a chart that has incorrect data.To correct the errors,he should do which of the following?

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

Question 45

Karen is working on a document with track changes.She wants to view a list of comments and formatting changes alongside the page,and she wants revisions to be displayed inline.She should select which of the following options?

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

Question 46

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?

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 47

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

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 48

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

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

Question 49

To display information in a histogram,do which of the following?

A) Insert a Chart.
B) Insert a 3D Model.
C) Insert SmartArt.
D) Insert WordArt.

Question 50

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

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

Question 51

Opal needs to add a chart element that describes each of the parts that help make up a chart.She should do which of the following?

A) Insert gridlines.
B) Insert a legend.
C) Insert a chart title.
D) Insert a trendline.

Question 52

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

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

Question 53

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

A) Click add bar.
B) Change the chart style.
C) Enter chart data.
D) Switch the rows and columns.

Question 54

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

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

Question 55

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?

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

Question 56

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?

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

Question 57

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

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 58

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

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

Question 59

Karen needs to change the name that appears when she adds comments to a document.She should do which of the following?

A) Change the user name.
B) Change the document properties.
C) Add a source.
D) Add a recipient.

Question 60

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

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

Question 61

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.

A) Click Hide Source Documents
B) Click Show Original
C) Click Show Revised
D) Click Show Both

Question 62

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

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 63

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

A) Use the Copy and Paste commands.
B) Use the Cut and Paste Commands.
C) Ctrl+drag the chart.
D) Alt+drag the chart.

Question 64

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?

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.

Question 65

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

Question 66

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

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

Question 67

Karen needs to distribute a document,and she wants to discourage the people viewing the document from making changes to it.She should do which of the following?

A) Check the document for spelling and grammar errors.
B) Enable track changes.
C) Check the document for accessibility.
D) Mark the document as final.