Which spreadsheet feature is used to summarize data by aggregating values and showing totals?

• A. Chart
• B. Data validation
• C. Conditional formatting
• D. Pivot table

Answer: (D)

Summarizing data by aggregating values and showing totals is what a pivot table is designed to do. A pivot table lets you take a large dataset and reorganize it so you can compute totals, averages, counts, and other summaries across different groupings like region, product, or time period. You can drag fields into rows, columns, and values to see how totals change when you group the data in new ways, without altering the underlying data. This makes it easy to spot trends and compare categories—for example, total sales by region and product line or average scores by class. Other features serve different purposes: charts visualize data, data validation restricts inputs, and conditional formatting highlights values based on rules rather than performing aggregations.