1.	Problem statement: Use Excel 2007 to compute the average gas mileage for your car. The following chart shows the odometer reading at fill-up and the number of gallons you put in the tank.
a.	55,000; 10.1
b.	55,357; 9.8
c.	55,692; 8.9
d.	56,003; 10.0
e.	56,339; 9.2
f.	56,625; 9.7
g.	56,932; 9.3
2.	Analysis and planning: 
Recall from pg. EX 8 of the text that the main steps in planning a spreadsheet are:
•	What problem do you want to solve?  What is the goal and purpose?
•	What data is needed to solve your problem?
•	What calculations, that is, formulas are required to solve the problem?  What is the input and output for these formulas?
•	What form should the spreadsheet take, that is, how should it appear?

Think about these steps then answer the following questions.

a.	Determine what you plan to show in the columns and rows of your spreadsheet.
i.	Columns: ________________________________________________
ii.	Rows: ___________________________________________________
b.	What formulas will you need? ______________________________________
c.	What are the input and output values for the formulas above? _____________
d.	What will the column/row labels be (text that defines the data)? ___________
e.	What will you use as a title for the spreadsheet? ________________________

3.	Create the spreadsheet to solve the problem using Excel 2007.  Screen-print the spreadsheet in normal view and in formulas view and insert the two screen-prints immediately below.
4.	Now, suppose there was a mistake made in the mileage.  Entry d should have been 56013.  Enter this new odometer reading into your spreadsheet to recalculate the total average milate, then screen-print the result in normal view and insert it immediately below.