The following spreadsheet can be used to compute total weekly pay, given the hours, hourly rate, and overtime rate. A B C D E F G H1 Hours worked Regular hours Hourly rates Regular gross pay Overtimes hour Time and a hall overtime rate Total Overtime pay Total gross pay2 42 40 10.5 3 44 40 9 4 45 40 14 Required:a. Write the formula to compute the regular gross pay in cell D2. b. Write the formula to compute the overtime hours in cell E2. c. Write the formula to compute the time-and-a-half overtime hourly rate in cell F2. d. Write the formula to find the total overtime pay in cell 62. e. Write the formula to compute the total weekly pay in cell H2. f. Use your spreadsheet to fill in the missing entries.