Problem
A. 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 D40 use the SUM function with a structured reference to total the values in the 2021 column of the AllDepartments table.
b. In cell E40 use the SUM function with a structured reference to total the values in the 2022 column of the AllDepartments table.
c. In cell F40 use the SUM function with a structured reference to total the values in the 2023 column of the AllDepartments table.
B. Donnie wants to prepare the AllDepartments table for 2024 data when it becomes available. Add a table column to the end of the table.