background image
77
1. Insert columns.
2. Move columns.
I
f you're a certi fi ed chocoholic, then you know what your favorite brand
of chocolate bar is. The top 10 chocolate bars listed have sustained their
ranking for several years now and have been popular since the early 1900s.
Their positi ons have varied on the list during recent years; that is why
companies regularly come up with diff erent ways to promote their chocolates
just to hold onto their positi on as one of the top 10 chocolates in the United
States. Many online wholesalers market all of these candy bars in bulk, making
the cost per unit lower and the savings "oh so sweet" to their customers.
The following acti vity illustrates how spreadsheets can be used to list the top
10 bestselling chocolate bars and the average savings for purchasing through
various online distributors.
Top 10 Candy Bars
1. Create a NEW spreadsheet.
Unless otherwise stated, the font should be 10 point Arial.
2. Type the data as shown.
3. Bold cell A1 and change the font size to 18 point.
4. Format the width of column A to 10.0.
5. Center align cells A5 ­ A14.
6. Format the width of column B to 25.0 and center align.
7. Format the width of columns C ­ G to 22.0 and center align.
8. Center align, bold, and underline row 4.
9. Format cells C5 ­ E14 as currency displaying 2 decimal places and the $ symbol.
10. Use the AutoFill feature to complete the numbering sequence in column A to
RANK the candy bars.
11. Compute the formulas for the fi rst candy bar as follows (assume the average
discount is 15%):
a. WHOLESALE DISCOUNT=36 COUNT PRICE*15% In cell D5, type
=C5*15%
b. WHOLESALE PRICE=36 COUNT PRICE-WHOLESALE DISCOUNT In cell E5, type
=C5-D5
12. Use the AutoFill feature to copy the formulas down for the remaining candy
bars.
33
ACTIVITY
For Evaluation Purposes Only