Prepare for an Excel interview by working through a small spreadsheet from start to finish. Interviewers may ask you to explain how you wrote a formula, checked a report or fixed messy data. This exercise gives you examples you can talk through and verify on your own.
Excel interview questions for freshers
- When would you use SUMIF?
-
Use SUMIF to total numbers that match one condition, such as revenue for the East region. Use SUMIFS if you also need to match a product or another condition.
- What is the difference between A2 and $A$2?
-
A2 moves when you copy a formula. $A$2 stays fixed. Use a fixed reference for a tax rate or a target percentage stored in one cell.
- When would you build a PivotTable?
-
Use it to group rows and summarise values, such as total revenue for each region. Give every source column a header, keep the number columns numeric and refresh the PivotTable after editing the source values.
- How do you look up a product price?
-
In versions that support XLOOKUP, search for the product name in a price list and return its price. In older versions, use an exact-match VLOOKUP with the product in the first column of the lookup range.
- How do you check a spreadsheet before sharing it?
-
Look for blank required fields, duplicates and inconsistent names. Check that number columns are stored as numbers. Compare the grand total against an independent total or manually check a few rows.
Practical Excel interview test
Copy the five source columns into cells A1:E7. Leave the sixth column for your calculations. Give yourself 15 minutes and explain one formula aloud when you finish.
| Sale | Region | Product | Units | Unit Price | Revenue |
|---|---|---|---|---|---|
| 1 | East | Notebook | 12 | 50 | |
| 2 | West | Mouse Pad | 8 | 75 | |
| 3 | East | USB Cable | 5 | 120 | |
| 4 | North | Notebook | 10 | 50 | |
| 5 | West | USB Cable | 6 | 120 | |
| 6 | East | Mouse Pad | 4 | 75 |
- Calculate revenue for every sale and the grand total.
- Find total revenue for the East region.
- Count how many sales have at least eight units.
- Build a PivotTable showing revenue by region and identify the region with the highest revenue.
Answer key
- Enter
=D2*E2in F2 and fill down to F7. The results are 600, 600, 600, 500, 720 and 300.=SUM(F2:F7)returns 3,320. =SUMIF(B2:B7,"East",F2:F7)returns 1,500. Microsoft’s SUMIF reference.=COUNTIF(D2:D7,">=8")returns 3.- Use A1:F7 as the source, place Region in Rows and set Revenue in Values to Sum. East leads with 1,500, followed by West at 1,320 and North at 500.
For a follow-up challenge, make a bar chart from the regional totals. In a mock interview, explain how you would check that the chart and PivotTable still agree after a price changes.
For more spreadsheet exercises, explore the Advanced Excel course in Ambala or ask about the current course syllabus.