Which statement about pivot tables is true?

• A. They can summarize data across multiple categories at once.
• B. They cannot handle non-numeric data.
• C. They require manual re-calculation for each category.
• D. They automatically sort data alphabetically.

Answer: (A)

Pivot tables let you reorganize and summarize large data sets by different dimensions at once. They enable cross-tabulation, letting you see how measures like revenue, quantity, or orders behave across combinations of categories such as product lines and regions, or time periods and customer segments. You can choose different calculations (sum, average, count) and instantly reconfigure the rows and columns to compare multiple categories simultaneously, which is exactly what the statement captures.

Non-numeric data isn’t a barrier—pivot tables can still summarize it by counting occurrences or listing unique items, rather than forcing a numeric operation. They don’t require manual recalculation for each category; the pivot table recalculates automatically as you change the layout or filters. Sorting isn’t fixed to alphabetical order; you can sort by any field and in any order as needed.