1.

Fast City Rentals connects traveling bicyclists with bike shops across the country. The company's Marketing & Sales Department recently completed a customer survey, and Gil Koslov, a marketing analyst, is working on a report to summarize the results. The current draft contains some comments and tracked changes. You will help Gil 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 bold from the text "Fast City Rentals".

Format text using Tracked Changes.

2.

Apply the Heading 1 style to the heading "Company Background" to indicate this heading begins a new major topic.

Apply a style using Tracked Changes.

3.

Apply italic to the last three paragraphs in the document to set the department name, Gil's name and title, and his phone number apart from surrounding text.

Format text using Tracked Changes.

4.

In the first paragraph after the heading "Executive Summary" accept each change because the text and formatting changes enhance the paragraph.

Accept a change.

Accept a change.

Accept a change.

5.

In the second paragraph after the heading "Executive Summary" accept the first two changes, which clarify the content, and reject the third change, which does not improve the content.

Accept a change.

Reject a change.

6.

Accept all of the changes in the three paragraphs following the "Company Background" heading.

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_7b_Rankings.xlsx, available for download from the SAM website. b. In the Rankings worksheet, copy cells A1:F6. c. Return to the file NP_WD16_7b_FirstLastName_2.docx, and then move the insertion point to where Gil's comment instructs you to insert the ranking data. d. Use the Paste Special feature to embed the worksheet selection in the Word document as a Microsoft Excel Worksheet Object to ensure that it retains the layout of the original worksheet. You do not 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 number in cell D4 to 50 and the number in cell E4 to 150 to use accurate data.

Embed cells from an Excel worksheet.

Update an embedded Excel worksheet.

Update 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_7b_Pie_Chart.xlsx, available for download from the SAM website. b. In the Overall Ratings worksheet, copy the 3-D pie chart. c. Return to the file NP_WD16_7b_FirstLastName_2.docx, and then move the insertion point to where Gil's comment instructs you to insert the chart. d. Link the chart to the document using the destination theme. Gil 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_7b_Selection.docx, available for download from the SAM website.

Hyperlink to a file.

11.

On page 3, select the first word in the paragraph before the chart ("Participants"), and then insert a bookmark using Chart as the name to prepare for inserting a hyperlink that makes it easier to find the chart.

Insert a bookmark.

12.

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

Hyperlink to a bookmark.

13.

Delete the "Author" 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 "Marketing & Sales Department" paragraph to separate the address information from the rest of the document.

Insert a horizontal line.