What are the three common components of a pivot table?

What are the three common components of a pivot table?

• A. Rows, Columns, Values
• B. Data, Tables, Slicers
• C. Headers, Footers, Legends
• D. Formulas, Macros, Data

Answer: (A)

Pivot tables organize data by placing fields into three areas: rows, columns, and values. Rows define the categories you want listed down the left side, columns create the headers across the top, and values contain the numeric data that gets calculated (such as sums, counts, or averages) for each row/column intersection. For example, you could put regions in rows, products in columns, and sales in values to see how much each product sold in each region. There are additional features like filters or slicers to narrow what’s shown, but the core structure is defined by those three areas. The other options describe related elements (filters, layout components, or tools) that aren’t the primary building blocks of a pivot table.

Pivot tables organize data by placing fields into three areas: rows, columns, and values. Rows define the categories you want listed down the left side, columns create the headers across the top, and values contain the numeric data that gets calculated (such as sums, counts, or averages) for each row/column intersection. For example, you could put regions in rows, products in columns, and sales in values to see how much each product sold in each region. There are additional features like filters or slicers to narrow what’s shown, but the core structure is defined by those three areas. The other options describe related elements (filters, layout components, or tools) that aren’t the primary building blocks of a pivot table.