Shelly Cashman Word 2019 | Module 8: SAM Project 1a Argos Financial COLLABORATING ON A MEMO WITH CHARTS GETTING STARTED Open the file SC_WD19_8a_FirstLastName_1.docx, available for download from the SAM website. Save the file as SC_WD19_8a_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_8a_DK.docx Support_WD19_8a_Resolution.xlsx Support_WD19_8a_Trust.xlsx With the file SC_WD19_8a_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 You are a financial analyst at Argos Financial, a full-service bank and insurance institution. You and a colleague are collaborating on a memo to your manager that summarizes the data collected in a recent series of customer surveys. You have already received revisions from your colleague. Incorporate changes from your manager as follows: Combine the revisions from the document Support_WD19_8a_DK.docx. Show the changes in the original document. Turn off Track Changes when you are finished. Resolve the tracked changes in the document as follows: Accept the first tracked change from Deanna Kahn, which inserts the company name and removes the placeholder text. Accept the next tracked change, which is from Julie Batista and changes "e-surveys" to "surveys" to remove a redundancy. Reject the next tracked change, which inserts "via email", because it is repetitious. Accept the remaining changes in the document because they improve or correct the writing. In the doughnut chart, use Account Types as the chart title. Embed data from an Excel workbook as follows to include a table Julie created: Open the workbook Support_WD19_8a_Trust.xlsx. Copy the data in cells A2:C10. Use Paste Special to embed the worksheet data as a Microsoft Excel Worksheet Object in the blank paragraph in the "Drivers of Trust" section. Close Support_WD19_8a_Trust.xlsx. Insert a chart as follows to comply with the request Deanna Kahn inserted below the "Customer Problems" table: Select the text "[Insert a chart showing the table data]" below the "Customer Problems" table, and then insert a Clustered Column chart. Copy the "Customer Problems" table and then paste it in the chart spreadsheet window. (Hint: If prompted, click OK to continue.) Remove the Percent Changed data series from the chart, and then close the chart spreadsheet window. Delete the "Chart Title" placeholder object, since the placement of the chart makes the title unnecessary. Format the chart as follows to improve its appearance: Apply Style 6 to the chart to display wider data columns. Change the colors to Monochromatic Palette 1 to coordinate with the rest of the document. Add a Gray, Accent 5 border to clearly separate the chart from the table. Link a chart from an Excel workbook as follows to compare customer responses about problem resolution: Open the workbook Support_WD19_8a_Resolution.xlsx. Copy the "Problem Resolution" pie chart, and then paste it as a link using the destination theme in the blank paragraph at the end of the document. Close Support_WD19_8a_Resolution.xlsx. Change the chart type of the "Problem Resolution" chart to a Doughnut chart, which is a type of pie chart, to match the "Account Types" chart. 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.