Deck 7: Summarizing Data With Pivottables

Question 1

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.

Answer 1

A

Question 2

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
D) ​

Answer 2

B

Question 3

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

Answer 3

C

Question 4

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 insert a citation.

Question 5

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.
D) ​

Question 6

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 7

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.

Question 8

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

Question 9

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 10

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 11

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

Question 12

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 13

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 14

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

Question 15

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

Question 16

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 17

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

Question 18

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 19

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.

Question 20

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 21

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

Question 22

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 23

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

Question 24

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

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

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 27

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 28

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

Question 29

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 30

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 31

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

Question 32

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 33

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 34

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 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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 40

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 41

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 42

To view a list of the comments in a document, open the Navigation pane.

Question 43

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 44

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 45

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 46

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

Question 47

To view revisions to a document, select All Markup.

Question 48

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 49

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 50

To remove changes to a document, click Accept All Changes.

Question 51

To incorporate all revisions to a document, click Reject All Changes.

Question 52

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 53

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

Question 54

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 55

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 56

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 57

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

Question 58

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

Question 59

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

Question 60

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

Question 61

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 62

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 63

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 64

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 65

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.
D) ​

Question 66

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 67

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 68

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 69

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 70

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.
D) ​

Question 71

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 72

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 73

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 74

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 75

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 76

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 77

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 78

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 79

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
D) ​

Question 80

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
D) ​