How do pivot tables differ from sorting and filtering in terms of efficiency?

• A. Pivot tables allow you to view multiple insights at once, saving time compared to sorting and filtering for individual values
• B. Pivot tables require more steps
• C. Pivot tables cannot summarize data
• D. Pivot tables are slower than sorting

Answer: (B)

Pivot tables boost efficiency by letting you summarize data across multiple dimensions in one view. You can drag fields into rows, columns, and values to instantly see aggregated results for many combinations (for example, total sales by product and by region) without building separate views each time. Sorting and filtering, by contrast, usually require creating new views or repeatedly adjusting filters to inspect different values, which takes more steps. Because pivot tables consolidate multiple insights into a single, reconfigurable table, they let you explore data quickly and answer multi-faceted questions with less effort.