Excel interview questions and answers
Excel is the most widely tested skill in India outside programming, and it is usually tested with a laptop in front of you rather than by discussion. Analyst and finance interviews often run a thirty-minute hands-on task, and the panel watches how you reach the answer as much as whether you reach it.
Asked of: Analysts, finance, operations, HR, supply chain and most non-engineering desk roles. Every answer below describes what a strong response covers rather than a script to memorise, because the follow-up question is where these rounds are actually decided.
Lookups and references
VLOOKUP, INDEX with MATCH, XLOOKUP, and knowing when a reference has to be absolute. A dragged formula that shifted is behind a large share of failed Excel tests.
Pivot tables
Building one quickly, grouping, and knowing what a pivot cannot do for you.
Cleaning messy data
Duplicates, trailing spaces, numbers stored as text, inconsistent dates. Test data is dirty on purpose.
Formulas that survive other people
Error handling, and building something that still works when somebody else opens it next month.
Where Excel stops
Power Query, the data model, and the honest point at which the work belongs in SQL instead.
Excel interview questions for freshers
What is the difference between VLOOKUP and INDEX with MATCH?
VLOOKUP only looks to the right and breaks when a column is inserted, because the column number is positional. INDEX with MATCH looks in any direction and survives the insert. Mention XLOOKUP if your version has it, and say which version that is.
What does the dollar sign do in a formula?
It locks the row, the column, or both, when the formula is copied. Give the case that needs a mixed reference, such as one rate column applied across a grid, because that is the real test.
When would you use a pivot table?
To summarise by category without writing formulas, and to change the cut while somebody is still asking questions. Say what makes source data pivot-ready: one header row, no merged cells, no blanks in the key columns.
How do you find and remove duplicates?
See them first with conditional formatting or COUNTIFS, then use Remove Duplicates once you know what a duplicate means here. Say that you check before deleting, because the definition is a business question.
SUMIF or SUMIFS?
SUMIFS takes several conditions and puts its arguments in a different order, which is exactly the mistake people make when switching between them. Show that you know the criteria syntax for text, numbers and dates.
What do #N/A, #REF! and #VALUE! mean?
Nothing matched, a reference was deleted, and the wrong data type reached the formula. Say what you do about each, and why wrapping everything in IFERROR hides a problem instead of fixing it.
This column of numbers will not add up. Why?
They are stored as text, usually straight out of an export. Explain the checks you run, such as alignment and ISNUMBER, and two ways to convert. This turns up in almost every hands-on test.
How do you make a large sheet usable?
Freeze panes, filters, a real header row, and formatting as a table so ranges grow on their own. A small answer, but it shows the panel you have handled real files.
What is conditional formatting good for?
Making an exception visible without building a second report: overdue items, negative margins, duplicates. Mention that a formula-driven rule is what makes it useful beyond colour scales.
How would you compare two lists to find what is missing?
A lookup or COUNTIF against the other list, run in both directions. Saying "both directions" is what separates a complete answer from half of one.
Excel interview questions for experienced candidates
A workbook takes a minute to open and recalculates constantly. What do you fix?
Volatile functions such as OFFSET, INDIRECT and NOW, whole-column references, and formulas fanned across thousands of cells that a pivot or Power Query should be handling. Say how you would measure before rewriting anything.
When do you use Power Query instead of formulas?
When the same cleaning happens every month. The steps are recorded and re-run on refresh, so nobody repeats a manual paste. Describe one pipeline you built and what it replaced.
Two reports that should reconcile do not. How do you find the gap?
Agree the definition first, then compare totals, then counts, then join at key level to isolate rows present in one and missing from the other. Say how often the cause turns out to be a definition difference rather than bad data.
How do you build a model somebody else has to maintain?
Separate raw data, calculations and presentation, keep inputs in one place and mark them, never hardcode a number inside a formula, and write the assumptions on the sheet. This question identifies everyone who has inherited someone else's file.
What do dynamic array formulas change?
FILTER, UNIQUE and SORT spill a whole result instead of needing one formula per cell, which removes an entire class of copy errors. Note that they need a recent version, and say what you do when the client is on an older one.
You inherit an undocumented workbook. What do you do first?
Trace precedents from the output cells, hunt the hardcoded numbers sitting inside formulas, and check for external links that will break. Do not start by improving it: the first job is knowing what it currently produces.
How do you stop users breaking a template?
Data validation on the inputs, locked cells with the sheet protected, instructions on the sheet itself, and error messages that say what to do instead. Assume somebody will paste over a formula, because somebody will.
When should this work leave Excel?
When the data outgrows a sheet, when several people need to edit at once, when you need an audit trail, or when a file being emailed around has become the source of truth. Name what you would move it to and why.
When is a macro the right answer?
For a repetitive task with a stable process and a named owner. Say the cost as well: an unmaintained macro nobody can read becomes a liability the day its author leaves.
Talk me through a dashboard you built and who used it.
The decision it supported, where the data came from, how it refreshed, and what you removed to keep it readable. A dashboard nobody opened is a fair answer if you can say why it was not adopted.
- Expect a hands-on test. Practise on a deliberately messy file against a timer rather than reading lists of formulas.
- Say your Excel version early. XLOOKUP and FILTER do not exist for someone on an older build, and claiming them invites a live demonstration.
- For analyst roles, Excel and SQL are asked in the same interview. Prepare both, because the strong half will not carry the weak one.
- Talk while you work in the test. Panels score your approach, and a silent candidate who reaches the right number scores lower than you would expect.
Answer them out loud before someone asks
Reading a question and answering it under a follow-up are different skills. Practise these against an AI interviewer that pushes back and scores your answer, or check your resume first with the free ATS resume checker.
Start My Free Mock Interview