Deck 7: Summarizing Data With Pivottables: Preparing a Social Media Marketing Report

Question 1

Justin needs to efficiently share a Word document with collaborators.He should do which of the following?

A) Share the document via OneDrive.
B) Share the document as a PDF attached to an email.
C) Save the document to a local hard drive for distribution.
D) Save the document to a portable hard drive for distribution.

Answer 1

A

Question 2

To email a document to clients who may or may not have Microsoft Office installed,which of the following should be done?

A) Email the document as a .pdf file.
B) Email the document as a .xml file.
C) Email the document as a .docx file.
D) Email the document as a .doc file.

Answer 2

A

Question 3

To modify the target of a hyperlink in a document,right-click the hyperlink and then click Edit Hyperlink.

Answer 3

True

Question 4

To see how your documents will look if used in an online environment.

A) Read Mode.
B) Print Layout view.
C) Web Layout view.
D) Outline view.

Question 5

Gabrielle accidentally deleted several paragraphs in her document.To restore her work,she should do which of the following?

A) Recover unsaved changes using the Info screen of the File tab.
B) Retype the missing paragraphs.
C) Save the document,close it,and then reopen it.
D) Inspect the document.

Question 6

Caleb needs to copy a picture from one document and paste it in another document in such a way that it retains the original appearance.He should use which of the following paste options?

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

Question 7

Joshua needs to send a document to a collaborator using Outlook.He should do which of the following?

A) Email the document as an attachment.
B) Save the document to a local hard drive.
C) Save the document to an external hard drive.
D) Export the document as a PDF.

Question 8

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

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

Question 9

Jasmine is creating a webpage in Word.She should save her document using which of the following extensions?

A) .docx
B) .doc
C) .html
D) .xps

Question 10

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 do which of the following?

A) Add a table.
B) Add an endnote.
C) Add a citation.
D) Add a hyperlink.

Question 11

Sharon needs to send a document to clients who may or may not have Microsoft Office installed.She should send the document as a PDF.

Question 12

Imani needs to copy text from one document into another document.She needs the pasted text to retain its original appearance.When she pastes the text,she should use which of the following settings?

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

Question 13

Susanne accidentally deleted an important paragraph in her document.She can recover the paragraph by selecting the appropriate autosaved version of the document in the Info screen of the File tab.

Question 14

Which of the following definitions describes an XPS file?

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 15

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

Question 16

The most efficient way to share a Word document with collaborators is to save the document to a portable hard drive for distribution.

Question 17

To have text appear over a hyperlink when you hover your mouse over the link,add ScreenTip text to the link.

Question 18

Web Layout view allows you to see how your documents will look if used in an online environment.

Question 19

Joan has a redundant source in her bibliography.What is the best way for her to remove this redundant source from the bibliography?

A) Remove all text from the redundant source by editing it in the Source Manager,then update the bibliography.
B) Manually delete the source from the bibliography.
C) Delete the redundant source in the Source Manager,then update the bibliography.

Question 20

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

A) Specify the display text of the link.
B) Add an address to the link.
C) Specify a Target Frame for the link.
D) Add ScreenTip text to the link.

Question 21

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

Question 22

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

Question 23

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

Question 24

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

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

Question 25

To send a viewable version of a document to a collaborator who does not have Microsoft Office or Adobe Acrobat installed,which of the following should be done?

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

Question 26

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

Question 27

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

Question 28

Sharon has copied text from a website that she plans to paste in a Word document.She wants the text to match the formatting of other text in the document.She should do which of the following?

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

Question 29

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

Question 30

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?

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 31

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

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 32

To send a Word document to a collaborator using an email client,which of the following should be done?

A) Save the document to a portable hard drive.
B) Save the document to a local hard drive.
C) Share the document via OneDrive.
D) Email the document as an attachment.

Question 33

To publish a Word document as a webpage,save the document in which of the following formats?

A) .html
B) .xps
C) .doc
D) .docx

Question 34

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

Question 35

Derek needs to modify the information a user sees when moving the mouse over a hyperlink in a document.He should do which of the following?

A) Insert a citation.
B) Insert a reference.
C) Edit the document text.
D) Edit the hyperlink.

Question 36

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

Question 37

Leo needs to have text appear over a hyperlink when the mouse hovers over the link.He should do which of the following?

A) Insert a text box.
B) Insert WordArt.
C) Modify the hyperlink's target frame.
D) Add a ScreenTip to a hyperlink.

Question 38

Lucy needs to see how her document will look if used in an online environment.She should do which of the following?

A) Switch to Outline view.
B) Switch to Web Layout view.
C) Switch to Print Layout view.
D) Switch to Read Mode.

Question 39

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

Question 40

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

Question 41

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 42

A legend is an area of a chart that helps describe each of the parts that help make up a chart.

Question 43

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 44

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

Question 45

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 46

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

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

Question 47

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 48

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 49

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 50

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 51

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 52

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 53

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.

Question 54

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 55

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 56

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

Question 57

The Combine command is used to combine the changes and comments of multiple reviewers into a single document when each reviewer edits the document using a separate copy of the original.

Question 58

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 59

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 60

To view revisions to a document,select All Markup.

Question 61

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 62

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 63

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 64

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 65

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 66

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 67

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 68

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 69

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 70

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 71

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 72

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 73

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 74

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 75

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 76

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 77

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 78

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 79

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 80

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.