Create an Excel spreadsheet detailing your annual budget.

Content

Create a spreadsheet that details your monthly budget.

Use an appropriate Title.

The budget should include Income and Expenses for each of the 12 months of the year.

COMMON STUDENT QUESTION: What if I'm just a college student and don't have a job or expenses?

Do you eat? Then you pay for the food somehow and you get that money from somewhere.

Do you drive? Then you pay for gas somehow and you get gas money from somewhere.

Are you a student at University? Then you pay for tuition and books somehow and that money comes from somewhere (Parents? Scholarships? Grants? Student Loans?).

EVERYONE has income and EVERYONE has expenses. Think hard and put together a budget that makes sense.

Your budget should include calculations for total monthly income and total monthly expenses.

Your budget should include a calculation for Net, which is a calculation of what you have left over each month after paying expenses.

Your budget should include a yearly total for each type of income and each type of expense.

Your budget should include the percentage that each expense category makes up out of your total expenses (HINT: an absolute reference is needed for this formula).

Formatting

Do not use the same colors shown in the textbook, but use all of the different types of formatting tools shown in the chapter to format your spreadsheet appropriately.

Format the title so that it stands out as a title.

Format the numbers with appropriate number formats.

Format the column and row headings appropriately.

Make sure the entire spreadsheet is formatted to fit on one page (so that if it were printed you would be able to see all of the data printed on one page.

Chart

Select the data range that contains your expense percentages and the row headers that identify those percentages (HINT: you will be selecting non-adjacent ranges for this).

Create a 3-D Pie Chart from that data.

Move the chart to a new sheet named Expense Chart.

Give the chart an appropriate Chart Title.

Use chart tools to format the chart appropriately.