Miles Per Gallon

Excel

Skills: create a table, 2 graphs, 2 pictures, use formulas to multiply and divide

Objective:

1) How many gallons of gas does each car use every day of the trip?

2) How much does the gas cost for each car every day of the trip?

Step:

1) Choose an exotic and normal car.

2) Find the Miles Per Gallon (MPG) on the highway for each car.

3) Create a table with: days, miles, gallons for each car, price of gas, cost of gas for each car as columns. Write the days in the first column. (see sample below)

4) Complete the table. (see step 2 for miles; gallons = miles/mpg; cost of gas = price of gas * gallons) Use formulas to find the number of gallons and the cost of gas, don’t just write the answer.

5) Create a graph that compares how many gallons each car u ses, every day of the trip.

6) Create a graph that compares how much gas cost for each car, every day of the trip.

7) Include Pictures of both cars.

Days	Miles	Gallons Car 1	Gallons Car 2	Price of Gas	Cost of Gas Car 1	Cost of Gas Car 2
1	(see step 2)	gallons = miles/mpg			cost of gas = price of gas*gallons
2
3
4
5
6
7
8
9