6th+Grade

 home  Edit   = Shopping Spree =

**Congratulations!!** You have been selected as the winner of a $1500 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? 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:
 * Your total bill must be between $1495 & $1500 including tax
 * All of your shopping has to be in only **one** of the stores listed below
 * You must shop for your family and friends, but you can also purchase something for yourself
 * You can not buy more than 3 of any one item
 * You must buy at least 3 items
 * You can not buy gift cards
 * You can not start shopping until your spreadsheet is set up to correctly calculate your totals!


 * [|Details]
 * [[file:6thshoppingspree/shopping spree.xls|Download]]
 * 18 KB

**Formulas Your Spreadsheet Should Have:**
 * Each cell in Column D should be a formula that multiplies the Cost per Item by the Quantity Purchased for each item you buy.
 * The Sub-Total should be a formula which calculates the total of all of the items in column D
 * The current tax rate is 9.75% (the example shows 8.25% but you need to use the current rate which has increased) so the Tax total should be a formula which multiples your Sub-Total by the decimal equivalent of the tax rate.
 * Your Grand Total should be a formula that adds your Sub-Total plus the Tax amount - Remember this needs to be between $1495 & $1500! Can you reach exactly $1500? The person coming the closest to $1500 (between $1495 & $1500) will win a prize!

**Where You Can Shop:** Remember you have to pick ONE store! You can only buy things appropriate for your age! No movies or games rated above your age, no music with warning labels, nothing inappropriate!!
 * [|Amazon]
 * [|Toys R Us]
 * [|Target]
 * [|Best Buy]

Your spreadsheet should be named: Shopping Spree and saved in your folder.