What does the Values area do in a pivot table?

• A. Aggregates data using functions like sum, count, or average.
• B. Holds raw metadata about the dataset.
• C. Defines the chart style.
• D. Hides rows and columns.

Answer: (A)

In a pivot table, the Values area is where you specify the numeric data to be summarized and how it should be calculated. You place a numeric field here, and the pivot table applies an aggregation—such as sum, count, or average (and others like min or max)—to produce a metric for each combination of the row and column labels. For example, with sales data, dropping Sales Amount into Values will show total sales by region or by product, depending on what you have in Rows and Columns. You can switch the calculation to show total revenue, average order value, or the number of orders. This area is all about calculations, not storing raw metadata, defining chart styles, or hiding rows/columns.