Step Instructions 1 Points Possible 0 2 3 10 10 I I 4 5 6 7 B Start Excel. Open the downloaded file named Olcho1 grader i TCO.xlsx. Save it as e01ch01TCO LastFirst using your last and first name. Change the name of Sheet1 to Documentation Change the name of Sheet2 to AutoTCO In the AutoTCO worksheet, enter the values as shown below into the specified cells: Data Item Cell Value Miles Driven / year E4 15000 Fuel Cost / Gallon E5 3.00 MPG 26 Apply Merge & Center to cell range A1:F1. Copy cell range C16:C22 to cell range D16:F22. Select cell range B15:015 and use the AutoFill handle to fill through cell F15 Select row 14, and then insert a new row Type 5-year Total Cost of Ownership Analysis in cell B15. Center the text in B15:15 using Center Across Selection. Add the file name Header & Footer Element to the left section of the footer on both worksheets In the Documentation worksheet, enter the values as shown below into the specified cells: C8 Completed Ms. Bossy's Automobile Total Cost of Ownership worksheet B20 AutoTCO 10 10 10 10 10 9 10 5 5 11 12 13 5 Delete the Sheet3 worksheet Move the AutoTCO worksheet to the left of the Documentation worksheet For the AutoTCO worksheet, set orientation to Landscape Orientation. For the Documentation worksheet, set orientation to Landscape Orientation. On the Documentation worksheet, set the page scaling to Fit All Columns to One Page Save the workbook and then exit Excel. Ensure that the worksheets are named in the following order: AtoTCO: Documentation. Submit the workbook as directed Total Points 5 10 14 0 100 D E F Description Automobile TCO Analysis Mod. Description Workbook Name e01ch01 grader h1 TCO.xlsx Last Version Backup Name f Kallio Auto Sales B 2 3 4 5 Create Date By Whom 6 5/18/2018 Jan Bossy 7 Mod. Date By Whom 8 5/20/2018 Firstname Lastname 9 10 12 12 13 14 15 16 17 18 19 Create Date Sheet Name 20 5/11/2018 Sheet2 21 22 23 24 Creator Ian Bossy Purpose 5 year TCO for an automobile Step Instructions 1 Points Possible 0 2 3 10 10 I I 4 5 6 7 B Start Excel. Open the downloaded file named Olcho1 grader i TCO.xlsx. Save it as e01ch01TCO LastFirst using your last and first name. Change the name of Sheet1 to Documentation Change the name of Sheet2 to AutoTCO In the AutoTCO worksheet, enter the values as shown below into the specified cells: Data Item Cell Value Miles Driven / year E4 15000 Fuel Cost / Gallon E5 3.00 MPG 26 Apply Merge & Center to cell range A1:F1. Copy cell range C16:C22 to cell range D16:F22. Select cell range B15:015 and use the AutoFill handle to fill through cell F15 Select row 14, and then insert a new row Type 5-year Total Cost of Ownership Analysis in cell B15. Center the text in B15:15 using Center Across Selection. Add the file name Header & Footer Element to the left section of the footer on both worksheets In the Documentation worksheet, enter the values as shown below into the specified cells: C8 Completed Ms. Bossy's Automobile Total Cost of Ownership worksheet B20 AutoTCO 10 10 10 10 10 9 10 5 5 11 12 13 5 Delete the Sheet3 worksheet Move the AutoTCO worksheet to the left of the Documentation worksheet For the AutoTCO worksheet, set orientation to Landscape Orientation. For the Documentation worksheet, set orientation to Landscape Orientation. On the Documentation worksheet, set the page scaling to Fit All Columns to One Page Save the workbook and then exit Excel. Ensure that the worksheets are named in the following order: AtoTCO: Documentation. Submit the workbook as directed Total Points 5 10 14 0 100 D E F Description Automobile TCO Analysis Mod. Description Workbook Name e01ch01 grader h1 TCO.xlsx Last Version Backup Name f Kallio Auto Sales B 2 3 4 5 Create Date By Whom 6 5/18/2018 Jan Bossy 7 Mod. Date By Whom 8 5/20/2018 Firstname Lastname 9 10 12 12 13 14 15 16 17 18 19 Create Date Sheet Name 20 5/11/2018 Sheet2 21 22 23 24 Creator Ian Bossy Purpose 5 year TCO for an automobile