Microsoft Excel Single Use Spreadsheets

You can create spreadsheets designed to accomplish a single task

Task: Create a Trip Calculator - How much will a car trip cost? - Enter the distance between two locations, the current cost of gasoline and the number of miles per gallon which a car uses. Find out the fuel cost of the trip

Task: Create a Trip Calculator - How much will a car trip cost? - Enter the distance between two locations, the current cost of gasoline and the number of miles per gallon which a car uses. Find out the fuel cost of the trip

The image above may not look like it, but it is a spreadsheet.

Anything that needs to be decided mathematically can be made into a single use spreadsheet. Some suggestions for this type of calculation include:

- Calculating the price per ounce of a favorite cereal
- Determine the price per square inch of a pizza
- Estimate the price of objects on sale for some given percentage off
- The cost of buying everyone in the world a Coke (remember that old song)

There are three phases in creating the spreadsheet you see above:

- Planning the information needed and how the calculation would be done
- Creating the spreadsheet and writing the equation
- Designing the look of the final product

--------------------------------------------------------------------------------

Phase 1 - Planning the information needed and how the calculation would be done

The following information is needed for this calculation

- The number of miles to be traveled
- The number of miles that the vehicle will travel on one gallon of gas (mpg)
- The average cost of a gallon of gas (rounded to the nearest penny)

The calculation also involves multiple steps

- Determine the number of gallons of gas to be used
- number of miles divided by miles per gallon gives the number of gallons of gas needed

- Determine the cost of the gasoline needed for the trip
- number of gallons of gas needed times the cost per gallon gives the cost of the trip

--------------------------------------------------------------------------------

Phase 2 - Creating the spreadsheet and writing the equation

- Step 1 - Open an Excel workbook
- Step 2 - Type basic information onto the sheet
- In cell B2 type Trip Cost Estimator
- In cell B4 type Type the number of miles (round trip) you will travel
- In cell D6 type a number of miles
- In cell E6 type the word miles
- In cell B8 type How many miles per gallon does your vehicle usually get?
- In cell D10 type a number of miles per gallon
- In cell B12 type How much does a gallon of gasoline cost?
- In cell D14 type the typical cost of a gallon of gas
- In cell B16 type The cost of your trip will be:
- In cell D18 you will enter an equation

- Step 3 - Determine what the equation should be.
- First the number of miles (in cell D6) should be divided by the number of miles per gallon (in cell D10)
- Then that number of gallons is to be multiplied by the cost of a gallon of gas (in cell D14)
- The above statement is typed into cell D18 as:
- =(D6/D10)*D1

- Step 4 - As soon as the equation is entered into D18, the cost of the trip is calculated.
- Step 5 - Save your work
- Step 6 - Enter data for another trip, use a different number of miles and miles per gallon.

--------------------------------------------------------------------------------

Phase 3 - Designing the look of the final product

- Step 1 - While still seeing the grid lines, use the Merge & Center button on the cells in column B which contained text
- Step 2 - Next, removed the grid lines, or simply cover them with colored fill.
- Select All on the worksheet you are using - depress Ctrl key and tap the A key twice
- Use the Fill Color button to make the sheet a solid color

- Step 3 - Use the Fill Color button to draw the blue border, and to highlight the cells where data will be entered.
- Step 4 - Use the Borders button to place a dark black around the cells where data will be entered.
- Step 5 - Find a clip art image to match the topic of your single use spreadsheet.
- Step 6 - Begin looking for another idea for a single use spreadsheet.