Timesheet due 3/5/2005 Reporting Period Hours Name Period start 2/1/2021 Perledend 2207001 Date completed 114/2019 Balances Period Start Period End Summary Web Worked Holiday vacations Hours Worked . 10 ILS 75 2 7.5 9 8.5 56.00 20.00 ESO SO 4 25 85 95 D . 7 9 came Tatal 14.00 150 78.50 0 . 85 Hours Used Other Hessed Heurs worked per day Week Hours World Total Hours For We Come 72 12 10.00 05 Mom Minimum 10 2 20.00 40 00 12.00 4400 40.00 4000 4000 4400 8.00 1. Create lookup functions to complete the summary section. In cell 16, 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 15 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell 15 and the range A17:G20. 2. Copy the formula from cell 16 to the range 17:111 and then edit the formula in cell 17 to return the value in the 3rd column, the formula in cell 18 to return the value in the 4th column, the formula in cell 19 to return the value in the 5th column, the formula in cell 110 to return the value in the 6th column, and the formula in cell 111 to return the value in the 7th column