e01ch01TCO (solution)

YO16_XL_CH01_GRADER_PS1_HW - TCO 1.2

 

Project Description:

Most people own, or will at some time own, an automobile. Few actually take the time to calculate what owning an automobile actually costs—called “Total Cost of Ownership.” 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 Bossy, CFO at your place of employment.

 

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Start Excel. Open the downloaded file named e01ch01_grader_h1_TCO.xlsx.Save it as e01ch01TCO_LastFirstusing your last and first name.

0.000

2

Change the name of Sheet1 to Documentation. Change the name of Sheet2 to AutoTCO.

10.000

3

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                          E6                     26


10.000

4

Apply Merge & Center to cell range A1:F1.

10.000

5

Copy cell range C16:C22 to cell range D16:F22.

10.000

6

Select cell range B15:C15 and use the AutoFill handle to fill through cell F15.

10.000

7

Select row 14, and then insert a new row.

10.000

8

Type 5-year Total Cost of Ownership Analysisin cell B15. Center the text in B15:F15 using Center Across Selection.

10.000

9

Add the file name Header & Footer Element to the left section of the footer on both worksheets.

5.000

10

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



5.000

11

Delete the Sheet3 worksheet.

5.000

12

Move the AutoTCO worksheet to the left of the Documentation worksheet.

5.000

13

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.

10.000

14

Save the workbook and then exit Excel. Ensure that the worksheets are named in the following order: AutoTCO; Documentation. Submit the workbook as directed.

0.000

 

Total Points

100.000

 

 

YO16_XL_CH01_GRADER_PS1_HW - TCO 1.2

 

Project Description:

Most people own, or will at some time own, an automobile. Few actually take the time to calculate what owning an automobile actually costs—called “Total Cost of Ownership.” 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 Bossy, CFO at your place of employment.

 

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Start Excel. Open the downloaded file named e01ch01_grader_h1_TCO.xlsx.Save it as e01ch01TCO_LastFirstusing your last and first name.

0.000

2

Change the name of Sheet1 to Documentation. Change the name of Sheet2 to AutoTCO.

10.000

3

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                          E6                     26


10.000

4

Apply Merge & Center to cell range A1:F1.

10.000

5

Copy cell range C16:C22 to cell range D16:F22.

10.000

6

Select cell range B15:C15 and use the AutoFill handle to fill through cell F15.

10.000

7

Select row 14, and then insert a new row.

10.000

8

Type 5-year Total Cost of Ownership Analysisin cell B15. Center the text in B15:F15 using Center Across Selection.

10.000

9

Add the file name Header & Footer Element to the left section of the footer on both worksheets.

5.000

10

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



5.000

11

Delete the Sheet3 worksheet.

5.000

12

Move the AutoTCO worksheet to the left of the Documentation worksheet.

5.000

13

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.

10.000

14

Save the workbook and then exit Excel. Ensure that the worksheets are named in the following order: AutoTCO; Documentation. Submit the workbook as directed.

0.000

 

Total Points

100.000

 

 

YO16_XL_CH01_GRADER_PS1_HW - TCO 1.2

 

Project Description:

Most people own, or will at some time own, an automobile. Few actually take the time to calculate what owning an automobile actually costs—called “Total Cost of Ownership.” 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 Bossy, CFO at your place of employment.

 

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Start Excel. Open the downloaded file named e01ch01_grader_h1_TCO.xlsx.Save it as e01ch01TCO_LastFirstusing your last and first name.

0.000

2

Change the name of Sheet1 to Documentation. Change the name of Sheet2 to AutoTCO.

10.000

3

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                          E6                     26


10.000

4

Apply Merge & Center to cell range A1:F1.

10.000

5

Copy cell range C16:C22 to cell range D16:F22.

10.000

6

Select cell range B15:C15 and use the AutoFill handle to fill through cell F15.

10.000

7

Select row 14, and then insert a new row.

10.000

8

Type 5-year Total Cost of Ownership Analysisin cell B15. Center the text in B15:F15 using Center Across Selection.

10.000

9

Add the file name Header & Footer Element to the left section of the footer on both worksheets.

5.000

10

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



5.000

11

Delete the Sheet3 worksheet.

5.000

12

Move the AutoTCO worksheet to the left of the Documentation worksheet.

5.000

13

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.

10.000

14

Save the workbook and then exit Excel. Ensure that the worksheets are named in the following order: AutoTCO; Documentation. Submit the workbook as directed.

0.000

 

Total Points

100.000

 

 

YO16_XL_CH01_GRADER_PS1_HW - TCO 1.2 YO16_XL_CH01_GRADER_PS1_HW - TCO 1.2 YO16_XL_CH01_GRADER_PS1_HW - TCO 1.2 YO16_XL_CH01_GRADER_PS1_HW - TCO 1.2

       

Project Description: Project Description: Project Description: Project Description:

Most people own, or will at some time own, an automobile. Few actually take the time to calculate what owning an automobile actually costs—called “Total Cost of Ownership.” 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 Bossy, CFO at your place of employment. Most people own, or will at some time own, an automobile. Few actually take the time to calculate what owning an automobile actually costs—called “Total Cost of Ownership.” 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 Bossy, CFO at your place of employment. Most people own, or will at some time own, an automobile. Few actually take the time to calculate what owning an automobile actually costs—called “Total Cost of Ownership.” 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 Bossy, CFO at your place of employment. Most people own, or will at some time own, an automobile. Few actually take the time to calculate what owning an automobile actually costs—called “Total Cost of Ownership.” 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 Bossy, CFO at your place of employment.

   

Instructions: Instructions: Instructions: Instructions:

For the purpose of grading the project you are required to perform the following tasks: For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Start Excel. Open the downloaded file named e01ch01_grader_h1_TCO.xlsx.Save it as e01ch01TCO_LastFirstusing your last and first name.

0.000

2

Change the name of Sheet1 to Documentation. Change the name of Sheet2 to AutoTCO.

10.000

3

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                          E6                     26


10.000

4

Apply Merge & Center to cell range A1:F1.

10.000

5

Copy cell range C16:C22 to cell range D16:F22.

10.000

6

Select cell range B15:C15 and use the AutoFill handle to fill through cell F15.

10.000

7

Select row 14, and then insert a new row.

10.000

8

Type 5-year Total Cost of Ownership Analysisin cell B15. Center the text in B15:F15 using Center Across Selection.

10.000

9

Add the file name Header & Footer Element to the left section of the footer on both worksheets.

5.000

10

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



5.000

11

Delete the Sheet3 worksheet.

5.000

12

Move the AutoTCO worksheet to the left of the Documentation worksheet.

5.000

13

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.

10.000

14

Save the workbook and then exit Excel. Ensure that the worksheets are named in the following order: AutoTCO; Documentation. Submit the workbook as directed.

0.000

 

Total Points

100.000

Step

Instructions

Points Possible

Step

Instructions

Points Possible

Step

Step Step Step Step

Instructions

Instructions Instructions Instructions Instructions

Points Possible

Points Possible Points Possible Points Possible Points Possible

1

Start Excel. Open the downloaded file named e01ch01_grader_h1_TCO.xlsx.Save it as e01ch01TCO_LastFirstusing your last and first name.

0.000

2

Change the name of Sheet1 to Documentation. Change the name of Sheet2 to AutoTCO.

10.000

3

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                          E6                     26


10.000

4

Apply Merge & Center to cell range A1:F1.

10.000

5

Copy cell range C16:C22 to cell range D16:F22.

10.000

6

Select cell range B15:C15 and use the AutoFill handle to fill through cell F15.

10.000

7

Select row 14, and then insert a new row.

10.000

8

Type 5-year Total Cost of Ownership Analysisin cell B15. Center the text in B15:F15 using Center Across Selection.

10.000

9

Add the file name Header & Footer Element to the left section of the footer on both worksheets.

5.000

10

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



5.000

11

Delete the Sheet3 worksheet.

5.000

12

Move the AutoTCO worksheet to the left of the Documentation worksheet.

5.000

13

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.

10.000

14

Save the workbook and then exit Excel. Ensure that the worksheets are named in the following order: AutoTCO; Documentation. Submit the workbook as directed.

0.000

 

Total Points

100.000

1

Start Excel. Open the downloaded file named e01ch01_grader_h1_TCO.xlsx.Save it as e01ch01TCO_LastFirstusing your last and first name.

0.000

1

1 1 1 1

Start Excel. Open the downloaded file named e01ch01_grader_h1_TCO.xlsx.Save it as e01ch01TCO_LastFirstusing your last and first name.

Start Excel. Open the downloaded file named e01ch01_grader_h1_TCO.xlsx.Save it as e01ch01TCO_LastFirstusing your last and first name. Start Excel. Open the downloaded file named e01ch01_grader_h1_TCO.xlsx.Save it as e01ch01TCO_LastFirstusing your last and first name. e01ch01_grader_h1_TCO.xlsx. e01ch01TCO_LastFirst

