Which option would you use to insert a PivotTable based on existing data?

Which option would you use to insert a PivotTable based on existing data?

• A. Design tab, Chart group, PivotChart
• B. Insert tab, Tables group, PivotTable
• C. Data tab, Sort & Filter group, Pivot
• D. Review tab, Changes group, Create Pivot

Answer: (B)

To insert a PivotTable from existing data, use the Insert tab and, in the Tables group, click PivotTable. This is the dedicated path Excel provides for creating PivotTables directly from a data range or table, and you can choose to place the new PivotTable in a new worksheet or in an existing one. PivotTables let you quickly summarize and analyze large datasets by dragging fields into rows, columns, values, and filters. The other options belong to different features—one would create a PivotChart rather than a PivotTable, and the remaining tabs don’t offer the PivotTable command.

To insert a PivotTable from existing data, use the Insert tab and, in the Tables group, click PivotTable. This is the dedicated path Excel provides for creating PivotTables directly from a data range or table, and you can choose to place the new PivotTable in a new worksheet or in an existing one. PivotTables let you quickly summarize and analyze large datasets by dragging fields into rows, columns, values, and filters. The other options belong to different features—one would create a PivotChart rather than a PivotTable, and the remaining tabs don’t offer the PivotTable command.