| A | B |
|---|
| filter | finding records that meet a certain criteria |
| custom filters | allows you to search for values using the search operators, display rows that contain either one value or another, or display rows that meet more than one condition for a column |
| Copy To Range | the worksheet area where the records that meet the specific criteria will be copied |
| Criteria Range | the location where you will enter the information you want Excel to locate |
| AutoFilter | Excel feature that lets you display only the records in a data list that meet specific criteria |
| Top 10 | Excel feature that allows you to quickly display the highest and lowest values in a data list |
| wildcards | used in a search when you don't know the exact spelling of a word |
| DSUM | a function that adds the numbers in a column located in a list or database that match the conditions you specify |
| AND search operator | finds records that meet two criteria |
| OR search operator | finds records that meet one criteria or another |
| DAVERAGE | a function that averages the numbers in a column located in a list or database that match the conditions you specify |
| Scenario | a group of values that produce different results when calculated |
| precedent | refers to the cells that are referenced in a formula |
| dependent | refers to the cells that contain formulas that reference a selected cell |
| auditing | identifies the cells that are referenced in a formula, thereby making it easier for you to determine where an error might occur in a formula |
| Goal Seek | finds one unknown value given a set of circumstances |
| Solver | lets you find two or more unknown values in a formula |
| correlation | allows you to determine if a strong relationship exists between variables |
| Data validation | Excel feature that allows data to be entered according to certain rules that you specify |
| regression | a statistical method used to describe the relationship between variables |
