Page 34 - Excel Workbook for Dummies

05_798452 ch01.qxp 3/13/06 7:52 PM Page 17
Chapter 1: Entering the Spreadsheet Data 17

Try It

Exercise 1-9: Making Simple Data Entries

Complete the data entry for the simple Spring Sale table shown in Figure 1-1 by doing
the following:

1. Enter the table title Spring Sale Furniture Prices in cell A2.
2. Enter the column headings in row 3 as follows:
• Code in cell A3
• Description in cell B3
• Retail Price in cell C3
• Discount in cell D3
• Sales Price in cell E3

3. Enter the code numbers in column A as follows:
• 02-305 in cell A4
• 02-240 in cell A5
• 04-356 in cell A6
• 01-234 in cell A7
• 03-003 in cell A8
• 01-240 in cell A9

4. Enter the furniture descriptions in column B as follows:
• 36-inch round table in cell B4
• 72-inch dining table in cell B5
• Hutch in cell B6

• Side chair in cell B7
• Arm chair in cell B8
• Armoire in cell B9
5. Enter the retail prices of the furniture in column C as follows:
• 1250 in cell C4
• 1400 in cell C5
• 2500 in cell C6

• 350 in cell C7
• 500 in cell C8
• 1750 in cell C9

6. Enter the discount percentages in column D as follows:
• 25% in cells D4, D5, and D6
• 15% in cells D7 and D8
• 25% in cell D9