• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. Analyzing Data with Excel > Analyzing Data with Lists

Analyzing Data with Lists

Excel’s forte is spreadsheet work, but its row-and-column layout also makes it a natural flat-file database manager. In Excel, a list is a collection of related information with an organizational structure that makes it easy to find or extract data from its contents. Specifically, a list is a worksheet range that has the following properties:

  • Field— A single type of information, such as a name, an address, or a phone number. In Excel lists, each column is a field.

  • Field value— A single item in a field. In an Excel list, the field values are the individual cells.

  • Field name— A unique name you assign to every list field (worksheet column). These names are always found in the first row of the list.

  • Record— A collection of associated field values. In Excel lists, each row is a record.

  • List range— The worksheet range that includes all the records, fields, and field names of a list.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint