Purchase Solution

Determining the fuel efficiency of an automobile

Not what you're looking for?

Ask Custom Question

Your summer vacation involved traveling through several states to visit relatives and to view the scenic attractions. While traveling, you kept a travel log of mileage and gasoline purchases. Now that the vacation is over, you want to determine the fuel efficiency of your automobile. The partially completed worksheet includes the beginning mileage for the vacation trips and the amount of fuel purchased.

a. Open the e01m1fuel workbook and save the workbook as e01m1fuel_RobinSquires so that you can return to the original workbook if necessary.
b. Insert a new column between columns B and C, and then type Miles Driven as the column heading.
c. Select the range of beginning miles in cells A5:A12. Copy the selected range to duplicate the values in cells B4:B11 to ensure that the ending mileage for one trip is identical to the beginning mileage for the next trip.
d. Create the formula to calculate the miles driven for the first trip. Copy the formula down the Miles Driven column.
e. Create the formula to calculate the miles driven for the first trip. Copy the formula down the Miles Per Gallon column.
f. Merge and center the title over the over the data columns. Apply bold, 16pt size and Blue, Accent 1 font color.
g. Format the column headings: bold, centered, wrapped text, and Blue, Accent 1, Lighter 80% fill color.
h. Apply Comma Style to the values in the Beginning and Ending columns, and then display these values as a whole numbers. Display the values in the Miles Per Gallon column with two decimal places.
i. Delete Sheet2 and Sheet3. Rename Sheet1 as Mileage.
j. Set these page settings: 2" top margin, centered horizontally, 125% scaling.
k. Insert a header with your name (Robin Squires) on the left side, the sheet name code in the center, and the file name code on the right side.
l. Save and close the workbook.

• Step K - Enter the Make/Model of your car in the center of the header instead of the "sheet name code".

• Step K - Enter the current mileage of your car on the right side of the header instead of the "file name code".

Attachments
Purchase this Solution

Solution Summary

The fuel efficiency of an automobiles are determined. New columns between columns B and C are given.

Purchase this Solution


Free BrainMass Quizzes
Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic Networking Questions

This quiz consists of some basic networking questions.

Javscript Basics

Quiz on basics of javascript programming language.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.