Homework answers / question archive / New Perspectives Word 2019 | Module 7 End of Module project 2 Montville Department of Community Services INTEGRATING FINANCIAL DATA GETTING STARTED • Open the file NP_WD19_EOM7-2_FirstLastName_1

New Perspectives Word 2019 | Module 7 End of Module project 2 Montville Department of Community Services INTEGRATING FINANCIAL DATA GETTING STARTED • Open the file NP_WD19_EOM7-2_FirstLastName_1

MS Word

Share With

---

New Perspectives Word 2019 | Module 7 End of Module project 2

Montville Department of Community Services

INTEGRATING FINANCIAL DATA

GETTING STARTED

• Open the file NP_WD19_EOM7-2_FirstLastName_1.docx, available for download from the SAM website.

• Save the file as NP_WD19_EOM7-2_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_EOM7-2_Projections.xlsx

• Support_WD19_EOM7-2_Spending.xlsx

• With the file NP_WD19_EOM7-2_FirstLastName_2.docx still open, ensure that your first and last name is displayed in the footer. 

• If the footer does not display your name, delete the file and download a new copy from the SAM website. 
 

PROJECT STEPS

1. As the assistant to the director of the Department of Community Services in Montville, North Carolina, you are preparing a report to the City Council on the department's current and projected spending on community services. 

On page 3, insert a horizontal line in the blank paragraph before the "Overview of Spending on Community Services" heading to separate the two main sections of the report. Keep the default width, but change the color to Red, Accent 5 to coordinate with the other colors in the report.

2. Open the Excel workbook Support_WD19_EOM7-2_Spending.xlsx, and then copy the data in the range A4:E10 so that you can include the spending data in the report.

On page 3 of the Word document, select the "[Insert spreadsheet]" placeholder text, and then paste the data as a link while keeping source formatting.

3. The spending amount for Recreation programs in 2020 is incorrect. In the Excel workbook Support_WD19_EOM7-2_Spending.xlsx, use $210,167.32 as the amount in cell D8.

In the Word document, update the linked data, and then break the link to the Excel workbook since you no longer need a connection to it.

4. In the Excel workbook Support_WD19_EOM7-2_Spending.xlsx, copy the column chart in the range A11:E39 so that you can include the chart in the report.

In the Word document, select the "[Insert column chart]" placeholder text, and then use a Paste option to embed the chart while using the source formatting, which matches the formatting of the Word document. Close the Support_WD19_EOM7-2_Spending.xlsx workbook.