Collaboration and Workbook Distribution
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:
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 openexploring_e11_grader_h1.xlsx and save it ase11c1HealthCare_LastFirst, replace LastFirst with your last name.
Display the Backstage view and add Exploring Series Student as an Author and Grader 1 as the Title.
Compare and merge e11c1Dallas.xlsx and e11c1Atlanta.xlsxintoyour workbook.
Click cell B13, type $100,250 to reflect a last-minute addition of $10,000 in sales, and then save the workbook.
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.