Shopping Spree Spreadsheet

Your teacher decided to award you with an imaginary check in the amount of $500.00.

You decide to go on a shopping spree. You tell your friends the good news, and they tell you about a super sale at one of the local stores.

Assignment:

• Peruse the web site of a local store
. (Khols, Macy, JC Penney, Filenes, Sears, etc..)


• In an Excel Spreadsheet, make a list of the items you want to buy. Make sure you do not go over $500.00, so you may want to input a formula into your spreadsheet that will keep track of your spending.



• Also, you want to see how much you saved buying items on sale, so make sure you mark down the regular price, sale price , and the savings.



• When you are done with your list, don't forget to add 5% sales tak onto your total.



• Save the spreadsheet as "shopping spree".

Grading: