Datasheet

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

Try It

Chapter 1: Entering the Spreadsheet Data

05_798452 ch01.qxp 3/13/06 7:52 PM Page 17