Assume that the regular hours for each week and the rate per hour will be variable data entered for each calendar week. Complete the following steps to create a template file for payroll. (There will be no data in this spreadsheet - you are only entering in the formulas!) 1) Insert a formula into cell D15 that computes the daily pay (Use the appropriate form for cell references.) 2) Copy the formula from cell D15 into cells D16 through D21. 3) Insert a formula into cell C22 that computes the total hours for the week. 4) Insert a formula into cell D24 that computes the total pay for the week. 5) Apply appropriate number formatting for the cells. 6) Reposition the WordArt above the time card chart. 7) Save your file as a template. 8) Save your completed worksheet template and upload to this question. Use this workbook . Dallas Ft. Worth JOB FAIR 2900 33rd Avenue Dallas, TX 75204 214.555.0177 Employee: Position: Rerular Hours Date Total Day Monday Tuesday Wednesday Thursday Friday Saturday Sunday Total Hours Rate Per Hour Total Pay Payroll Time Card Assume that the regular hours for each week and the rate per hour will be variable data entered for each calendar week. Complete the following steps to create a template file for payroll. (There will be no data in this spreadsheet - you are only entering in the formulas!) 1) Insert a formula into cell D15 that computes the daily pay (Use the appropriate form for cell references.) 2) Copy the formula from cell D15 into cells D16 through D21. 3) Insert a formula into cell C22 that computes the total hours for the week. 4) Insert a formula into cell D24 that computes the total pay for the week. 5) Apply appropriate number formatting for the cells. 6) Reposition the WordArt above the time card chart. 7) Save your file as a template. 8) Save your completed worksheet template and upload to this question. Use this workbook . Dallas Ft. Worth JOB FAIR 2900 33rd Avenue Dallas, TX 75204 214.555.0177 Employee: Position: Rerular Hours Date Total Day Monday Tuesday Wednesday Thursday Friday Saturday Sunday Total Hours Rate Per Hour Total Pay Payroll Time Card