Which Excel feature is designed to summarize a dataset by data categories, enabling cross-tabulation?

Which Excel feature is designed to summarize a dataset by data categories, enabling cross-tabulation?

• A. Frequency tables
• B. Pivot tables
• C. Report queries
• D. Diagnosis classifications

Answer: (B)

Pivot tables are designed to summarize data by categories and enable cross-tabulation by letting you arrange fields into rows and columns and compute aggregate values like sums, counts, or averages. This creates a matrix that shows how different categories interact—for example, totals by region across product lines—and you can refresh it as the underlying data changes. Frequency tables, while helpful for counting occurrences within a single category, don’t automatically produce the two-dimensional grid needed for cross-tab views. The other options aren’t built for this kind of multi-dimensional summarization in Excel.

Pivot tables are designed to summarize data by categories and enable cross-tabulation by letting you arrange fields into rows and columns and compute aggregate values like sums, counts, or averages. This creates a matrix that shows how different categories interact—for example, totals by region across product lines—and you can refresh it as the underlying data changes. Frequency tables, while helpful for counting occurrences within a single category, don’t automatically produce the two-dimensional grid needed for cross-tab views. The other options aren’t built for this kind of multi-dimensional summarization in Excel.