_______ are Excel tools that can be used to summarize data categories.

_______ are Excel tools that can be used to summarize data categories.

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

Answer: (B)

Pivot tables are Excel tools designed to summarize data by categories. They let you drag category fields into rows and columns and place numeric data into values to compute sums, counts, averages, and other aggregations. This creates a compact summary that shows totals for each category and can be filtered or rearranged to compare different groupings, making it easy to see patterns and distinctions across data categories. Other options don’t fit as well. Report queries are database-style tools not typical for standard Excel summarization. Frequency tables describe how often values occur but don’t provide the flexible, multi-dimensional cross-tab layout that pivot tables offer. Diagnosis classifications aren’t related to Excel’s data summarization tools.

Pivot tables are Excel tools designed to summarize data by categories. They let you drag category fields into rows and columns and place numeric data into values to compute sums, counts, averages, and other aggregations. This creates a compact summary that shows totals for each category and can be filtered or rearranged to compare different groupings, making it easy to see patterns and distinctions across data categories.

Other options don’t fit as well. Report queries are database-style tools not typical for standard Excel summarization. Frequency tables describe how often values occur but don’t provide the flexible, multi-dimensional cross-tab layout that pivot tables offer. Diagnosis classifications aren’t related to Excel’s data summarization tools.