Aatume 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 far paytod, (There wh be no data in this spresdsheet - you are only entering in the formulas? 11 insert a formula ieto cell D15 that computes the dally pay (Use the appropriate form for cell references) 2) Copy the formula from cell D15 into celts D16 through D21. a) Insert a formela into cell e22 th at computes the total hours for the week. 4) Irest a forimula into celi 024 t at computes the total pay for the week. 5) Apply apgropriate number forriattings for the cells: B) Aicposition the Worithe abov the time card chart 6) Sive viour completed werkshet template and upload to this question. 290033 rd Avenue Dallas, TX 75204 214.555 .0177 Employeet Position