CSC-151 Spreadsheet Processing
Page 1 of 2
Excel Hands-On Exercise – Cookie Jar1
You are the owner of The Cookie Jar, a shop that sells gourmet cookies by the pound. You are
interested in tracking first quarter sales for each type of cookie.
Follow the directions below. Please note that the maximum deduction for each step is specified
in parentheses at the end of the step.
Suggestion: As you are following the steps below, you may want to periodically save your
workbook file.
1. Create the worksheet as shown below. (-5)
A B C D E F G
The Cookie Jar
Type Jan Feb Mar Total
Chocolate Chip 1800 1825 1835
Chocolate Chip w/ Nuts 1430 1425 1390
White Chocolate Macadamia 1220 1250 1295
Butterscotch 750 775 800
Peanut Butter 1000 1050 975
Oatmeal Raisin 450 375 415
Gingerbread 530 535 500
Total
2. Right-align the month and total headings in row 3. (-3)
3. Indent once the types of cookies in column A. (-1)
4. Delete columns B and C and widen column A appropriately. (-3)
5. Create a formula that will calculate a total only for the chocolate chip cookies. (-2)
6. Copy this formula down the column. (-3)
7. Create a formula that will calculate the total for each month. (-3)
8. Create a formula that will produce a total for cell E11. (-2)
9. Format the sales numbers in cells B4:D10 to display commas without dollar signs and with
no digits to the right of the decimal point. (-3)
10. Format the total column E numbers and the total row 11 numbers to display commas with a
dollar sign and with no digits to the right of the decimal point. (-3)
11. Make the necessary changes to column widths.
12. Center the worksheet title (cell A1) across the appropriate columns. (-2)
13. Bold the title. (-1)
14. Change the title font to Comic Sans MS and increase the font size to 14 pt. (-2)
15. Bold and underline the column headings. (-2)
1 The original description of this exercise and the data file comes from O’Leary, T.J. & O’Leary, L.I., 1998.
Microsoft Office 97 Professional, McGraw-Hill, New York City, USA. (exercise rating: moderate)
