$8.$ The Maternity department has more admission criteria than other major divisions of the hospital. Donnie wants to summarize Maternity admissions data using subtotals to show the relationships between admission type and number of patients. Switch to the Maternity worksheet and complete the following steps:

a$.$ Sort the table by the Admission field in ascending order.

b$.$ Convert the table to a normal range.

c$.$ Insert subtotals into the range A$3$:F$13,$ with the subtotals appearing at each change in the Admission column value. The subtotals should use the SUM function and include subtotals for the $2021,2022,$ and $2023$ fields.

$9.$ Switch to the Psychiatric worksheet and remove the duplicate record based on the values in the Admission and Service columns.

$10.$ The data bars in the last three columns make some of the numbers hard to read. Change the Data Bars conditional formatting for the range D$4$:F$12$ to use the Solid Fill Green Data Bar format.

$11.$ Donnie wants to calculate total admissions for the hospital for each year. Switch to the All Departments worksheet, then create the following formulas:

a$.$ In cell D$40$ use the SUM function with a structured reference to total the values in the $2021$ column of the AllDepartments table.

b$.$ In cell E$40$ use the SUM function with a structured reference to total the values in the $2022$ column of the AllDepartments table.

c$.$ In cell F$40$ use the SUM function with a structured reference to total the values in the $2023$ column of the AllDepartments table.

$12.$ Donnie wants to prepare the AllDepartments table for $2024$ data when it becomes available.