| A | B |
| Pivot Table | a dynamic summary report generated from a database. |
| Data | Contains a value or data to be summarized. |
| Category | Describes the data. |
| Normalized | A database table that is appropriate for a pivot table. |
| Column label | A field that has a column orientaiton in the pivot table. |
| Grand totals | A row or column that displays totals for all cells in a row or column in a pivot table. |
| Group | A collection of items treated as a single item. |
| Item | An element in a field that appears as a row or column header in a pivot table. |
| Refresh | Recalculates the pivot table after making changes to the source data. |
| Row labels | A field that has a row orientation in the pivot table. |
| Source data | The data used to create a pivot table. |
| Subtotals | A row or column that displays subtotals for detail cells in a row or column in a pivot table. |
| Table Filter | A field that has a page orientation in the pivot table. |
| Values area | The cells in a pivot table that contain the summary data. |