Question

To add a "pivot table" in MS Excel which tab is used?

• A. Insert
• B. Home
• C. Format
• D. File

Answer 1

Answer:

A. Insert

Pivot Table

• Pivot Tables summarize, analyze, explore, and present summary data.

- Method: Select the data range, go to the "Insert" tab, and click "PivotTable."

- Example: To create a PivotTable, select the data range A1-10, go to "Insert > PivotTable," choose a location for the PivotTable, and then drag fields to the Rows, Columns, and Values areas to summarize the data.