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 040 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, In cell F40 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. Add a table column to the end of the table. B E E F F G 2022 3 Department Admission Cancer Center Inpatient 5. Cancer Center Inpatient $ Cancer Center Inpatient 7 Cancer Center Inpatient 3 Cancer Center Outpatient 8 Cancer Center Outpatient 0 Cancer Center Outpatient 1 Cancer Center Outpatient 2 Cardiac Care Inpatient 13 Cardiac Care Inpatient 14 Cardiac Care Inpatient 15 Cardiac Care Inpatient 16 Cardiac Care Outpatient 47 Cardiac Care Outpatient 78 Cardiac Care Outpatient 19 Cardiac Care Outpatient 20 Maternity Delivery 21 Maternity Delivery 22 Maternity Inpatient 23 Maternity Inpatient 24 Maternity Inpatient 25 Maternity Inpatient 26 Maternity Outpatient 27 Maternity Outpatient 28 Maternity Outpatient 29 Maternity Outpatient 30 Psychiatric Inpatient 31 Psychiatric Inpatient 32 Psychiatric Inpatient 33 Psychiatric Inpatient 34 Psychiatric Inpatient 35 Psychiatric Outpatient 36 Psychiatric Outpatient 37 Psychiatric Outpatient 38 Psychiatric Outpatient 39 40 Total Admissions 41 C D Oval Lake Hospital Patients Admitted 2021-2023 Service 2021 Diagnosis 2,252 Hospice 81 Other 592 Surgery 7,894 Consultation 1,288 Imaging 3,923 Other 841 Surgery 653 Diagnosis 7,803 Hospice 44 Other 2,855 Surgery 18,904 Consultation 3,190 Imaging 4,502 Other 1,788 Surgery 525 Natural 3,396 Surgical 5,084 Non-maternity 1,322 Other 226 Pre-labor 556 Procedure 1,252 Consultation 5,208 Imaging 7,795 Other 2,253 Surgery 285 3-day hold 796 Diagnosis 1,803 Other 628 Substance 884 Surgery 51 Imaging 523 Labs 3,893 Other 6,256 Therapy 10,051 1,914 92 704 6,631 1,649 3,335 891 627 9,910 51 3,540 16,636 3,350 5,673 1,842 525 4,279 5,033 1,408 287 428 1,189 5,781 8,964 2,298 259 812 1,857 754 972 44 450 3,620 5,881 9,548 2023 1,550 107 866 6,565 1,814 2,935 1,149 558 12,189 48 3,752 18,632 4,121 5,786 2,247 488 4,921 5,234 1,296 339 496 1,213 6,128 7,440 2,873 298 918 1,523 618 902 518 4,018 6,587 10,789
