Which statement accurately describes the capability of pivot tables for analysis?

• A. Pivot tables require coding
• B. Pivot tables enable multi-dimensional analysis by summarizing data across multiple fields
• C. Pivot tables are limited to a single field
• D. Pivot tables cannot show field summaries

Answer: (B)

Pivot tables are built to enable multi-dimensional analysis by summarizing data across multiple fields. They let you place fields into rows, columns, and values to create cross-tab views that show aggregates like sum, average, and count. This setup makes it easy to compare performance across different dimensions—such as region, product, and time—without writing any code. The results update as you rearrange fields or refresh the data, and you can filter or slice to focus on specific subsets. Because of this, pivot tables aren’t limited to a single field and they can show field summaries across many dimensions. Statements claiming coding is required, or that pivot tables are restricted to one field or can’t display summaries, aren’t accurate.