Excel Module 6 SAM Project A Oval Lake Hospital | Excel Module 6 SAM Project 1a
Contact Me:
WhatsApp No:+1(725) 272-9378
#Excel_Module_6_SAM_Project_A #ExcelModule6SAMProjectA #NP
#Excel_Module_6_SAM_Project_A #ExcelModule6SAMProjectA #NP #EX19 #NP_EX19_6a #ExcelModule6SAMProject1a #Excel_Module_6 #ExcelModule6 #Excel_Module_6_SAM_Project_1a #NP_EX19_6a_FirstLastName_1.xlsx #Oval_Lake_Hospital #OvalLakeHospital
#Excel Module 6 SAM Project A
#Excel_Module_6_SAM_Project_A
#ExcelModule6SAMProjectA
#AssignmentsExpert
#Excel Module 6 SAM Project 1a
#Excel_Module_6_SAM_Project_1a
#ExcelModule6SAMProject1a
#AssignmentsExpert
#Excel Module 6 SAM Project A Oval Lake Hospital
#Excel_Module_6_SAM_Project_A_Oval_Lake_Hospital
#ExcelModule6SAMProjectAOvalLakeHospital
#AssignmentsExpert
#New Perspectives Excel 2019 Module 6 SAM Project 1a
#New_Perspectives_Excel_2019_Module_6_SAM_Project_1a
#NewPerspectivesExcel2019Module6SAMProject1a
#AssignmentsExpert
#shelly cashman excel 2019 module 6 sam project 1a
#shellycashmanexcel2019module6samproject1a
#shelly_cashman_excel_2019_module_6_sam_project_1a
#AssignmentsExpert
#Oval Lake Hospital
#OvalLakeHospital
#Oval_Lake_Hospital
#AssignmentsExpert
#MANAGING YOUR DATA WITH DATA TOOLS
#MANAGING_YOUR_DATA_WITH_DATA_TOOLS
#MANAGINGYOURDATAWITHDATATOOLS
#AssignmentsExpert
#NP_EX19_6a_FirstLastName_1.xlsx
#NP_EX19_6a_FirstLastName_2.xlsx
#NP_EX19_6a
#cengage
#np
#EX19
#Cengage_Excel_Module_6_SAM_Project_A
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.
#NP_EX19_1a_FirstLastName_1.xlsx
#NP_EX19_1b_FirstLastName_1.xlsx
#NP_EX19_2a_FirstLastName_1.xlsx
#NP_EX19_2b_FirstLastName_1.xlsx
#NP_EX19_3a_FirstLastName_1.xlsx
#NP_EX19_3b_FirstLastName_1.xlsx
#NP_EX19_4a_FirstLastName_1.xlsx
#NP_EX19_4b_FirstLastName_1.xlsx
#NP_EX19_5a_FirstLastName_1.xlsx
#NP_EX19_5b_FirstLastName_1.xlsx
#NP_EX19_6a_FirstLastName_1.xlsx
#NP_EX19_6b_FirstLastName_1.xlsx
#NP_EX19_7a_FirstLastName_1.xlsx
#NP_EX19_7b_FirstLastName_1.xlsx
#NP_EX19_8a_FirstLastName_1.xlsx
#NP_EX19_8b_FirstLastName_1.xlsx
#NP_EX19_9a_FirstLastName_1.xlsx
#NP_EX19_9b_FirstLastName_1.xlsx
#NP_EX19_10a_FirstLastName_1.xlsx
#NP_EX19_10b_FirstLastName_1.xlsx
#NP_EX19_11a_FirstLastName_1.xlsx
#NP_EX19_11b_FirstLastName_1.xlsx
#NP_EX19_12a_FirstLastName_1.xlsx
#NP_EX19_12b_FirstLastName_1.xlsx
#NP_EX19_1a
#NP_EX19_1b
#NP_EX19_2a
#NP_EX19_2b
#NP_EX19_3a
#NP_EX19_3b
#NP_EX19_4a
#NP_EX19_4b
#NP_EX19_5a
#NP_EX19_5b
#NP_EX19_6a
#NP_EX19_6b
#NP_EX19_7a
#NP_EX19_7b
#NP_EX19_8a
#NP_EX19_8b
#NP_EX19_9a
#NP_EX19_9b
#NP_EX19_10a
#NP_EX19_10b
#NP_EX19_11a
#NP_EX19_11b
#NP_EX19_12a
#NP_EX19_12b
#ExcelModule1SAMProject1aTabulaInsuranceAgency
#ExcelModule1SAMProject1bCityofNewMonroe
#ExcelModule2SAMProject1aBergamotUrgentCareClinic
#ExcelModule2SAMProject1bVillanovaTechnologyGroup
#ExcelModule3SAMProject1aScrubJayPeripherals
#ExcelModule3SAMProject1bMedSightInstruments
#ExcelModule4SAMProject1aAlanisParksDepartment
#ExcelModule4SAMProject1bStuartsBank
#ExcelModule5SAMProject1aNarbonneSuites
#ExcelModule5SAMProject1bMinJeeWooArtwork
#ExcelModule6SAMProject1aOvalLakeHospital
#ExcelModule6SAMProject1bSatoInstrumentCollection
#ExcelModule7SAMProject1aValerianStateCollege
#ExcelModule7SAMProject1bBrevardCountySwimClubs
#ExcelModule8SAMProject1aCairoConsulting
#ExcelModule8SAMProject1bFergusonFitness
#ExcelModule9SAMProject1aMountMorelandHospital
#ExcelModule9SAMProject1bChargeAll
#ExcelModule10SAMProject1aLightingDesigns
#ExcelModule10SAMProject1bCorvallisGroupRestore
#ExcelModule11SAMProject1aHempsteadUniversityFoundation
#ExcelModule11SAMProject1bRomanoCollectibles
#ExcelModule12SAMProject1aPentaInsurance
#ExcelModule12SAMProject1bPiedmontRiverfrontFestival