Homework answers / question archive / New Perspectives Word 2019 | Module 7: SAM Project 1b Cortez Accounting COLLABORATING ON A REPORT GETTING STARTED   Open the file NP_WD19_7b_ FirstLastName _1

New Perspectives Word 2019 | Module 7: SAM Project 1b Cortez Accounting COLLABORATING ON A REPORT GETTING STARTED   Open the file NP_WD19_7b_ FirstLastName _1

MS Word

Share With

---

New Perspectives Word 2019 | Module 7: SAM Project 1b

Cortez Accounting

COLLABORATING ON A REPORT

GETTING STARTED

 

Open the file

NP_WD19_7b_

FirstLastName

_1.docx

, available for download from the

SAM website.

 

Save the file as

NP_WD19_7b_

FirstLastName

_2.docx

by changing the “1” to a “2”.

 

If you do not see the .docx file extension in the Save As dialog box, do not type it. The

program will add the file extension for you automatically.

 

To complete this SAM Project, you will also need to download and save the following data

files from the SAM website onto your computer:

 

Support_WD19_7b_Comparison.xlsx

 

Support_WD19_7b_Costs.xlsx

 

Support_WD19_7b_Deal.docx

 

Support_WD19_7b_Manuel.docx

 

In this Project, you will Combine two Word documents. Be sure to save your completed

file as

NP_WD19_7b_

FirstLastName

_2.docx

after completing the Project Steps and

before submitting your file for grading.

PROJECT STEPS

1.

You are working as an intern at Cortez Accounting, a small accounting firm, and have

been researching the advantages and disadvantages of buying and leasing a vehicle.

Manuel Cortez, the firm's owner, asked you to write a report summarizing your findings.

He has reviewed a draft of the report using tracked changes. You will respond to his

comments and add his revisions to the report to complete it.

Combine documents as follows to incorporate Manuel's revisions and comments into

your copy of the report:

a.

Combine your document (the original document) with the file

Support_WD19_7b_Manuel.docx

.

[Mac Hint: If prompted, select the file to grant

access.]

b.

Select all the Comparison settings and show changes in the original document.

2.

Turn on Track Changes and display

All Markup

for review. Accept and reject tracked

changes in the document as follows:

a.

Accept each change in the first body paragraph because the changes improve the

paragraph.

b.

In the second body paragraph, reject the change to the text "The choice between

leasing and buying" so that the bold formatting is removed.

c.

Accept the remaining changes in the document, which are also improvements.

3.

On page 2, with Tracked Changes on, apply the

Heading 1

style to the heading

"Executive Summary" because this heading begins a new major topic.

4.

Turn off Track Changes. Read the first comment in the document, and then respond to

Manuel's request as follows:

a.

In the first blank paragraph on page 3, insert a pie chart.

b.

Type the chart data as shown in Figure 1.

c.

Change the chart colors to

Monochromatic Palette 1

.

Figure 1: Pie Chart Data

5.

Read the second comment in the document, and then respond to Manuel's request as

follows:

a.

Open the workbook

Support_WD19_7b_Costs.xlsx

.

b.

In the

Lease and Buy Costs

worksheet, copy the column chart.

c.

Return to the report document, and then move the insertion point to where Manuel

instructs you to insert a column chart comparing the value of a leased, new, and

used car.

d.

Link the chart to the document using the destination theme to keep the chart data

the same in both locations while using the report document's theme.

e.

Close

Support_WD19_7b_Costs.xlsx

.

6.

Modify the linked chart as follows to suit the design of the Word document and to update

data:

a.

In the report document, add

Lease and Buy Costs

as the chart title.

b.

Change the chart style to

Style 6

to emphasize the columns.

c.

Edit the data in the linked chart by changing the value in cell C4 to

7000

to use the

correct number, and then save and close the Excel workbook.

7.

Read the next comment in the document, and then continue editing as follows:

a.

Open the workbook

Support_WD19_7b_Comparison.xlsx

.

b.

In the

Payments

worksheet, copy cells A1:C5.

c.

Return to the report document, and then move the insertion point to where Manuel

instructs you to insert the spreadsheet data.

d.

Use

Paste Special

to embed the worksheet selection in the Word document as a

Microsoft Excel Worksheet Object

so that it retains the layout of the original

worksheet. The source data is unlikely to change, so you do not need to link it to

the source file.

e.

Modify the embedded worksheet by formatting the text in row 5 using the

Automatic

font color.

f.

Close

Support_WD19_7b_Comparison.xlsx

.

8.

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

9.

On the last page in the document, insert a bookmark to the "Summary" heading using

Comparison

as the bookmark name to make it easy to find the table comparing

payment data.

10.

On page 2, in the paragraph before the "Advantages of Buying" heading, format the word

"spreadsheet" as a hyperlink to the "Comparison" bookmark.

11.

Insert another hyperlink as follows to make it easy for readers to access an external

document:

a.

In the last paragraph in the document, format the text "Finding the Best Car Lease"

as a hyperlink that targets the document

Support_WD19_7b_Deal.docx

.

b.

Add a ScreenTip with the following text:

Advice about making a leasing deal

Your document should look like the Final Figure on the following pages. Save your changes, close

the document, and then exit Word. Follow the directions on the SAM website to submit your

completed project.