Question

What is meant by ‘Pivot Table’? What are its uses?

Hint:

Use Pivot Tables in Excel to quickly summarise, filter, and analyse data without modifying the source.

Answer 1

A Pivot Table is an interactive table in Excel used to summarise large data sets. It allows users to reorganise and group data dynamically without altering the original dataset. **Uses:** 1. **Summarising Data**: Summarises numerical data (e.g., totals, averages). 2. **Grouping and Filtering**: Allows grouping data (by date, category, etc.) and applying filters. 3. **Comparison**: Helps in comparing data across different dimensions. 4. **Dynamic Analysis**: Rearranging fields by drag-and-drop enables multiple views of the same data. 5. **Quick Reporting**: Enables fast generation of summaries without complex formulas.