← 30 Days Excel Series
Day 8 of 30BeginnerPivot Tables

Day 8: Pivot Tables — Fundamentals

5 questions · Excel Interview Preparation

Q1

What is a Pivot Table and what problems does it solve?

A Pivot Table automatically summarises large flat datasets into meaningful aggregated views without writing formulas. It solves the core data analyst problem: "I have 50,000 transaction rows — what is the total revenue by region and product category?" A Pivot Table answers this in 30 seconds by dragging Region to Rows, Category to Columns, and Revenue to Values. It is the fastest tool for exploratory analysis in Excel.

💡 Interview tip: In interviews, when asked how you would analyse a dataset, mention Pivot Tables early — it signals practical experience.
Q2

How do you create a Pivot Table?

Click anywhere inside your data → Insert → PivotTable → choose location (new worksheet recommended) → OK. This opens the PivotTable Fields pane on the right. Drag fields to the four areas: Rows (groups on vertical axis), Columns (groups on horizontal axis), Values (the metric to aggregate), Filters (the slicer at the top). Always convert source data to a Table (Ctrl+T) first — then the Pivot Table automatically includes new rows when refreshed.

💡 Interview tip: Convert to Table before creating the Pivot Table — otherwise you must manually update the source range whenever new rows are added.
Q3

What are the default aggregation functions in a Pivot Table and how do you change them?

When you add a numeric field to Values, Excel defaults to SUM. When you add a text field, it defaults to COUNT. To change the aggregation: click the field in the Values area → Value Field Settings → choose Sum, Count, Average, Min, Max, or Count Numbers. You can also add the same field multiple times and set different aggregations for each — for example, Revenue as Sum in one column and Average in another.

💡 Interview tip: If a numeric field shows Count instead of Sum, check for any text or blank cells in the column — one non-numeric cell causes Excel to default to Count.
Q4

How do you group dates by month or quarter in a Pivot Table?

If your date column is correctly formatted as dates, right-click any date value in the Row or Column area of the Pivot Table → Group → choose Months, Quarters, or Years (you can select multiple). Excel will automatically group all dates into the selected period. If grouping is greyed out, your date column contains text-formatted dates — convert them first using =DATEVALUE() or Power Query.

💡 Interview tip: Date grouping not working usually means the date column is stored as text. Fix the source data, not the Pivot Table.
Q5

How do you sort a Pivot Table by value?

Click any cell in the Values column you want to sort by → Data → Sort Largest to Smallest (or use the Sort button). Alternatively, right-click a value → Sort → Sort Largest to Smallest. To sort rows by their total value — for example, show regions sorted by highest total revenue — click the Grand Total column value and sort from there.

💡 Interview tip: Sorting by value (not label) in a Pivot Table always trips beginners. Click a VALUE cell, not a label cell, before sorting.
← Day 7All DaysDay 9 →

Want 1:1 Excel coaching?

Join EVIKA Academy for live Excel training, real projects, and placement support in Delhi NCR.

Book Free Demo →
Best Data Analytics Course in Noida Delhi NCR | EVIKA ACADEMY