_______ tables are useful Excel tools to summarize a data set.

_______ tables are useful Excel tools to summarize a data set.

• A. Frequency
• B. Pivot
• C. Factual
• D. Monthly

Answer: (A)

Pivot tables are the tool in Excel built to summarize a dataset quickly and powerfully. They let you reorganize data by dragging fields into rows and columns, then compute aggregates like sums, counts, averages, and percentages. This lets you see patterns across multiple dimensions—for example, totals by product and region or averages over time—without changing the original data. You can also filter or slice the results to compare different views on the fly, which makes pivot tables ideal for exploring a dataset from many angles. Frequency tables, while useful for showing how often each value appears, don’t provide the same flexible, multi-dimensional summaries or quick reorganization that pivot tables offer. Monthly and factual aren’t standard types of summary tools for data analysis in Excel.

Pivot tables are the tool in Excel built to summarize a dataset quickly and powerfully. They let you reorganize data by dragging fields into rows and columns, then compute aggregates like sums, counts, averages, and percentages. This lets you see patterns across multiple dimensions—for example, totals by product and region or averages over time—without changing the original data. You can also filter or slice the results to compare different views on the fly, which makes pivot tables ideal for exploring a dataset from many angles.

Frequency tables, while useful for showing how often each value appears, don’t provide the same flexible, multi-dimensional summaries or quick reorganization that pivot tables offer. Monthly and factual aren’t standard types of summary tools for data analysis in Excel.