Lab Six

Excel Spreadsheet

Due March 21^st

Create a Yearly Budget

• Include at least six items in your budget. i.e. Rent, Food, etc.

• Your budget needs be for 12 months, with the name of the month centered at the top of each column.

• Total the costs for each month.

• Total the amount spent on each of the six items for the year.

• Show income for each month, and then subtract the cost to give you the money left over at the end of each month.

• Format the money as currency with negative amounts in red. Have some months have a positive balance and others with negative.

• Use at least three different fonts and three different sizes of fonts.

• Use the border feature to make the spreadsheet more readable. Example, lines above totals and under headings.

• Header should have a Title.

• Footer should have the page number and date in the lower right corner.

• Create a second worksheet with the summary information. Link the yearly totals for all six of the items. Then create a chart that shows how the money is being spent for each category with percentages.

• Save this file as yourlastname6.xls, and make sure you include the CS4000 in your subject line.