Krishi Samagri Company2083 BSQuestion 6 of 14
Define PivotTable in MS Excel. Explain how it helps in summarizing and analyzing large sets of data.
5 marks
Question source
- Exam year
- 2083 BS / 2026 AD
- Level
- Level 5
- Paper
- Paper II – Subjective
- Section
- Section B
Model answer
A PivotTable turns thousands of raw rows into an instant summary without formulas — drag fields to Rows, Columns, Values, Filters.
How it helps: Raw dealer table (Date, District, Sales) → drag District to Rows, Sales to Values (Sum) → district-wise total in 3 clicks. Group dates by month, filter top 5 products, Refresh on new data. No SUMIFS errors; plus PivotChart for visual reports. Example: head office sees "Madhesh: 80 tons urea in Jestha" for quota decisions.