| A | B |
|---|
| Calculated Column | A single formula entered in a table cell and them automatically copied to all of the other table cells in the column. |
| CHOOSE | A lookup function that returns a value from a list of many values. |
| Embedded Object | An object that keeps the features of the application it was created in. |
| Field | A column in a worksheet. |
| Filter | The process of displaying only the rows that meet specific criteria. |
| Linked Object | An object that automatically updates when the source data is updated. |
| Macro | A series of recorded commands and actions that perform a specific task. |
| PivotTable | A table of data where each column is a field that can be used to summarize data. |
| PivotTable Report | A report that allows the worksheet data to be put into small, concise reports, simplifying data analysis. |
| Static | Pasted data that is not connected to the source file or to the source application. |
| Table | Range of related data that can be sorted and filtered. |
| VLOOKUP | A lookup function used to return a value from a table of values stored in the worksheet. |
