9/14/2023 0 Comments Creating a to do list in excelIf you need to differentiate the column labels from the data, underline the labels or use a border along the bottom of the row of column labels.įor instructor-led MS Excel classes in Los Angeles call us on 888.815.0604.įigure 1-1: Parts of a List Entering Column Labels in a List If you don't, Excel won't recognize the column labels as belonging to the list. You must start your first row of data directly below the column labels. The parts of a list are shown in Figure 1-1.Įach column of information in a list must have a column label as Excel uses these column labels as field names. For example, you might name a field Last Name, Address 2, or Phone Number. Records are organized into fields according to the columns in your list and named according to the column labels. It contains alphanumeric data that, for example, might refer to the name, address, zip code, and telephone number of one person. A record is a set of related data that corresponds to a row in the list. Identifying the Parts of a ListĪ list consists of records and fields. For example, if you need to sort the list by last name, be sure to include a separate field for last names. You plan your list by determining the column labels you want to include, the type of desired output, and how you might want to report or sort information in your database. Although you can change list elements after you have created a list, it is best to spend time planning your list before you begin entering data. You enter information into a list by entering data into cells. You create a list in much the same way you create a worksheet. You can use lists whenever you need to organize large amounts of similar data, such as a database of names and addresses. A list is a sequence of rows of related data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |