Why are pivot tables more efficient than filtering when comparing data across multiple states?

• A. They can automatically export results to slides.
• B. They provide different insights not possible with filtering.
• C. They summarize counts for all states at once, saving time.
• D. They require no data preparation.

Answer: (C)

Pivot tables save time by grouping and aggregating data by state in one view. When you set up a pivot table to count or sum by state, it automatically shows the totals for every state side by side. That lets you compare across all states at a glance without applying and reapplying filters for each state or weaving together multiple views. The efficiency comes from seeing the entire, organized summary in a single table, rather than building separate filtered results each time.

Other ideas don’t capture this time-saving strength: exporting results to slides isn’t automatic with a pivot table, and while pivot tables can reveal insights that filtering alone might miss, the main benefit here is the quick, comprehensive aggregation across all states. Also, you still need well-structured data to build a pivot table, so it doesn’t eliminate data preparation.