MANAGING YOUR DATA WITH DAIA TOOIS

GEITING STARTED

Open the file NP EX$196$a FirstlastName$\_1.$xisx, avallable for download from the SAM website.

Save the file as NP$\_$EX$196$a$\_$FirstlastName$\_2.$xlsx by changing the $"1"$ to a $"2".$

If you do not see the $sx$ file extension in the Save As dialog box, do not type it The program will add the file extension for you automatically.

With the file NP$\_$EX$196$a$\_$FirstLastName$\_2.$xisx still open, ensure that your first and last name is displayed in cell $B6$ of the Documentation sheet.

a$.$ If cell B$6$ does not display your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

Donnie Cruz is a finance assistant for Oval Lake Hospital in south Florida. His current project is to format deparmental data for the years $2021-2023$ to make it easier to analyze.

Switch to the Cancer Center worksheet Unfreeze the top row of the worksheet

Sort the data in the Cancercenter table first in ascending order by the Admission field and then in ascending order by the Service field.

Insert a Total Row in the Cancer Center table, and then use the Total row to calculate the total of the values in the $2021,2022,$ and $2023$ fields.

$4$ The administrat or overseeing the cancer center is considering mandating that all