Thousand+Dollar+Shopping+Spree

Congratulations!! You have been selected as the winner of a $1000 shopping spree at the store of your choice from those listed below. WAIT, there's a catch. You knew there would be didn't you?
 * You can only take home your choices if your total bill is between $995 & $1000 including tax. (ahem, you do realize you can't really take these home, right?)
 * All of your shopping has to be in __//only one//__ of the stores listed below.
 * You can not buy more than 1 of any one item
 * You can not spend more than $150 on a single item
 * You can not buy gift cards
 * BE AWARE of SHIPPING  fees. Shipping costs MUST be included in your price. That $0.01 item you found might actually cost $4.99 in shipping, so the item total is $5.00.
 * **You can not start shopping until your spreadsheet is set up to correctly calculate your totals! SHOW MRS. ROCHE YOUR SPREADSHEET BEFORE YOU START SHOPPING! **

No problem, right? You know how to use a spreadsheet to keep track of your purchases and calculate the tax and total for you. All you have to do is create a spreadsheet that looks like this: Formulas Your Spreadsheet Should Have:

> **Hint #1: ** To multiply something you need to use the asterisk (shift and the number 8) > **Hint #2: **<span style="font-family: 'Comic Sans MS',cursive;"> Formulas ALWAYS start with an equal sign (=) and since you will be doing basic math functions they will always start with =SUM( > **<span style="color: #ff0000; font-family: 'Comic Sans MS',cursive;">Hint #3 **<span style="font-family: 'Comic Sans MS',cursive;">: Try using the Auto Sum feature
 * <span style="font-family: 'Comic Sans MS',cursive;">Each cell in Column D should be a formula that multiplies the Cost per Item by the Quantity Purchased for each item you buy.
 * <span style="font-family: 'Comic Sans MS',cursive;">The Sub-Total should be a formula which calculates the total of all of the items in column D
 * <span style="font-family: 'Comic Sans MS',cursive;">The current tax rate is 8.75% so the Tax total should be a formula which multiples your Sub-Total by the tax rate.
 * <span style="font-family: 'Comic Sans MS',cursive;">Your Grand Total should be a formula that adds your Sub-Total plus the Tax amount - Remember this needs to be between $995 & $1000. Can you reach exactly $1000? The person coming the closest to $1000 (between $995 & $1000) will win a prize.

<span style="font-family: 'Comic Sans MS',cursive; line-height: 1.5;">Where You Can Shop: Remember you have to pick ONE store and you can not start shopping until your spreadsheet set up is complete.


 * <span style="font-family: 'Comic Sans MS',cursive;">[|Amazon]
 * <span style="font-family: 'Comic Sans MS',cursive;">[|Toys R Us]
 * <span style="font-family: 'Comic Sans MS',cursive;">[|Target]
 * <span style="font-family: 'Comic Sans MS',cursive;">[|Best Buy]

<span style="font-family: 'Comic Sans MS',cursive; line-height: 1.5;">You can only buy things appropriate for your age! No movies or games rated above your age, no music with warning labels, nothing inappropriate!

<span style="font-family: 'Comic Sans MS',cursive;">Here is the I will use to grade your work.