Question 1

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

Accepted Answer

By selecting "Keep Source Formatting & Embed Workbook," the chart will be pasted with its original formatting and any updates to the chart in Excel will be reflected in the pasted version in Word. Embedding the workbook ensures that the chart can be edited if necessary without having to go back to the original Excel file.

Question 2

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.

Accepted Answer

To quickly change the color palette of a chart, clicking the Change Colors button is the best option.

Question 3

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.

Accepted Answer

To reflect the change made in the linked Excel document, Aaron needs to update the linked object in the Word document. This will ensure that any changes made in the linked Excel document are reflected in the Word document. Breaking the link or changing the link source are not relevant actions in this scenario.

Question 4

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.

Accepted Answer

To correct the incorrect data in the chart, Adam should edit the chart data. This involves identifying and correcting the erroneous values in the underlying dataset that the chart is based on. Changing the chart type or style would not correct the data itself, but only change its visual representation. Similarly, entering new chart data would not correct the errors in the existing data.

Question 5

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.

Accepted Answer

The answer of Karen is working on a document with...

Question 6

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.

Accepted Answer

The answer of Ashley sent a Word document to multiple...

Question 7

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.

Accepted Answer

Adding data labels to a chart is the best way to add numerical information about the data. Data labels can show the exact values of each data point, making it easy to read and interpret the chart. Error bars are used to indicate the variability of the data, gridlines are used to help with reading the chart, and a trendline is used to show the overall trend of the data. While all these options may be useful in certain contexts, adding data labels is the best choice to add numerical information to a chart.

Question 8

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.

Accepted Answer

The Compare command is the best choice for identifying differences between two versions of a document.

Question 9

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.

Accepted Answer

A histogram is a type of chart used to display data distribution. Therefore, inserting a chart is the best choice to display information in a histogram. The other options (B, C, and D) are not appropriate for creating a histogram.

Question 10

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.

Accepted Answer

Rejecting all changes will remove all the changes and restore the original document to its previous state before any changes were made. Accepting all changes will confirm all the changes and the document will remain with the changes applied. The Compare command will create a new document highlighting the changes made between two versions of the same document but will not remove the changes made in the original document. The Combine command will merge two or more versions of a document, but it will not remove the changes made to the original document.

Question 11

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.

Accepted Answer

A legend is used to describe the different parts of a chart, such as the different data series or categories. Gridlines, a chart title, and a trendline do not provide descriptions of the chart elements.

Question 12

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.

Accepted Answer

To change the minimum and maximum values on an axis, Katie should format the chart axis. This will allow her to adjust the scale of the axis to better fit the range of values in the data.

Question 13

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.

Accepted Answer

To add a bar to a bar chart, you should enter or modify the chart data. This involves adding or adjusting the data that the chart is based on, which in turn will reflect as an additional bar in the chart if you are adding a new data point.

Question 14

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.

Accepted Answer

Changing the chart type from a line chart to a bar chart is the way to visualize the data with bars instead of lines. This can usually be done by right-clicking on the chart and selecting "Change Chart Type" or by going to the "Design" tab in the Chart Tools section and selecting "Change Chart Type".

Question 15

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

Accepted Answer

All Markup displays the final version of the document with all the inline markups (insertions, deletions, and formatting changes), which is what Adam needs to see the changes made to the document.

Question 16

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.

Accepted Answer

To incorporate all the changes made by the editor, Karen should accept all changes. This ensures that all the changes made by the editor are included in the final version of the document. Using the "Accept" command saves time by eliminating the need to review and manually accept each change separately.

Question 17

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.

Accepted Answer

To change the color of gridlines in a chart, you should directly click the desired grid line and then select the desired color from the options available. This action allows for specific customization of the chart's appearance.

Question 18

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.

Accepted Answer

Changing the chart style allows for a quick change in appearance without altering the underlying data and information being represented. Changing the chart type or editing the chart data would directly impact the representation of information, and refreshing the chart data would only update the information being displayed, not the appearance.

Question 19

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.

Accepted Answer

Changing the user name in the document settings will change the name that appears when Karen adds comments. The other options are not related to changing the name that appears with comments.

Question 20

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.

Accepted Answer

To view a list of the comments in a document, the reviewing pane needs to be displayed which will show all the comments in the document in a separate pane on the right side of the document window.

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

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?

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

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?

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

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?

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 numerical information about data in a chart,which of the following should be done?

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

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

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

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?

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

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

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

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

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

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

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

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