Collaboration and Workbook Distribution

Project Description:
You have been hired as an assistant accountant for a small health care IT company. Your role is to merge monthly financial documents from multiple locations, check compatibility, and, after management approval, finalize and distribute your results.

For the purpose of grading the project you are required to perform the following tasks:
Step Instructions Points Possible
1 Open Excel and enter your name as the user name in the Excel Options dialog box, if necessary. Add the Compare and Merge Workbooks command to the Quick Access Toolbar, if necessary. Download and open exploring_e11_grader_h1.xlsx and save it as e11c1HealthCare_LastFirst, replace LastFirst with your last name. 0
2 Display the Backstage view and add Exploring Series Student as an Author and Grader 1 as the Title. 12
3 Compare and merge e11c1Dallas.xlsx and e11c1Atlanta.xlsx into
your workbook. 12
4 Click cell B13, type $100,250 to reflect a last-minute addition of $10,000 in sales, and then save the workbook. 6
5 Activate the Track Changes feature, highlight all changes, and then create a History worksheet. Open the Select Changes to Accept or Reject dialog box and deselect all check boxes. Accept all changes and turn off workbook sharing. 16
6 Run the Accessibility Checker, identify potential problems, and then fix the warning issues detected. Close the Accessibility Checker task pane. 8
7 Run the Compatibility Checker, correct any significant loss of fidelity issues, and ignore any minor loss of fidelity issues. 8
8 Insert a footer with the sheet name code in the center, and the file name code on the right side. 12
9 Add a signature line with the name Exploring Series Student. 12
10 Mark the workbook as final. 14
11 Save the file and close Excel. Submit the e11c1HealthCare_LastFirst.xlsx file as directed. 0
Total Points 100

Leave a Reply

Your email address will not be published.