| A | B |
|---|
| AutoFormat | instantly formats entire worksheets |
| Conditional Formatting | applies certain formats to data which then meets specified criteria |
| Styles | adds consistency to workbook data |
| data validation | helps ensure that accurate data is being entered into a cell |
| data table | displays the worksheet data on the chart itself |
| custom format | using codes, the user may determine how data appears on a worksheet |
| default | original settings loaded when you install the program |
| transpose | allows you to copy and paste data into a different position; allows you to switch the order of the data |
| value | referred to as the result of a formula--not the formula itself |
| ascending order | A--Z or 1--10 |
| criteria | information for which you are searching for in a data list |
| descending order | Z--A or 10--1 |
| field | columns of information that contain one type of data |
| list | used to organize, manage, and retrieve information |
| record | a collection of information about a particular object; displayed in a row in Excel |
