Assignment

You want to create a pie chart to show your expenses but there are too many categories. On the table below,, several rows below the Item column, create a list of the following categories.

Housing

Car

Food

Education

Loans

Entertainment

Miscellaneous

Item	Budget	Expenses
Income Tax	3850	3850
Housing	2640	2640
Gas & Electric Utilities	300	370
Water /Sewer	120	120
Telephone	360	360
Car payment	672	672
Second Car Payment	1440	1440
Car Insurance	240	240
Second Car Insurance	240	240
Gas & Car Maintenance	243	243
Second Car Gas & Car Maintenance	468	468
Food Cost	1500	1500
Alcohol	150	200
Entertainment	300	280
Cable & Internet Access	270	270
Clothing	1200	1200
Student Loan Payment	360	360
Credit Card Payment	900	720
Gifts, Supplies & Toys	300	240
Miscellaneos Expenses	150	200
Savings	3547	3637

Using Excel

Use the SUM function to add together expenses so that all of the expenses on your summary sheet are represented in one of the categories.

Use the SUM function to show the categories add to the same total as the expenses.

Create a pie chart to show your expenses. Remember what you have learned about charts. Keep the chart on the Summary page.

Format the Summary page to print on two pages: one for the listing of items and the second to include the category information and pie chart.