Which Excel feature allows you to rearrange and summarize data by dragging fields into rows, columns, and values?

Which Excel feature allows you to rearrange and summarize data by dragging fields into rows, columns, and values?

• A. Chart
• B. PivotTable
• C. Conditional Formatting
• D. Data Validation

Answer: (B)

PivotTable is the tool that lets you rearrange and summarize data by dragging fields into rows, columns, and values. This interactive feature makes it easy to see different groupings and totals without writing formulas. For example, with a sales dataset you can place Region in the rows, Product in the columns, and Sum of Sales in the values area to quickly view sales by region and product. You can swap what goes into rows or columns to explore alternative perspectives, and you can add filters or group dates to drill down further. This ability to pivot and aggregate data on the fly is what sets PivotTable apart from charts (which focus on visual representation), and from conditional formatting or data validation (which control appearance or input rules rather than data structure).

PivotTable is the tool that lets you rearrange and summarize data by dragging fields into rows, columns, and values. This interactive feature makes it easy to see different groupings and totals without writing formulas. For example, with a sales dataset you can place Region in the rows, Product in the columns, and Sum of Sales in the values area to quickly view sales by region and product. You can swap what goes into rows or columns to explore alternative perspectives, and you can add filters or group dates to drill down further. This ability to pivot and aggregate data on the fly is what sets PivotTable apart from charts (which focus on visual representation), and from conditional formatting or data validation (which control appearance or input rules rather than data structure).