Master Activity 2

Master It Icon

 

 

 

 

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 will automatically bring up the current date.
  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. To offer clarification on medical terms, please note the acronyms used in this assignment are as follows: ED = Emergency Department and CCU = Cardiac Care Unit.
  12. Submit as instructed by your instructor.

 

License

Icon for the Creative Commons Attribution 4.0 International License

Intro to Microsoft Office Copyright © 2021 by Abby Rusu & Maricopa Millions is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.

Share This Book