Excel® 2007 PivotTables and PivotCharts

Appendix 5. Glossary of PivotTable Terms

Argument	A value that is used as an input for a function and which the function uses to calculate a result. The arguments of a function must correspond to the function's parameters.
Arithmetic Formula	A formula that combines numeric operands — numeric constants, functions that return numeric results, and fields or items that contain numeric values — with mathematical operators to perform a calculation.
AutoFormat	A collection of formatting options — alignments, fonts, borders, and patterns — that Excel defines for different areas of a PivotTable.
Background Query	A query that Excel executes behind the scenes so that you can continue to perform other work in Excel.
Base Field	In a running total summary calculation, the field on which to base the accumulation.
Break‐Even Analysis	The number of units of a product that you must sell for the profit to be 0.
Calculated Field	A new data field in which the values are the result of a custom calculation formula.
Calculated Item	A new item in a row or column field in which the values are the result of a custom calculation.
Category Area	The PivotChart drop area in which the category field appears.
Category Field	A source data field added to the PivotChart's category area; the field's items form the chart's X‐axis values.
Column Area	The PivotTable drop area in which the column field appears.
Column Field	A source data field added to a PivotTable's column area; the field's items form the report's columns.
Comma Separated Values ...