0.000

0.000 0.000

2

Change the name of Sheet1 to Documentation. Change the name of Sheet2 to AutoTCO.

10.000

2

2 2 2 2

Change the name of Sheet1 to Documentation. Change the name of Sheet2 to AutoTCO.

Change the name of Sheet1 to Documentation. Change the name of Sheet2 to AutoTCO. Change the name of Sheet1 to Documentation. Change the name of Sheet2 to AutoTCO. Documentation AutoTCO

10.000

10.000 10.000

3

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                          E6                     26


10.000

3

3 3 3 3

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                          E6                     26


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                          E6                     26


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                          E6                     26





                 15000
                    3.00
                    26


10.000

10.000 10.000

4

Apply Merge & Center to cell range A1:F1.

10.000

4

4 4 4 4

Apply Merge & Center to cell range A1:F1.

Apply Merge & Center to cell range A1:F1. Apply Merge & Center to cell range A1:F1.

10.000

10.000 10.000

5

Copy cell range C16:C22 to cell range D16:F22.

10.000

5

5 5 5 5

Copy cell range C16:C22 to cell range D16:F22.

Copy cell range C16:C22 to cell range D16:F22. Copy cell range C16:C22 to cell range D16:F22.

10.000

10.000 10.000

6

Select cell range B15:C15 and use the AutoFill handle to fill through cell F15.

10.000

6

6 6 6 6

Select cell range B15:C15 and use the AutoFill handle to fill through cell F15.

Select cell range B15:C15 and use the AutoFill handle to fill through cell F15. Select cell range B15:C15 and use the AutoFill handle to fill through cell F15.

10.000

10.000 10.000

7

Select row 14, and then insert a new row.

10.000

7

7 7 7 7

Select row 14, and then insert a new row.

Select row 14, and then insert a new row. Select row 14, and then insert a new row.

10.000

10.000 10.000

8

Type 5-year Total Cost of Ownership Analysisin cell B15. Center the text in B15:F15 using Center Across Selection.

10.000

8

8 8 8 8

Type 5-year Total Cost of Ownership Analysisin cell B15. Center the text in B15:F15 using Center Across Selection.

Type 5-year Total Cost of Ownership Analysisin cell B15. Center the text in B15:F15 using Center Across Selection. Type 5-year Total Cost of Ownership Analysisin cell B15. Center the text in B15:F15 using Center Across Selection. 5-year Total Cost of Ownership Analysis

10.000

10.000 10.000

9

Add the file name Header & Footer Element to the left section of the footer on both worksheets.

5.000

9

9 9 9 9

Add the file name Header & Footer Element to the left section of the footer on both worksheets.

Add the file name Header & Footer Element to the left section of the footer on both worksheets. Add the file name Header & Footer Element to the left section of the footer on both worksheets.

5.000

5.000 5.000

10

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



5.000

10

10 10 10 10

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



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



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



In the Documentation worksheet, enter the values as shown below into the specified cells:

C8     Completed Ms. Bossy

Completed Ms. Bossy s Automobile Total Cost of Ownership worksheet s Automobile Total Cost of Ownership worksheet
B20   AutoTCO




 AutoTCO



5.000

5.000 5.000

11

Delete the Sheet3 worksheet.

5.000

11

11 11 11 11

Delete the Sheet3 worksheet.

Delete the Sheet3 worksheet. Delete the Sheet3 worksheet.

5.000

5.000 5.000

12

Move the AutoTCO worksheet to the left of the Documentation worksheet.

5.000

12

12 12 12 12

Move the AutoTCO worksheet to the left of the Documentation worksheet.

Move the AutoTCO worksheet to the left of the Documentation worksheet. Move the AutoTCO worksheet to the left of the Documentation worksheet.

5.000

5.000 5.000

13

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.

10.000

13

13 13 13 13

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.

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. 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.

10.000

10.000 10.000

14

Save the workbook and then exit Excel. Ensure that the worksheets are named in the following order: AutoTCO; Documentation. Submit the workbook as directed.

0.000

14

14 14 14 14

Save the workbook and then exit Excel. Ensure that the worksheets are named in the following order: AutoTCO; Documentation. Submit the workbook as directed.

Save the workbook and then exit Excel. Ensure that the worksheets are named in the following order: AutoTCO; Documentation. Submit the workbook as directed. Save the workbook and then exit Excel. Ensure that the worksheets are named in the following order: AutoTCO; Documentation. Submit the workbook as directed.

