Which Excel tool would you use to summarize a dataset by category counts across multiple fields?

Which Excel tool would you use to summarize a dataset by category counts across multiple fields?

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

Answer: (B)

Summarizing a dataset by category counts across multiple fields is best done with a pivot table in Excel. A pivot table lets you drag category fields into Rows and Columns to define the categories you want to compare, and place a data field in Values set to Count to show how many records fall into each category combination. By adding more fields to Rows or Columns, you can build a multi-dimensional summary that shows counts across several dimensions at once. Pivot tables also make it easy to adjust the view, filter for subsets, and refresh as data changes, which is why they’re ideal for this task. Other options don’t fit as well: frequency tables handle distributions of a single variable and don’t readily support cross-tabulations over several fields; report queries and diagnosis classifications aren’t standard Excel tools for this kind of multi-field summary.

Summarizing a dataset by category counts across multiple fields is best done with a pivot table in Excel. A pivot table lets you drag category fields into Rows and Columns to define the categories you want to compare, and place a data field in Values set to Count to show how many records fall into each category combination. By adding more fields to Rows or Columns, you can build a multi-dimensional summary that shows counts across several dimensions at once. Pivot tables also make it easy to adjust the view, filter for subsets, and refresh as data changes, which is why they’re ideal for this task. Other options don’t fit as well: frequency tables handle distributions of a single variable and don’t readily support cross-tabulations over several fields; report queries and diagnosis classifications aren’t standard Excel tools for this kind of multi-field summary.