PROJECT SIEPS

Danny Chase is a finance assistant for Wilmington Critical Care in Wilmington, NC$.$ Her current project is to format departmental data for the years $2024-2026$ to make it easier to analyze.

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

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

Insert a total row in the table, and then calculate the totals for the $2024,2025,$ and $2026$ columns.

The administrator overseeing the cancer center is considering mandating that all inpatient service names be different from outpatient service names, and wants to see which duplicate names are currently in use.

Apply a conditional formatting rule to service names that uses light red fill with dark red text for duplicate values. Don't include the total row since there's no value there.

Switch to the Cardiac Care worksheet. Freeze the first column of the worksheet.

The data on this worksheet is not formatted like the other worksheets. Format the headings and the data as an Excel table with headers using the same style as the table on the Cancer Center worksheet. Enter CardiacCare as the name of the table.

Danny notices that the CardiacCare table is missing a record. Add the record shown in Table $1$ to the bottom of the CardiacCare table.

Table $1$: Missing Record for CardiacCare Table

$\backslash$table$[[$Department$,$Admission,Service,$2024,2025,2026],[\backslash$table$[[$Cardiac$],[$Care$]],$Inpatient,Other,$2855,3540,3752$