EXCEL--Can you do it?

Aaron has monthly expenditures. He only has $1000 in his budget. Your job is to create a spreadsheet for him.



Here is what he spends his money on:

HOUSE: $450

PHONE: $60

CABLE/COMPUTER: $60

ENTERTAINMENT: $50

GAS: $30

GROCERIES: $150

1. Make the title of your spreadsheet A1: Aaron's Monthly Expenses.


2. Then merge cells A1-C1 for the title.


3. Input column headings for the information above. A2 should say EXPENSES and B2 should say COST. Widen columns as needed


4. In A3-A8, enter the things he spends his money on and in B3-B8, put the amounts he spends on each of them.


5. In A9 should say GRAND TOTAL, in B9 use a formula to total up how much he spent for the month.
6. In A10 should say Money Left Over, in B10 use a formula to show close he is to spending $1000.
7. Insert a graphic of a smiley face if he has money left over, and insert a graphic of a sad face if he went over his budget of $1000.
8. When you are finished, please print out one copy LANDSCAPE, with the formulas only. Make sure to add a footer with your name/date/hour on it.