| A | B |
|---|
| Calculated field | A field on a PivotTable with values not entered as data but determined by a computation involving data in other fields. |
| Field | Individual data items that make up a record in a table that are drawn in columns |
| Field name | same as a column heading |
| String | A single character, work, or phrase in a cell on a worksheet that is typically used in searches |
| Table or database | An organized collection of data that can be inserted, deleted, sorted or filtered. Advanced data features allow detailed data to be summarized and represented in easy to read PivotTables and PivotCharts. |
| Importing data | the process of bringing data containing text fields separated by commas into Excel |
| Query | A way to qualify data by specifying a matching condition or asking a question of the data |
| Slicer | used to easily filter PivotTables and cube functions interactively in a worksheet |
| Sort keys | when sorting data in a table, these fields are selected as fields to sort by |
| PivotChart | the name of an interactive graphical representation of data that allows a user to change the groupings |
| Trendline | A visual way to show how two variables relate to each other in a table |
| Modify a table style | right-click on a style and choose Duplicate |
| Layout | The tab in the PivotChart Tools Ribbon that allows a user to apply chart titles to the PivotChart. |
| Collapse/Expand | the -/+ buttons that appear across the categories on a PivotTable |
| Home | The ribbon that includes the commands to apply a quick table style to a range of cells |
| Delimited file | The file that contains data fields separated by a special character such as a comma |
| Design | This ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable |
| Filtering | The process of viewing a PivotTable report for a subset that meets the criterion only |
| Slicer | a graphical object that contains buttons a user can click to filter the data in PivotTables and PivotCharts |
| Autofilter | a technique that uses the table column heading arrows to narrow data in a table to show only specific items meeting a desired criterion |
| PivotTable | an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories in which to group the data. In order to directly report the data a PivotChart must always be associated with a PivotTable |
| Styles | a home ribbon group that contains the command used for quickly converting selected cells to a table by choosing a table style |
| Sum | the default method for summarizing data in a PivotTable |
| Web query | a technique that selects data from the Internet to add to an Excel worksheet |
| Row | a record |
| Row Heading | record name |
| Value field | use summary functions in value fields to combine values from the underlying source data. |
| Category field | displays data groups in a single column or row in the PivotTable |
