| A | B |
|---|
| conditional formatting | applies font, border, pattern when certain conditions exist |
| data table | contains worksheet data displayed in table |
| data validation | indicates that something is acceptable or approved |
| default | setting used unless another option is chosen |
| transpose | switch order of something |
| value | refers to number or data |
| ascending order | ordered from earliest date |
| descending order | ordered from highest number |
| field | category of information, displayed in a column |
| list | database table; used to organize, manage & retrieve information |
| record | group of related field in data source |
| autofilter | displays subset of data in worksheet that meet criteria |
| copy to range | area you create where Excel will copy records meeting specified criteria |
| criteria range | area you create where you indicate specific criteria to search for |
| DSUM | function that addes numbers in column located in list which match specific conditions |
| DAVERAGE | function that averages numbers in column located in list which match specific conditions |
| filter | showing only the rows that meet specific criteria |
