H E L E N   K E L L E R  M I D D L E  S C H O O L

One can never consent to creep when one feels an impulse to soar...Helen A. Keller

1. Create Column Headings:

   A

• "City to City"

B

• "Miles"

C

• "Price per Gallon"

D

• "Gas Costs"

2. Format the columns “Price per Gallon” and “Gas Costs” as Currency

3. Enter tour information in the “City to City" column.  Enter the distance between the cities in the miles column using Geobytes.

4. Find the cost of gas in the city from which you are leaving using Gasbuddy  and enter it in your spreadsheet.

5. The formula for Gas Costs is the miles traveled divided by miles per gallon (the bus gets 8 miles to the gallon); multiply by the Price per Gallon.

   • For the first leg of your tour you would click in cell D2 and enter the formula =(B2/8*C2) 

   • You do not need to re-enter a formula for each leg of the trip’s Gas Costs.  Use the Fill Function demonstrated in class

The Gas Costs are automatically calculated for each leg of your trip.

6. Find the Total Gas Cost for your entire tour by Summing the column. 
    

7. Save your Mileage spreadsheet as part of a workbook in your group’s folder under Student Work.   Name the workbook "Income and Expense Workbook followed by your first name, last initial".  Notice the tabs on the bottom of the screen are called "Sheet 1, Sheet 2 and Sheet 3".
    

8. Right click on "Sheet 1" and rename it "Mileage followed by your first name and last initial".