Objective:  To use Excel for a practical application and gain more experience with entering data, creating charts and using formulas.

Create a Personal Budget Spreadsheet
(Note:  You don't have to use your real financial data)

Part 1:
Create a personal budget for one year.  Months should go across the top of the sheet, while Bills and Expenses will go down the left-hand side.  Your spreadsheet should display total expenses for each pay date, and the yearly total for each expense.  Here is a 3-month example of what is expected in Part 1:

Note that the example above is only for three months; your spreadsheet should be for an entire year.  Your expenses will probably be different than the ones shown above.

Part 2:
Using formulas in Excel, compute the Minimum, Maximum, and Average Total expenditures for the year.  In the example above, you would use the MIN, MAX, and AVERAGE formulas against the numbers in Column E.

Part 3:
Using the Chart Wizard, create two charts to graph your expenditures.  Save your charts as a new sheet (as opposed to an object in a sheet like the last assignment).

Part 4:
Rename your sheets appropriately and delete any unused sheets in the Workbook.  [To do this, right-click on the sheet tabs]

Submit your Excel workbook via the Digital Drop Box in Blackboard.  Please note the Monday due date.