Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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.

Accepted Answer

A) True 
 B)False

Question 4

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?

Accepted Answer

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

Question 5

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

Accepted Answer

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. 
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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

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. 
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 11

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?

Accepted Answer

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. 
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 12

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

Accepted Answer

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. 
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 have text appear over a hyperlink when you hover your mouse over the link,which of the following should be done?

Accepted Answer

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. 
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 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

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?

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

Hyperlinks in Word are only able to point to websites.

Accepted Answer

A) True 
 B)False

Lucy needs to see how her document will look if used in an online environment.She 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?

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.

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?

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

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

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

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

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

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

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?

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

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

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

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

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?

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

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

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

Hyperlinks in Word are only able to point to websites.

Getting Started With Excel: Tracking Miscellaneous Expenses for a Conference

Formatting Workbook Text and Data: Creating a Sales Report

Performing Calculations With Formulas and Functions: Staffing a Call Center

Analyzing and Charting Financial Data: Preparing an Investment Report

Generating Reports From Multiple Worksheets and Workbooks: Summarizing Profit and Lo

Managing Data With Data Tools: Analyzing Employment Data

Performing What-If Analyses: Maximizing Profits With the Right Product Mix

Exploring Financial Tools and Functions: Analyzing a Business Plan

Analyzing Data With Business Intelligence Tools: Presenting Sales and Revenue Data

Filters

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

Lucy needs to see how her document will look if used in an online environment.She 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?

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.

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?

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

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

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

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

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

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

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?

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

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

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

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

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?

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

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

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

Hyperlinks in Word are only able to point to websites.

Getting Started With Excel: Tracking Miscellaneous Expenses for a Conference

Formatting Workbook Text and Data: Creating a Sales Report

Performing Calculations With Formulas and Functions: Staffing a Call Center

Analyzing and Charting Financial Data: Preparing an Investment Report

Generating Reports From Multiple Worksheets and Workbooks: Summarizing Profit and Lo

Managing Data With Data Tools: Analyzing Employment Data

Performing What-If Analyses: Maximizing Profits With the Right Product Mix

Exploring Financial Tools and Functions: Analyzing a Business Plan

Analyzing Data With Business Intelligence Tools: Presenting Sales and Revenue Data

Filters