80.2K

Verified Solution

Link Copied!

Points Possible Step Instructions Start Excel. Open the downloaded file named e01ch01 graderh1_TCO.xlsx. Save it as e01ch01TCO_LastFirst using your last and first name. 1 10 2 Change the name of Sheetl to Documentation. Change the name of Sheet2 to AutoTCQ. In the AutoC orksheet, enter the values as shown below into the specified cells Value 15000 3.00 26 Cell Data Item Miles Driven year E4 Fuel Cost /Gallon E5 MPG 10 E6 10 Apply Merge & Center to cell range A1:F1. 10 5 Copy cell range C16:C22 to cell range D16:F22. 10 6 Select cell range B15:C15 and use the AutoFill handle to fill through cell F15 7 7 Select row 14, and then insert a new row. 10 Type 5-year Total Cost of Ownership Analysis in cell B15. Center the text in B15:F15 using Center Across Selection. 8 10 Add the file name Header& Footer Element to the left section of the footer on both 9 worksheets. Updated: 05/23/2018 Current Instruction.docx Office 2016-myitlab:grader - Instructions Excel Project Points Possible Step Instructions 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 10B20 AutetCO 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 10 B20 AutoI.Ca 11 Delete the Sheet3 worksheet. 12 Move the AutoTCQ worksheet to the left of the Documentation worksheet. For the AutoTCQ worksheet, set orientation to Landscape Orientation. For the Documentation 13 worksheet, set orientation to Landscape Orientation. On the Documentation worksheet, set 10 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: AutoCO; Documentation. Submit the workbook as directed. Total Points 100 Kallio Auto Sales 5 Create Date By Whom 5/18/18 Jan Bossy 7 Mod. DateBy Whom Description Automobile TCO Analysis Mod. Description Workbook Name Eagen e01ch01 grader h1 TCOxlsx Last Version Backup Name 5/20/18 Firstname Lastname 16 18 19 Create Date Sheet Name Creator 5/18/18 Sheet2 Jan Bossy 5-year TCO for an automobile 30 Sheet1 Sheet2 Sheet3 A1 Model: Scion TC Purchase Price: $ 21,115 10% 4.75% Miles Driven/year: Fuel Cost/Gallon: MPG: Oil Change Miles: Oil Change Cost: Purchase Tax Rate: % Down Payment: Annual Interest Rate: Loan Term (months): 5,000 5-year Residual Value 50% 125 $ License Cost: $ 10 Ins. Increase /Year 2% Paperwork Fees: $ 150 Year 1 12 13 14 15 16 17 18 19 20 21 17% Depreciation Rate Maintenance 15% 3% 35% 20% 13% 4% Year 1 $3,695.13 $828.22 $1,225.18 #DIV/0! $1,200.00 Year 2 Depreciation: Financing: Taxes & Fees: Fuel: Insurance: Maintenance: TOTAL COST: $2,111.50 $660.77 $125.00 #DIV/0! $1,224.00 $0.00 #DIV/0 ! $0.00 #DIV /01 23 24 25 26 27 28 29 30 31 32 34 Sheet1 Sheet2 Sheet3 Points Possible Step Instructions Start Excel. Open the downloaded file named e01ch01 graderh1_TCO.xlsx. Save it as e01ch01TCO_LastFirst using your last and first name. 1 10 2 Change the name of Sheetl to Documentation. Change the name of Sheet2 to AutoTCQ. In the AutoC orksheet, enter the values as shown below into the specified cells Value 15000 3.00 26 Cell Data Item Miles Driven year E4 Fuel Cost /Gallon E5 MPG 10 E6 10 Apply Merge & Center to cell range A1:F1. 10 5 Copy cell range C16:C22 to cell range D16:F22. 10 6 Select cell range B15:C15 and use the AutoFill handle to fill through cell F15 7 7 Select row 14, and then insert a new row. 10 Type 5-year Total Cost of Ownership Analysis in cell B15. Center the text in B15:F15 using Center Across Selection. 8 10 Add the file name Header& Footer Element to the left section of the footer on both 9 worksheets. Updated: 05/23/2018 Current Instruction.docx Office 2016-myitlab:grader - Instructions Excel Project Points Possible Step Instructions 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 10B20 AutetCO 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 10 B20 AutoI.Ca 11 Delete the Sheet3 worksheet. 12 Move the AutoTCQ worksheet to the left of the Documentation worksheet. For the AutoTCQ worksheet, set orientation to Landscape Orientation. For the Documentation 13 worksheet, set orientation to Landscape Orientation. On the Documentation worksheet, set 10 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: AutoCO; Documentation. Submit the workbook as directed. Total Points 100 Kallio Auto Sales 5 Create Date By Whom 5/18/18 Jan Bossy 7 Mod. DateBy Whom Description Automobile TCO Analysis Mod. Description Workbook Name Eagen e01ch01 grader h1 TCOxlsx Last Version Backup Name 5/20/18 Firstname Lastname 16 18 19 Create Date Sheet Name Creator 5/18/18 Sheet2 Jan Bossy 5-year TCO for an automobile 30 Sheet1 Sheet2 Sheet3 A1 Model: Scion TC Purchase Price: $ 21,115 10% 4.75% Miles Driven/year: Fuel Cost/Gallon: MPG: Oil Change Miles: Oil Change Cost: Purchase Tax Rate: % Down Payment: Annual Interest Rate: Loan Term (months): 5,000 5-year Residual Value 50% 125 $ License Cost: $ 10 Ins. Increase /Year 2% Paperwork Fees: $ 150 Year 1 12 13 14 15 16 17 18 19 20 21 17% Depreciation Rate Maintenance 15% 3% 35% 20% 13% 4% Year 1 $3,695.13 $828.22 $1,225.18 #DIV/0! $1,200.00 Year 2 Depreciation: Financing: Taxes & Fees: Fuel: Insurance: Maintenance: TOTAL COST: $2,111.50 $660.77 $125.00 #DIV/0! $1,224.00 $0.00 #DIV/0 ! $0.00 #DIV /01 23 24 25 26 27 28 29 30 31 32 34 Sheet1 Sheet2 Sheet3

Answer & Explanation Solved by verified expert

See Answer