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 ...
Get Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
