Appendix A. 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, ...
Get Excel® PivotTables and PivotCharts: Your visual blueprint™ for creatingdynamic spreadsheets, 2nd Edition 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.
