What do Rows in a pivot table display?

• A. Data categories displayed vertically.
• B. Selected values from the data displayed horizontally.
• C. All data entries in the original dataset.
• D. Calculated totals for each category.

Answer: (A)

Pivot tables present data categories as row labels that run down the left side, so each unique value from the field placed in the Rows area appears as its own row from top to bottom. This vertical listing is what you use to group and compare measures (totals, averages, counts) across those categories when you place other fields in columns or in the Values area. The entire original dataset isn’t shown in the rows because pivot tables summarize data; totals and calculations appear in the Values area, not as row labels. If you put a field in Columns, those categories shift to the top horizontally, reinforcing that rows are the vertical axis.