Back to Main Page

 

Travel Budget Spreadsheet and Chart

Directions: Using the information you have collected during your research and AppleWorks or Excel spreadsheet, create a travel budget (like the one below) with all of your expenses categorized in the different areas below. Remember, you only have $2000 to spend. You can not go over that amount. Set up your spreadsheet with the formulas you see below to the right and then fill in your expense amounts. Readjust your expenses if you are spending too much. Insert a header called "Travel Budget" Make sure the pie chart fits on page.

Example:

Chart Example below

Make a Pie Chart using only (cells A3 through C10). Have it show the percentage of each expense. (it should look just like this)