Please help with showing the steps on how to do (1-12)

PROJECT STEPS 1. Donnie Cruz is a finance assistant for Oval Lake Hospital in south Florida. His current project is to format departmental 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. 2. Sort the data in the CancerCenter table first in ascending order by the Admission field | and then in ascending order by the Service field. 3. Insert a Total Row in the CancerCenter table, and then use the Total row to calculate the total of the values in the 2021, 2022, and 2023 fields. 4. 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 the range C4:C11 that uses Light Red Fill with Dark Red Text for duplicate values. 5. Switch to the Cardiac Care worksheet. Freeze the first column of the worksheet. 6. Format the range A3:F10 as an Excel table with headers using the Gold, Table Style Medium 5 table style. Enter CardiacCare as the name of the table. 7. Donnie notices that the CardiacCare table is missing a record. Add the record shown in Table 1 to the end of the CardiacCare table. . Table 1: Data for the Range A11:F11 B D E F 11 A Cardiac Care Inpatient Other 2855 3540 3752 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 a. the relationships between admission type and number of patients. Switch to the Maternity worksheet and complete the following steps: Sort the table by the Admission field in ascending order. b. Convert the table to a normal range. c. Insert subtotals into the range A3:F13, 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. Switch to the Psychiatric worksheet and remove the duplicate record based on the values in the Admission and Service columns. 9. 10. The data bars in the last three columns make some of the numbers hard read. Change the Data Bars conditional formatting for the range D4:F12 to use the Solid Fill Green Data Bar format. 11. a. Donnie wants to calculate total admissions for the hospital for each year. Switch to the All Departments worksheet, then create the following formulas: 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. Donnie wants to prepare the AllDepartments table for 2024 data when it becomes available. Add a table column to the end of the table. 12. Final Figure 1: Cancer Center Worksheet B D E F 2022 2023 1,914 92 1 Oval Lake Hospital 2 Patients Admitted 2021-2023 3 Department Admission 1 Service 1 2021 4 Cancer Center Inpatient Diagnosis 2,252 5 Cancer Center Inpatient Hospice 81 6 Cancer Center Inpatient Other 592 7 Cancer Center Inpatient Surgery 7,894 8 Cancer Center Outpatient Consultation 1,288 9 Cancer Center Outpatient Imaging 3,923 10 Cancer Center Outpatient Other 841 11 Cancer Center Outpatient Surgery 653 12 Total 17,524 12 Cancer Center Cardiac Care + 704 6,631 1,649 3,335 891 627 15,843 1,550 107 866 6,565 1,814 2,935 1,149 558 15,544 Final Figure 2: Cardiac Care Worksheet E F 2022 2023 B D 1 Oval Lake Hospital 2 Patients Admitted 2021-2023 3 Department Admission Service 2021 4 Cardiac Care Inpatient Surgery 18,904 5 Cardiac Care Outpatient Consultation 3,190 6 Cardiac Care Inpatient Diagnosis 7,803 7 Cardiac Care Outpatient Other 1,788 8 Cardiac Care Outpatient Imaging 4,502 9 Cardiac Care Outpatient Surgery 525 10 Cardiac Care Inpatient Hospice 44 11 Cardiac Care Inpatient Other 2,855 12 Cancer Center Cardiac Care 16,636 3,350 9,910 1,842 5,673 525 18,632 4,121 12,189 2,247 5,786 488 48 51 3,540 3,752 Final Figure 3: Maternity Worksheet E 2022 2023 1 2 3 Department 4 Maternity 5 Maternity 6 7 Maternity 8 Maternity 9 Maternity 10 Maternity 11 12 Maternity 13 Maternity 14 Maternity 15 Maternity 16 17 18 Cardiac Care B D Oval Lake Hospital Patients Admitted 2021-2023 Admission Service 2021 Delivery Natural 3,396 Delivery Surgical 5,084 Delivery Total 8,480 Inpatient Non-maternity 1,322 Inpatient Other 226 Inpatient Procedure 1,252 Inpatient Pre-labor 556 Inpatient Total 3,356 Outpatient Imaging 7,795 Outpatient Consultation 5,208 Outpatient Other 2,253 Outpatient Surgery 285 Outpatient Total 15,541 Grand Total 27,377 4,279 5,033 9,312 1,408 287 1,189 428 3,312 8,964 5,781 2,298 259 17,302 29,926 4,921 5,234 10,155 1,296 339 1,213 496 3,344 7,440 6,128 2,873 298 16,739 30,238 Maternity Psychiatric + Final Figure 4: Psychiatric Worksheet E F 2022 - 2023 A B 1 Oval Lake Hospital 2 Patients Admitted 2021-2023 3 Department Admission - Service 2021 4 Psychiatric Outpatient Other 6,256 5 Psychiatric Inpatient Diagnosis 1,803 6 Psychiatric Inpatient Other 628 7 Psychiatric Inpatient Substance 884 8 Psychiatric Outpatient 9 Psychiatric Outpatient Therapy 10,051 10 Psychiatric Inpatient Surgery 51 11 Psychiatric Outpatient Imaging 523 12 Psychiatric Inpatient 3-day hold 796 13 Maternity Psychiatric All Depart... + Labs 3,893 5,881 1,857 754 972 3,620 9,548 44 4501 812 6,587 1,523 618 902 4,018 10,789 44 518 918 Final Figure 5: All Departments Worksheet E F G 2022 2023 2024 A B D 1 Oval Lake Hospital 2. Patients Admitted 2021-2023 3 Department 1 Admission of Service 1 2021 4 Cancer Center Inpatient Diagnosis 2,252 5 Cancer Center Inpatient Hospice 81 6 Cancer Center Inpatient Other 592 7 Cancer Center Inpatient Surgery 7,894 8 Cancer Center Outpatient Consultation 1,288 9 Cancer Center Outpatient Imaging 3,923 10 Cancer Center Outpatient Other 841 11 Cancer Center Outpatient Surgery 653 12 Cardiac Care Inpatient Diagnosis 7,803 13 Cardiac Care Inpatient Hospice 44 14 Cardiac Care Inpatient Other 2,855 15 Cardiac Care Inpatient Surgery 18,904 16 Cardiac Care Outpatient Consultation 3,190 17 Cardiac Care Outpatient Imaging 4,502 18 Cardiac Care Outpatient Other 1,788 19 Cardiac Care Outpatient Surgery 525 20 Maternity Delivery Natural 3,396 21 Maternity Delivery Surgical 22 Maternity Inpatient Non-maternity 1,322 23 Maternity Inpatient Other 226 24 Maternity Inpatient Pre-labor 556 25 Maternity Inpatient Procedure 1,252 26 Maternity Outpatient Consultation 5,208 27 Maternity Outpatient Imaging 7,795 28 Maternity Outpatient Other 29 Maternity Outpatient Surgery 285 30 Psychiatric Inpatient 3-day hold 796 31 Psychiatric Inpatient Diagnosis 1,803 32 Psychiatric Inpatient Other 628 33 Psychiatric Inpatient Substance 884 34 Psychiatric Inpatient Surgery 51 35 Psychiatric Outpatient Imaging 523 36 Psychiatric Outpatient Labs 3,893 37 Psychiatric Outpatient Other 6,256 38 Psychiatric Outpatient Therapy 10,051 39 40 Total Admissions 41 Psychiatric All Departments + 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 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 44 518 5,084 2,253 44 4,018 450 3,620 5,881 9,548 6,587 10,789 111,234 118,962 PROJECT STEPS 1. Donnie Cruz is a finance assistant for Oval Lake Hospital in south Florida. His current project is to format departmental 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. 2. Sort the data in the CancerCenter table first in ascending order by the Admission field | and then in ascending order by the Service field. 3. Insert a Total Row in the CancerCenter table, and then use the Total row to calculate the total of the values in the 2021, 2022, and 2023 fields. 4. 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 the range C4:C11 that uses Light Red Fill with Dark Red Text for duplicate values. 5. Switch to the Cardiac Care worksheet. Freeze the first column of the worksheet. 6. Format the range A3:F10 as an Excel table with headers using the Gold, Table Style Medium 5 table style. Enter CardiacCare as the name of the table. 7. Donnie notices that the CardiacCare table is missing a record. Add the record shown in Table 1 to the end of the CardiacCare table. . Table 1: Data for the Range A11:F11 B D E F 11 A Cardiac Care Inpatient Other 2855 3540 3752 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 a. the relationships between admission type and number of patients. Switch to the Maternity worksheet and complete the following steps: Sort the table by the Admission field in ascending order. b. Convert the table to a normal range. c. Insert subtotals into the range A3:F13, 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. Switch to the Psychiatric worksheet and remove the duplicate record based on the values in the Admission and Service columns. 9. 10. The data bars in the last three columns make some of the numbers hard read. Change the Data Bars conditional formatting for the range D4:F12 to use the Solid Fill Green Data Bar format. 11. a. Donnie wants to calculate total admissions for the hospital for each year. Switch to the All Departments worksheet, then create the following formulas: 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. Donnie wants to prepare the AllDepartments table for 2024 data when it becomes available. Add a table column to the end of the table. 12. Final Figure 1: Cancer Center Worksheet B D E F 2022 2023 1,914 92 1 Oval Lake Hospital 2 Patients Admitted 2021-2023 3 Department Admission 1 Service 1 2021 4 Cancer Center Inpatient Diagnosis 2,252 5 Cancer Center Inpatient Hospice 81 6 Cancer Center Inpatient Other 592 7 Cancer Center Inpatient Surgery 7,894 8 Cancer Center Outpatient Consultation 1,288 9 Cancer Center Outpatient Imaging 3,923 10 Cancer Center Outpatient Other 841 11 Cancer Center Outpatient Surgery 653 12 Total 17,524 12 Cancer Center Cardiac Care + 704 6,631 1,649 3,335 891 627 15,843 1,550 107 866 6,565 1,814 2,935 1,149 558 15,544 Final Figure 2: Cardiac Care Worksheet E F 2022 2023 B D 1 Oval Lake Hospital 2 Patients Admitted 2021-2023 3 Department Admission Service 2021 4 Cardiac Care Inpatient Surgery 18,904 5 Cardiac Care Outpatient Consultation 3,190 6 Cardiac Care Inpatient Diagnosis 7,803 7 Cardiac Care Outpatient Other 1,788 8 Cardiac Care Outpatient Imaging 4,502 9 Cardiac Care Outpatient Surgery 525 10 Cardiac Care Inpatient Hospice 44 11 Cardiac Care Inpatient Other 2,855 12 Cancer Center Cardiac Care 16,636 3,350 9,910 1,842 5,673 525 18,632 4,121 12,189 2,247 5,786 488 48 51 3,540 3,752 Final Figure 3: Maternity Worksheet E 2022 2023 1 2 3 Department 4 Maternity 5 Maternity 6 7 Maternity 8 Maternity 9 Maternity 10 Maternity 11 12 Maternity 13 Maternity 14 Maternity 15 Maternity 16 17 18 Cardiac Care B D Oval Lake Hospital Patients Admitted 2021-2023 Admission Service 2021 Delivery Natural 3,396 Delivery Surgical 5,084 Delivery Total 8,480 Inpatient Non-maternity 1,322 Inpatient Other 226 Inpatient Procedure 1,252 Inpatient Pre-labor 556 Inpatient Total 3,356 Outpatient Imaging 7,795 Outpatient Consultation 5,208 Outpatient Other 2,253 Outpatient Surgery 285 Outpatient Total 15,541 Grand Total 27,377 4,279 5,033 9,312 1,408 287 1,189 428 3,312 8,964 5,781 2,298 259 17,302 29,926 4,921 5,234 10,155 1,296 339 1,213 496 3,344 7,440 6,128 2,873 298 16,739 30,238 Maternity Psychiatric + Final Figure 4: Psychiatric Worksheet E F 2022 - 2023 A B 1 Oval Lake Hospital 2 Patients Admitted 2021-2023 3 Department Admission - Service 2021 4 Psychiatric Outpatient Other 6,256 5 Psychiatric Inpatient Diagnosis 1,803 6 Psychiatric Inpatient Other 628 7 Psychiatric Inpatient Substance 884 8 Psychiatric Outpatient 9 Psychiatric Outpatient Therapy 10,051 10 Psychiatric Inpatient Surgery 51 11 Psychiatric Outpatient Imaging 523 12 Psychiatric Inpatient 3-day hold 796 13 Maternity Psychiatric All Depart... + Labs 3,893 5,881 1,857 754 972 3,620 9,548 44 4501 812 6,587 1,523 618 902 4,018 10,789 44 518 918 Final Figure 5: All Departments Worksheet E F G 2022 2023 2024 A B D 1 Oval Lake Hospital 2. Patients Admitted 2021-2023 3 Department 1 Admission of Service 1 2021 4 Cancer Center Inpatient Diagnosis 2,252 5 Cancer Center Inpatient Hospice 81 6 Cancer Center Inpatient Other 592 7 Cancer Center Inpatient Surgery 7,894 8 Cancer Center Outpatient Consultation 1,288 9 Cancer Center Outpatient Imaging 3,923 10 Cancer Center Outpatient Other 841 11 Cancer Center Outpatient Surgery 653 12 Cardiac Care Inpatient Diagnosis 7,803 13 Cardiac Care Inpatient Hospice 44 14 Cardiac Care Inpatient Other 2,855 15 Cardiac Care Inpatient Surgery 18,904 16 Cardiac Care Outpatient Consultation 3,190 17 Cardiac Care Outpatient Imaging 4,502 18 Cardiac Care Outpatient Other 1,788 19 Cardiac Care Outpatient Surgery 525 20 Maternity Delivery Natural 3,396 21 Maternity Delivery Surgical 22 Maternity Inpatient Non-maternity 1,322 23 Maternity Inpatient Other 226 24 Maternity Inpatient Pre-labor 556 25 Maternity Inpatient Procedure 1,252 26 Maternity Outpatient Consultation 5,208 27 Maternity Outpatient Imaging 7,795 28 Maternity Outpatient Other 29 Maternity Outpatient Surgery 285 30 Psychiatric Inpatient 3-day hold 796 31 Psychiatric Inpatient Diagnosis 1,803 32 Psychiatric Inpatient Other 628 33 Psychiatric Inpatient Substance 884 34 Psychiatric Inpatient Surgery 51 35 Psychiatric Outpatient Imaging 523 36 Psychiatric Outpatient Labs 3,893 37 Psychiatric Outpatient Other 6,256 38 Psychiatric Outpatient Therapy 10,051 39 40 Total Admissions 41 Psychiatric All Departments + 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 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 44 518 5,084 2,253 44 4,018 450 3,620 5,881 9,548 6,587 10,789 111,234 118,962