Interview preparation guide
Excel Interview Questions With a Practice Workbook
Practice Excel interview questions by explaining the model, working through a small problem and checking failure cases. These original exercises test reasoning rather than recall of a claimed employer question list.
Download the practice files
Excel interview practice workbook
Fictional sales data, practice tasks, formulas and a separate expected-answer sheet. No macros or external connections.
Download XLSXScope and assumptions
The practice workbook uses common spreadsheet formulas and fictional sales rows. XLOOKUP requires a supported Excel version; the workbook also demonstrates SUMIF and an explicit duplicate check.
Confirm the version, deployment model and permissions in the interview. The examples use fictional data and are deliberately small. A snippet demonstrates one idea; it is not a complete production system.
How do you choose a lookup method?
Identify the key, match type and expected behavior for missing or duplicate keys. An exact match is often appropriate for identifiers. A lookup can return a plausible value while hiding a data-quality problem.
When would you use a PivotTable?
Use it to summarize data by categories and explore totals at a defined grain. Check source ranges, refresh state and duplicates. A PivotTable does not validate the meaning or completeness of the source data.
What makes a formula auditable?
Clear inputs, consistent units and explicit assumptions help another person check it. Avoid unexplained hard-coded constants and hidden errors. Show a manual check using a small subset.
How do you handle a missing value?
Decide whether it means unknown, not applicable or zero. These are different states. Use an explicit missing-result message when appropriate rather than silently turning every error into zero.
Worked exercise
Use the downloadable workbook. The Data sheet has Order ID in A, Region in B and Amount in C. Calculate East sales and check whether the order IDs are unique.
=SUMIF(Data!B2:B5,"East",Data!C2:C5)
=COUNTIF(Data!A2:A5,Data!A2)
=XLOOKUP(103,Data!A2:A5,Data!C2:C5,"Not found",0)Expected result and explanation
East sales total 175 from amounts 100, 50 and 25. The count for ID 101 is 1, and the exact lookup for 103 returns 50. The workbook includes an answer sheet and a change exercise: add a duplicate ID, then explain why a lookup alone may not reveal it.
Before changing the example, predict the result. Then vary one input or constraint and explain why the behavior should change. Keep the distinction between a measured result and an assumption clear.
Debugging and follow-up
If the result is wrong, check text-formatted amounts, range boundaries, duplicate keys and calculation settings. Do not hide a source-data issue by wrapping every formula in a generic error suppression.
- What evidence would distinguish your first explanation from an alternative?
- Which boundary, permission or failure case should be checked?
- How would you reproduce the issue without affecting live users?
Practice checklist
Explain one design decision aloud and support it with the worked example. Use the official documentation below to check version-specific behavior.
- I stated the relevant version and environment.
- I can explain the expected result and an edge case.
- I can separate correctness, performance and security concerns.
- I know which parts require a real runtime or service to verify.
Questions, answered
Are these questions used by a particular employer?
No. They are original practice questions. Employers can assess different tools, versions and levels of depth.
How should I verify the exercise?
Use an isolated local or sandbox environment with the stated prerequisites. Compare the expected result, then test an edge case. Do not run service commands against a shared or production system.
Sources and examples
ResumizeAI team. Examples are fictional teaching material, not customer results. Replace sample details with your own facts.
Your experience. A complete resume.
Build in Resumize with ATS-friendly templates, guided editing and a live preview. Start free, then upgrade when you need more.
Free account required. Free-plan PDF exports include a watermark.