Question: solve Mark the steps as checked when you complete them. 1. Open the start file EX2021-Fixlt-1-6. The file will be renamed automatically to include your
solve
Mark the steps as checked when you complete them. 1. Open the start file EX2021-Fixlt-1-6. The file will be renamed automatically to include your name. Change the file name if directed to do so by your instructor, and save It. 2. lf the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook. 3. kl The worksheet is missing a title. Type this title in cell A1: Exercise Log 4, The daily goal should be 3, not 30. Correct the value in cell Da. 5. The dates are missing from cells A6:A11. Use AutoFill to complete the dates for the rest of the week. 6. The exercise log would be more useful if the date showed the day of the week in addition to the date. Change the date format for cells A5:A11 so the date displays in the long date format: Sunday, May 1, 2022. If your version of Excel does not include the day of the week in the long date format, use the long date format anyway. 7. The mileage for each day should use the Comma Style number format. Correct the number format in cells C5:C11. 8. Use one of the skills you learned in this chapter to enter formulas using the SUM function in cells B12 and C12 to calculate the weekly total minutes and miles. Reset | 9. _] The formulas in the Under/Over Goal column are not quite right. Fix the formula in cellDS to use an absolute \\ reference where appropriate, and then use AutoFill to replace the formulas in cells D6:D11Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
