What are the three basic parts of a pivot table?

• A. Rows, Columns, and Values.
• B. Rows, Columns, and Filters.
• C. Rows, Summary, and Values.
• D. Rows, Columns, and Totals.

Answer: (A)

Pivot tables organize data using three core elements: rows, columns, and values. Rows list the categories you want to group by (such as product type or region). Columns establish the second dimension for comparison (for example, months or another category). Values contain the numeric measures you summarize (sums, averages, counts) at each row/column intersection. Filters let you restrict which data is included, but they aren’t one of the primary structural parts. Totals are the results of aggregating the values, not a separate component, and summary is just another way to describe those calculations rather than a distinct part. So the three basic parts are rows, columns, and values.