What+would+I+buy

=What would I buy if I had a 10,000.00 dollars to spend?=

Your mission is to spend a ten thousand dollars and not a penny more. A prize will be given to the student that comes closest to spending the money without going over. You must setup a spreadsheet that will keep track of your items, the amount and cost as well as a total running cost to get you as close as possible to spending ten thousand dollars. Rules:
 * You may only shop at Walmart: http://www.walmart.com/
 * You may only buy up to three of any one item at one time, and it cannot total any more than 2,500.00
 * You cannot buy any one item that equals five thousand dollars
 * Have fun!
 * See how many things you can buy that you might like to have
 * Remember to fill out your spreadsheet correctly

Below is a picture of how to set up your spreadsheet:

**Formatting cells for currency-**

 * Select cells in amount and total
 * right click on the cells you highlighted
 * choose format cells
 * select currency on the left- set to dollars under currency symbol and choose 1st (red) numbers to make it positive.

=Adding Cells together-=
 * Click on cell under total
 * click on the (=) sign
 * click on cell in amount
 * click on cell in unit
 * click return on keyboard

= = =Totaling Amounts in Excel-=
 * Scroll down the page under total
 * Click on cell under total below what you have already entered
 * On the tabs above- click on Formulas
 * Click on the 2nd one labeled AutoSum