1.

Bellingham Consulting, a market research firm, has just finished a customer satisfaction survey for Dana Jean's Cookies. Sylvie Yaaj, a senior consultant, has been working on a report summarizing the survey results. The current draft contains some comments and tracked changes. You will help Sylvie finish the report. Turn on Track Changes and display All Markup for review. On page 2, in the paragraph below the "Executive Summary" heading, remove the italic from the text "Bellingham Consulting".

Format text using Tracked Changes.

2.

Apply the Heading 1 style to the heading "Background".

Apply a style using Tracked Changes.

3.

Apply bold to the last three paragraphs in the document, which contain the company name, Sylvie's name and title, and her phone number.

Format text using Tracked Changes.

4.

In the first paragraph after the heading "Executive Summary," accept each of the changes individually.

Accept a change.

Accept a change.

Accept a change.

5.

In the second paragraph after the heading "Executive Summary," accept each of the changes in the first two sentences individually. Reject each of the changes in the last sentence individually.

Accept a change.

Accept a change.

Accept a change.

Accept a change.

Reject a change.

Reject a change.

6.

In the first paragraph after the heading "Background," accept each of the changes individually.

Accept a change.

Accept a change.

Accept a change.

7.

Turn off Track Changes. Read the first comment in the document, and then continue editing as follows: a. Use Microsoft Excel to open the workbook Support_NP_WD16_7a_Data.xlsx, available for download from the SAM website. b. In the Sheet1 worksheet, copy cells A1:G6. c. Return to the file NP_WD16_7a_FirstLastName_2.docx, and then move the insertion point to where Sylvie's comment instructs you to insert the product ratings. d. Use the Paste Special feature to embed the worksheet selection in the Word document as a Microsoft Excel Worksheet Object. Embedding it will ensure that it retains the layout of the original worksheet. There's no need to link it to the source file, because the data in the source file is unlikely to change in the future. e. Modify the embedded worksheet by changing the percentages in cell C3 to 57-65%.

Embed cells from an Excel worksheet.

Modify an embedded Excel worksheet.

8.

Read the next comment in the document, and then continue editing as follows: a. Use Microsoft Excel to open the workbook Support_NP_WD16_7a_Chart.xlsx, available for download from the SAM website. b. In the Sheet1 worksheet, copy the clustered column chart. c. Return to the file NP_WD16_7a_FirstLastName_2.docx, and then move the insertion point to where Sylvie's comment instructs you to insert the chart. d. Link the chart to the document using the destination theme. Sylvie prefers to use linking in this case, because the data in the source file is likely to change in the future.

Link a chart from Excel.

9.

Delete all of the comments in the document because they are no longer needed.

Delete all comments.

10.

In the paragraph below the linked chart, format the word "here" as a hyperlink that targets the document Support_NP_WD16_7a_Methods.docx.

Hyperlink to a file.

11.

On page 3, select the first word in the paragraph before the chart ("The"), and then insert a bookmark using Ratings as the name.

Insert a bookmark.

12.

On page 2, in the sentence before the heading "Background," format the text "ratings" as a hyperlink linked to the "Ratings" bookmark.

Hyperlink to a bookmark.

13.

Delete the "Bellingham" bookmark, because it will not be used in this report.

Delete a bookmark.

14.

At the end of the document, use the Borders menu to insert a horizontal line before the "Bellingham Consulting" paragraph.

Insert a horizontal line.