Christmas Wish List

Today and tomorrow you are going to shop for 15 goodies you would like for Christmas. (I know it is early, but it is never to early to shop for good deals!)

In an excel sheet, create a spreadsheet that will have a good design, at least two small graphics, a list of 15 items you would like for Christmas, and how much it costs for each of them. At the end, give a total cost of all the items by setting a formula to have the computer do the math for you.

In addition, create a 3-D Pie chart so that your parents can easily see what item they are spending the most money on.

Finally, in a word document, type a numbered list of all the websites you visited to find your items. See the example below:

Mrs. Ehle's Christmas List
1. An Ipod Nano--www.target.com
2. A Nikon D60 Digital Camera---www.ritzcamera.com

***************
TURN IN:
When you hand in the assignment, you should turn in:
(PRINT PREVIEW YOUR WORK BEFORE YOU PRINT IT OUT!!)
1. he Excel Spreadsheet and the chart together in one document. It should be printed in landscape format. Please print the answers only (No Formulas).
2. A Word document with your items and places you shopped on the internet.

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.