What is the primary purpose of the Values area in a pivot table?

• A. To display the raw data entries
• B. To apply filters to the dataset
• C. To define row labels
• D. To display calculated summaries like sums, counts, averages

Answer: (D)

The Values area is where you see calculated summaries of the data. When you place a numeric field there, the pivot table computes an aggregate—like a sum, count, or average—across the groups defined by the row and column fields. This is what you use to get totals, averages, or counts for each category, rather than showing the raw data itself. For example, with sales data organized by region and product, putting Sales in the Values area will display total sales for each region/product; you can switch the function to average, count, min, max, etc. Raw entries stay in the underlying data, while filters affect what data is included, and row labels come from the Rows area.