Page 40 - Excel Data Analysis

03 537547 Ch02.qxd 3/4/03 11:46 AM Page 26

EXCEL DATA ANALYSIS

CREATE A LIST

xcel provides a great location for creating and Address, City, and Phone, the Form dialog box displays text
maintaining a list of data values for data analysis. A list boxes for each of the selected headings.
E refers to a series of rows in a worksheet that contain To create a list of data in the Form dialog box, you must first
related values. To make the list of values easier to interpret, specify your column headings in the top row of the area in
the first row typically contains labels for each column. For your worksheet where you want to create a list. You can
example, you can create a list of stock quotes with each only do this if you have at least one blank row following
row representing a different stock symbol and each column your headings. It is not necessary to use the first row,
identifying separate dates for each stock quote.
Row 1, for column headings; you can place headings in
Of course, the most obvious method for creating a list is to any row of the worksheet.
simply type the appropriate values in each row or column. When the Form dialog box displays, it requests the values
Another method involves creating a list from the Form for the first row in your list. Each row of data is typically
dialog box. The Form dialog box takes the column headings referred to as a data record. You enter the values in the
in the range of cells you select and uses them to label the corresponding text fields.
data fields. A separate data field displays for each heading.
For example, if you have the column headings Name,

CREATE A LIST

⁄ Type the column headings Note: See Chapter 1 for information ■ Excel displays a message › Click OK.
for your list. on selecting a range of cells. box.
¤ Select one of the cells in ‹ Click Data ➪ Form.
the row.
26