| A | B |
|---|
| Database | Organized collection of data |
| Record | data related to a person or thing |
| Field | Data items that make up a record |
| Calculated column | Field or column that contains formulas or functions |
| Data validation | Ensures data entered in a cell is within limits |
| Row banding | Causes adjacent rows to have different formattings |
| HLookup function | Look up values in a horizontal table |
| VLookup function | Look up values in a vertical table |
| Conditional formatting | Create rules that change the formatting of a cell based on a value |
| Conditional formatting rules manager | Allows one to view all rules for selection |
| Sorting | Arranging records in a specific sequence |
| Ascending sequence | Sorted lowest to highest or A to Z |
| Descending sequence | Sorted highest to lowest or Z to A |
| Sort keys | Fields you select to sort the records |
| Major sort key | First level of sort, Sort by Field |
| Intermediate sort key | Second level of sort, First Then by Field |
| Minor sort key | Third level of sort, Second Then by Field |
