e01ch01TCO_RuizFernando - Saved to my Mac Q Search Sheet AutoSave Q Search in Document Home Insert Page Layout Formulas Data Review View Share ~ Home...
View the step-by-step solution to:

Question

Hi can anyone help me with

this homework. It is due at midnight tonight and I have no idea how to do it.

e01ch01TCO_RuizFernando - Saved to my Mac
Q Search Sheet
AutoSave
Q Search in Document
Home
Insert
Page Layout
Formulas
Data
Review
View
Share ~
Home
Insert
Design
Layout
References
Mailings &gt;&gt;
L Share
Calibri (Body) * 11 . A- A
Text
Conditional Formatting
Insert
Arial
9
A- AV AV A
Paste
B I U . . &amp;. AT
BE
Format as Table
* Delete
Cell Styles
Format
Sort &amp;
Paste
BI U abe X2 X2 AL A.
Paragraph
Styles
Filter
B20
4 X
fx AutoTCO
B
C
D
E
F
Kallio Auto Sales
Excel 2016 Project
YO_Excel16_Ch01_PS1_v3
Project Description:
Create Date
By Whom
Description
Workbook Name
Most people own, or will at some time own, an automobile. Few actually take the time to calculate what owning an automobile
/18/18 Fernando Ruiz
Automobile TCO Analysis
e01ch01TCO_RuizFernando.xIsx
actually costs-called &quot;Total Cost of Ownership.&quot; This is an important calculation for both individuals and for businesses. In
this project, you will complete the development of an automobile total cost of ownership worksheet for your supervisor, Jan
Mod. Date
By Whom
Mod. Description
Last Version Backup Name
Bossy, CFO at your place of employment
5/20/18 Documentation
+ Steps to Perform:
10
Step
Instructions
Points
Possible
11
12
Start Excel. Open the downloaded file named e01ch01_grader_h1_TCO.xIsx. Save it as
0
e01ch01TCO_LastFirst using your last and first name.
13
14
2
Change the name of Sheet1 to Documentation. Change the name of Sheet2 to AutoTEQ
10
15
3
In the AutoTCO worksheet, enter the values as shown below into the specified cells:
10
16
Data Item
Miles Driven / year
Cell
Value
Fuel Cost / Gallon
MPG
E5
15000
18
F6
3.00
26
19 Create Date
Sheet Name
Creator
Purpose
/18/18 Auto TCO
Jan Bossy
5-year TCO for an automobile
Apply Merge &amp; 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
10
7
Select row 14, and then insert a new row
8
Type 5-year Total Cost of Ownership Analysis in cell B15. Center the text in B15:F15 using
Center Across Selection.
9
Add the file name Header &amp; Footer Element to the left section of the footer on both
5
worksheets
10
In the Documentation worksheet, enter the values as shown below into the specified cells:
5
B20 AutoTER
C8 Completed Ms. Bossy's Automobile Total Cost of Ownership worksheet
11
Delete the Sheet3 worksheet.
12
Move the AutoTCO worksheet to the left of the Documentation worksheet
12
For the AutoTCO worksheet, set orientation to Landscape Orientation. For the Documentation
10
worksheet, set orientation to Landscape Orientation. On the Documentation worksheet, set the
page scaling to Fit All Columns to One Page.
Created On: 07/05/2019
YO_Excel16_Ch01_PS1_v3
Sheet1
Sheet2
Sheet3
+
nter
&quot; - +
120%
Page 1 of 2
E
Focus
110%

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

• -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents