Online Shopping Spree
You have been given
a $500 gift certificate to any online store. Here are the rules (nothing
is free):
-you must buy at least three different items and no more than eight items.
-format all dollar amounts as currency with two decimal places.
-Bold the
column headings.
-right justify all numbers.
Setting up
your spreadsheet
1. Open a new spreadsheet in Excel.
2. Starting in row 1, column A enter the following column titles (using bold and uppercase letters)
in this order from left to right: STORE NAME, PRODUCT NAME, PRODUCT COST.
3. Insert two blank rows at the top of the spreadsheet.
4. In cell A1 enter your name and the date.
5. If everything worked then STORE NAME, PRODUCT NAME, andPRODUCT COST should
now be in row 3.
Go shopping!
1. Look for something that you want to buy.
2. When you find it enter the store name, product name and product cost in
the correct columns.
3. You must buy at least three different items.
Details
1. For the column titles (row 3), turn on the
wrap text feature.
2. Make the columns wide enough so that each column title has no more than
two words per line. Make sure that no words are split between the two lines.
3. Bold the column headings.
4. Set the horizontal alignment of each column title to center.
5. Set the vertical alignment of each
column title to top.
6. Right justify the numbers in column C (PRODUCT COST).
7. Format the number in column C as currency with two decimals points (like
this: $170.00).
Yours
should look like this (with different products and prices).
The chart
1. Create a clustered column chart using ITEM
NAME and PRODUCT COST.
2. Change the chart title to "Wish List" and include your name as
part of the title.
3. Label the X axis of the chart "Product Names".
4. Label the Y axis of the chart "cost".
5. Create the chart as a new sheet.
Printing
1. Print the spreadsheet in landscape format showing
gridlines and row
and columns headings.
2. Print the chart
on a separate sheet.