0.000

0.000 0.000

 

Total Points

100.000

 

   

Total Points

Total Points Total Points Total Points Total Points

100.000

100.000 100.000 100.000 100.000

   

   

Answers

Related Questions

Humanities : The problem between the Palestinians...

argumentative essay about The problem between the Palestinians and Israelisthe paper should be MLA styli it should be between 1300 words to 1600 must...

Business Finance : What is the difference between...

Part I – e-Business Models & StrategiesWhat is the difference between e-business and e-commerce?Discuss how the use of internet banking has changed...

Business Finance : CREATING GREEN COLLAR JOBS, co...

for this assignment I will attach a book contains of 16 chapters, I need to write 3 questions OR ideas OR examples on the readings for each chapter. (...

Humanities : Depression, Psychology paper help...

Hi, please i want some one to write me a psychology paper, I want the paper to be perfect in grammar and structures.Paper must be about 2 complete dou...

Writing : What types of witchcraft does the Malle...

Type up your answers – double spaced, 12 points new roman, a minimum of two pages.What types of witchcraft does the Malleus Malleficarum discuss? Wh...

Humanities : Researched Informative Paper, Englis...

hi i will attach pages that has all the requirements things for this assignment. please read it carefully and do me good work. i chose a topic Social...

Humanities : d identify the skills and abilities...

Please follow the instructions My degree is in accounting Position account payableCompleting this assignment will help you name and identify the skill...

Business Finance : Impact of e-Business on Supply...

The following are two essential features of e-Business: the website and order fulfillment. Companies must invest large amounts of time and funds to ef...

Business Finance : article summary, business and...

a minimum three page summary of two (similar subject) studies/articles from respected scholarly peer reviewed journals. Compare and contrast the two s...

Business Finance : Dissecting Master Production S...

Production systems usually have limited resources and output. For this reason, creating a Master Production Schedule (MPS) can be very challenging, as...

Humanities : sociology...

write a 5-7 page paper using APA standards for citation of sources that focuses on the following:Interview two different individuals regarding their p...

Humanities : Vargas Family Case Study: Module 2...

Read Vargas Family Case Study: Module 2. Complete a Cultural Formulation Interview based on the “cultural formulation” section in the DSM-5 and gi...

Business Finance : Unique Ethical Organizational...

Please response to the following posts for Learning Activity 1a and 1b.Please make sure to use the resources below to respond. Please be sure to cite...

Business Finance : law 105 wills and estates Chap...

Hower, Dennis, Wills, Trusts, and Estate Administration , Thomson Delmar Learning, Seventh Edition. This is the textbook being used. Must cite after e...

Humanities : Political Science...

Politics - Yesterday, Today, and TomorrowWrite a three to four (3-4) page paper in which the student answers the following three (3) items using heade...

Mathematics : Testing for Bivariate Categorical A...

For this Assignment, you will consider three different scenarios. Each of these scenarios include a research question. You will examine each scenario,...

Business Finance : unit 8 essay...

question- write a review of the article. Your article review must be a minimum of two pages in length. Be sure to address each of the following points...

Business Finance : Labor Markets (demand)...

Please answer both questions. 1. a. Explain what is meant by the statement, “the demand for labor is a derived demand?” b. Explain the connection...

Humanities : Meaning of Pop art, writing homework...

Modern Art in the U.S.Pop Art MovementReview our reading on the Pop Art movement. Write an essay in your own words that addresses the points below:Muc...

Humanities : Americas entry into world war II...

Examine three (3) of the major events that led to the outbreak of World War II. Explain the manner in which each of the events you have chosen contrib...

Business Finance : Caesar Salad II Cost Card, mar...

I need someone who know how to do the cost card, i will give you five recipe, and i need five cost card, i really need help, and be quick , thank you...

Mathematics : Functions in the Real World...

Functions in the Real WorldA cab company charges a flat fee boarding rate in addition to a per mile rate. Using your own experience or some internet r...

Science : Guidelines for Written Assignment: Fina...

Each student will prepare a final paper analyzing one of the case example readings assigned for Sessions 3 through 6. For the case example that you se...

Humanities : English HUMANTE...

I have upload 2 stories and the third one I put the name of it and you can find it in google The first one is AeneidSecond story is CatullusThird is S...

If you didn't find the right answer

Ask Your Questions, We'll notify you once someone answers it