Which action best demonstrates the advantage of pivot tables in data analysis?

• A. Providing a compact summary of large data by slicing and dicing the data.
• B. Replacing the need for any data collection.
• C. Editing source data directly.
• D. Formatting text in cells.

Answer: (A)

Pivot tables shine when you need a concise summary of large data sets and you want to explore different perspectives quickly by slicing and dicing the data across various dimensions. They let you drag fields to rows, columns, and values to aggregate data with sums, averages, counts, and more, so you can see patterns and comparisons without manually filtering or reshaping the raw data. This ability to flexibly rearrange the view to summarize across multiple attributes is what makes pivot tables so powerful for analysis.

The other options aren’t aligned with that strength: pivot tables don’t replace data collection or directly edit the source data, and formatting in cells is not what they’re designed to optimize.