Black Friday assignment

November 23, 2010 at 1:12 pm | Posted in tech | Leave a comment

Black Friday!!

You will use Excel to track the money you can save on Black Friday.   You will also locate each store in Google maps and link to them to better plan your route for the day.

-creating column headings
-formatting text
-wrapping text

1. Open Excel and start a new worksheet.

2. Create column headings called “store name”, “product name”, “sale price”, “retail price”, “money saved”, “store opens”, “store location”. Don’t include the quotes.  Wrap text for each column heading and bold the column headings.

3. Use the following resources to find Black Friday deals.

or just Google “Black Friday (store name OR product name)

4. Find at least five products from from five different stores.  Fill in each column for each item.  Use a formula to calculate “money saved”.

5. For the map link, use Google maps to locate the store.  Type “click here for map” and link to the Google Map.  Like this: click here for map.

6. Total up the following: sale price, retail price, money saved using formulas.

7. Average the same amounts using formulas.

8. Create a chart that best compares the sale price and retail price for each product.  Put them on all on one chart on a separate sheet.

9. Print out the following in landscape format – customize as you wish:
-your worksheet with data
-your worksheet showing formulas
-your chart

Entries and comments feeds.