Excel 2007 : Need Advice

**Janniiie** · 11-07-2008, 03:53 PM

My assignment is to make a budget worksheet it should have a row to show income for each month Jan.-Dec. and properly label the row and value. Expenses should be added in a separate row and properly label the row and value. For the expenses and income, create a year's history by month.Create formulas or use the Autosum function to calculate total expense for each month. Create formulas or use the Autosum function to have Excel compute the Total Annual Income and the Total Annual Expenses and properly label each. Name the worksheet tab "Budget Details".

I need someone to check my assignment and tell me anything else that I can do to make it better. Points are awarded for the relative merits of the way the worksheets are created including appropriate layout of the worksheet for the information included and the appropriate use of the Excel features.

**JBeaucaire** · 11-07-2008, 05:17 PM

Looks ok to me. Simple and easy to read.

Change the color of the text for the months March through Sept. to black for ease of read.

Perhaps put your cursor in E3 and select Window > Freeze Pane so the sheet scrolls and keeps the labels visible.

Tom's paycheck and Total Income are the same thing, could probably do without one or the other.