New Perspectives Excel 2019 | Module 3 - End of Module Project 1

Name: Module 3 - End of Module Project 1 | New Perspectives Excel 2019 #part1
Uploaded: 2023-02-03T18:00:26Z

Question

pls hlp with these questions:

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.
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).
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.
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.
In cell H2, create a formula using the WORKDAY function to calculate the date 5 days after the period end date (cell C4).

davidmacago · Answer

Click on C5 enter =NOW()
Click on C4 enter =WORKDAY(C3,19)
Select A9:A10 move your cursor to the corner until you see + sign. Hold it drag it up to A12. Same for weekday, move the cursor in the corner of B8. hold it and drag it up ot F8. it will autofill.
click B17. enter =IF(SUM(B9:F9)=0,"",SUM(B9:F9)). After that, move your cursor to the corner of B17, it will change to a + sign.Hold it and drag it up to B20.
Click on cell H2, enter =WORKDAY(C4,5)

Here is video explanation:

Answers