Master Activity 2

Complete the following Master Activity and submit your completed project.

In this assignment, you are working as a data analyst for a healthcare company. Your supervisor has asked you to correct this spreadsheet in Excel that tracks daily patient admissions. Follow the guidelines below to correct the spreadsheet data is accurate before presenting it to the CEO.

1. From your data files, open the file Starter_Excel_Master2. Rename the file as Lastname_Firstname_Excel_Master2.
2. In cell A2, correct the As of Date using a function that represents the current date and time.
3. Fix the column widths to the best fit.
4. In cell B27, correct the SUM function so that it includes all records in column F.
5. In cell B28, correct the function so that it displays only ED patients.
6. In cell B29, correct the function so that it only displays CCU patients.
7. Add a Footer that displays the file name in the left section.
8. Rename the sheet to Admissions, and change the color to Blue, Accent1.
9. Change the Theme to Integral.
10. Run spelling and grammar check, taking care not to change patient names, city or unit.
11. Submit as instructed by your instructor.