New Perspectives Excel 365/2021 | Module 3: End of Module Project 2 |

#NewPerspectivesExcel365/2021Module3EndofModuleProject2 #Project2 #New_Perspectives_Excel_365_2021_Module_3_End_of_Module_Project_2 #Module3EndofModuleProject2 #Module_3_End_of_Module_Project_2 #Module3 #Module_3 #EndofModuleProject2 #Excel365/2021 #NewPerspectives #ExcelModule3 #Excel_Module_3 #SAMEndofModuleProject2ExcelModule03PerformingCalculationswithFormulasandFunctions


Contact Me For Your Assignments and Courses

WhatsApp: +923096000718
Email :myitlabexpert@gmail.com
WhatsApp Direct Link: https://wa.link/7s2pnw


#New Perspectives Excel 365/2021 | Module 3: End of Module Project 2
#NewPerspectivesExcel365/2021Module3EndofModuleProject2
#New_Perspectives_Excel_365_2021_Module_3_End_of_Module_Project_2
#SAM End of Module Project 2 Excel Module 03 Performing Calculations with Formulas and Functions
#SAMEndofModuleProject2ExcelModule03PerformingCalculationswithFormulasandFunctions
#SAM_End_of_Module_Project_2_Excel_Module_03_Performing_Calculations_with_Formulas_and_Functions
#SAM End of Module Project 2 Excel Module 03
#SAMEndofModuleProject2ExcelModule03
#SAM_End_of_Module_Project_2_Excel_Module_03
#Module 3 End of Module Project 2
#Module3EndofModuleProject2
#Module_3_End_of_Module_Project_2
#Excel Module 3 SAM End of Module Project 2
#ExcelModule3SAMEndofModuleProject2
#Excel_Module_3_SAM_End_of_Module_Project_2
#Excel Module 3: End of Module Project 2
#ExcelModule3EndofModuleProject2
#Excel_Module_3_End_of_Module_Project_2
#Sandhills-Sand River Water District
#SandhillsSandRiverWaterDistrict
#Sandhills_Sand_River_Water_District
#PERFORM CALCULATIONS WITH FORMULAS AND FUNCTIONS
#PERFORMCALCULATIONSWITHFORMULASANDFUNCTIONS
#PERFORM_CALCULATIONS_WITH_FORMULAS_AND_FUNCTIONS
#Excel Module 3 SAM End of Module Project 2 Sandhills-Sand River Water District
#ExcelModule3SAMEndofModuleProject2SandhillsSandRiverWaterDistrict
#Excel_Module_3_SAM_End_of_Module_Project_2_Sandhills_Sand_River_Water_District
#NP_EX365_2021_EOM3-2_FirstLastName_1.xlsx
#NP_EX365_2021_EOM3-2_FirstLastName_2.xlsx
#NP_EX365_2021_EOM3-2
#NP
#EX365_2021
#Cengage



#New Perspectives Excel 365/2021 | Module 3: End of Module Project 2


PROJECT STEPS
1. Ying Chou is an intern with the Sandhills-Sand River Water District. Ying has collected data on precipitation and reservoir storage and wants to use Excel to perform some analysis on her data.
Switch to the 2024 Water Projections worksheet. In cell C5, insert the TODAY function to record the current date.
2. In cell J4, create a formula using the MONTH function to display the numerical month based on the date in cell C4.
3. In cell J5, create a formula without using a function that subtracts the value in cell J4 from the number 12.
4. Use the values in the range C9:D9 to extend the list of years to the range E9:G9.
5. Use the values in the range B10:B11 to extend the list of reservoir numbers to the range B12:B15.
6. Use AutoFill to fill the range C11:J15 with the formatting from the range C10:J10.
7. In cell G10, create a formula that uses the AVERAGE and ROUND functions to calculate the average of cells C10:F10 and round the result to 1 decimal place. Copy the formula you created to the range G11:G15.
8. In cell J10, create a formula without using a function that divides the value of cell I10 by the value of cell H10. Copy the formula you created to the range J11:J15.
9. In cell G16, create a formula that uses the AVERAGE and ROUND functions to calculate the average of the range G10:G15 and round the result to 1 decimal place. Copy the formula to cell H16.



#NewPerspectivesExcel365/2021Module1EndofModuleProject1
#NewPerspectivesExcel365/2021Module1EndofModuleProject2
#NewPerspectivesExcel365/2021Module2EndofModuleProject1
#NewPerspectivesExcel365/2021Module2EndofModuleProject2
#NewPerspectivesExcel365/2021Module3EndofModuleProject1
#NewPerspectivesExcel365/2021Module3EndofModuleProject2
#NewPerspectivesExcel365/2021Module4EndofModuleProject1
#NewPerspectivesExcel365/2021Module4EndofModuleProject2
#NewPerspectivesExcel365/2021Module5EndofModuleProject1
#NewPerspectivesExcel365/2021Module5EndofModuleProject2