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

#NewPerspectivesExcel365/2021Module3EndofModuleProject1 #Project1 #New_Perspectives_Excel_365_2021_Module_3_End_of_Module_Project_1 #Module3EndofModuleProject1 #Module_3_End_of_Module_Project_1 #Module3 #Module_3 #EndofModuleProject1 #Excel365/2021 #NewPerspectives #ExcelModule3 #Excel_Module_3 #SAMEndofModuleProject1ExcelModule03PerformingCalculationswithFormulasandFunctions


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 1
#NewPerspectivesExcel365/2021Module3EndofModuleProject1
#New_Perspectives_Excel_365_2021_Module_3_End_of_Module_Project_1
#SAM End of Module Project 1 Excel Module 03 Performing Calculations with Formulas and Functions
#SAMEndofModuleProject1ExcelModule03PerformingCalculationswithFormulasandFunctions
#SAM_End_of_Module_Project_1_Excel_Module_03_Performing_Calculations_with_Formulas_and_Functions
#SAM End of Module Project 1 Excel Module 03
#SAMEndofModuleProject1ExcelModule03
#SAM_End_of_Module_Project_1_Excel_Module_03
#Module 3 End of Module Project 1
#Module3EndofModuleProject1
#Module_3_End_of_Module_Project_1
#Excel Module 3 SAM End of Module Project 1
#ExcelModule3SAMEndofModuleProject1
#Excel_Module_3_SAM_End_of_Module_Project_1
#Excel Module 3: End of Module Project 1
#ExcelModule3EndofModuleProject1
#Excel_Module_3_End_of_Module_Project_1
#Barrel Barnard Consulting
#BarrelBarnardConsulting
#Barrel_Barnard_Consulting
#PERFORM CALCULATIONS WITH FORMULAS AND FUNCTIONS
#PERFORMCALCULATIONSWITHFORMULASANDFUNCTIONS
#PERFORM_CALCULATIONS_WITH_FORMULAS_AND_FUNCTIONS
#Excel Module 3 SAM End of Module Project 1 Barrel Barnard Consulting
#ExcelModule3SAMEndofModuleProject1BarrelBarnardConsulting
#Excel_Module_3_SAM_End_of_Module_Project_1_Barrel_Barnard_Consulting
#NP_EX365_2021_EOM3-1_FirstLastName_1.xlsx
#NP_EX365_2021_EOM3-1_FirstLastName_2.xlsx
#NP_EX365_2021_EOM3-1
#NP
#EX365_2021
#Cengage


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


PROJECT STEPS
1. Chanelle Larson is a professional assistant with Barrel Barnard Consulting. Chanelle is responsible for collecting consultant hours for some of Barrel Barnard's projects and processing the payments. She wants to automate some tasks and calculate summary information automatically on the worksheet that consultants use to track their hours.
Switch to the Timesheet worksheet. In cell C5, insert the NOW function to record the current date.
2. Each worksheet covers a period of 20 work days. In cell C4, create a formula using the WORKDAY function to calculate the date 19 days from the start date (cell C3).
3. Use AutoFill to complete the labels in the table of hours. Use the values in the range A9:A10 to extend the week numbering to the range A11:A12. Use the value in cell B8 to autofill the remaining weekday abbreviations in the range C8:F8.
4. Add formulas to complete the table of hours used. In cell B17, create a nested formula with the IF and SUM functions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. If it is, the cell should display nothing (indicated with two quote marks: ""). Otherwise, the cell should display the total number of hours worked in week 1. Copy the formula from cell B17 to fill the range B18:B20.
5. In cell H2, create a formula using the WORKDAY function to calculate the date 5 days after the period end date (cell C4).
6. Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.
7. Copy the formula from cell I6 to the range I7:I11 and then edit the formula in cell I7 to return the value in the 3rd column, the formula in cell I8 to return the value in the 4th column, the formula in cell I9 to return the value in the 5th column, the formula in cell I10 to return the value in the 6th column, and the formula in cell I11 to return the value in the 7th column.




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