Most Excel interviews come down to three things: whether you know the core concepts, whether you can build a formula on the spot, and whether you can explain how you have used spreadsheets at work. This guide gives you the questions that come up most, with answers short enough to say out loud, and a way to practice until the answers feel automatic.
There are usually three layers, and a single hiring process can use all of them.
Conversation questions. "What is the difference between a formula and a function?" or "How do you protect a workbook?" These check vocabulary and whether you understand what you click. Indeed's guide to Excel interview questions says interviewers may ask about functions such as VLOOKUP, PivotTables and protecting workbooks, and suggests tying answers to your own experience.
Scenario questions. "You get a sales export with duplicate customers and blank rows. What do you do?" There is no single right answer. The interviewer wants to hear a sensible order of steps.
Hands-on tests. You get a file and a set of tasks with a time limit. Standardized skills tests cover this ground too. The SCE Excel test, for example, covers file management, editing, formatting, analysis, printing, tools and automation, and graphics, so a pre-employment test can reach well beyond formulas.
How deep the questions go depends on the job. An administrative role will stay at formatting, sorting and simple formulas. An analyst role will move quickly to lookups, PivotTables and data cleaning.
These show up in almost every screening. Keep each answer to two or three sentences.
A cell address is the column letter plus the row number, such as B4. A relative reference (B4) changes when you copy the formula to another cell. An absolute reference ($B$4) stays fixed. A mixed reference locks only the row or the column ($B4 or B$4). Mention that you press F4 to cycle through the types while editing a formula.
A formula is any calculation you enter. Formulas begin with an equals sign and can contain functions, references, operators and constants. A function is a built-in routine such as SUM or IF that you can use inside a formula. So =A1+A2 is a formula with no function, and =SUM(A1:A2) is a formula that uses one.
Excel stores data as text, floating point numbers or integers. It can present data in formats including accounting, date, time, currency, number, percentage, fraction, scientific, special, text and custom. A good follow-up point: formatting changes how a value looks, not what it is. A date that looks like text will not sort or calculate correctly, and that is one of the most common causes of broken reports.
Paste Special lets you paste selected attributes, such as formulas, values or formatting, rather than everything in the cell. A practical example: pasting values only so a number stays put after the source data changes or is deleted. Pasting formats only is the quick way to make a new table match an existing one.
Conditional formatting applies cell formats based on values. Give a work example: highlighting invoices past due in red, or the top 10 percent of sales reps in green. That one sentence of example is what separates a memorized definition from real use.
Data validation lets you choose what type of data is allowed in a cell and create error messages when the criteria are not met. The classic example is a dropdown list in an input column, so nobody types "NY", "N.Y." and "New York" for the same thing.
Freeze panes keeps headers visible while you scroll. Sorting reorders rows by one or more columns. Filtering hides rows that do not match your criteria without deleting them. If asked about sorting by several levels, say you use the custom sort dialog and add one level per column.
This is where interviews start separating candidates. Useful functions that Indeed lists include SUM, AVERAGE, VLOOKUP, COUNT, TRUE/FALSE and DATE, and you should add IF, COUNTIF, SUMIF and text functions to the list.
=IF(B2>=70,"Pass","Fail"). Interviewers often follow up by asking for three outcomes, which means nesting a second IF or using IFS. Practice that version too. Our IF function examples and practice walk through both.
COUNT counts cells containing numbers. COUNTA counts any non-empty cell. COUNTIF counts cells that meet a condition, such as =COUNTIF(C:C,"Open"). SUMIF and AVERAGEIF follow the same pattern.
VLOOKUP searches the first column of a table for a value and returns a value from a column to the right. The four arguments are the lookup value, the table, the column number and the match type. Use FALSE (or 0) for an exact match. Its limits are that it only looks right, and that hard-coded column numbers break if someone inserts a column. You can rehearse the syntax with the VLOOKUP examples and practice.
Microsoft describes XLOOKUP as working in any direction and returning exact matches by default, which removes two classic VLOOKUP traps. If the role uses an older Excel version, say you would fall back on INDEX and MATCH, which also looks left. You can try that pairing in our INDEX function practice exercise.
SORTBY sorts the contents of a range or array based on values in a corresponding range or array. It lets you sort one list by another column without including that column in the result. If you want to see it work, try the SORT function practice exercise.
Excel evaluates parentheses first, then exponents, then multiplication and division, then addition and subtraction. Comparison and concatenation operators come after arithmetic. The operators practice exercise is a quick way to drill this.
"What does #N/A mean?" is a favorite because it tests whether you can debug. Microsoft's documentation lists the common error values: #DIV/0! (division by zero or an empty cell), #N/A (a value is unavailable), #NAME? (unrecognized text), #NULL! (the intersection of disjoint ranges), #NUM! (an invalid numeric value), #REF! (an invalid reference) and #VALUE! (incompatible data types).
| Error | Typical cause | What you say you would check |
| #DIV/0! | Dividing by zero or a blank cell | The denominator, or wrap the formula in IFERROR |
| #N/A | A lookup found nothing | Spelling, trailing spaces, match type, data type |
| #NAME? | Misspelled function or name | Function spelling, quotes around text |
| #REF! | A deleted or invalid reference | Whether rows or columns were deleted |
| #VALUE! | Text where a number was expected | Data types in the referenced cells |
| #NUM! | An invalid numeric value | Arguments that are impossible, such as a negative square root |
| #NULL! | A space between disjoint ranges | Use a comma or colon between ranges |
For analyst, finance and reporting jobs, expect questions in this tier. Indeed notes that interviewers may ask about Power Query for refining data, macros for automating repetitive tasks, What-If analysis and PivotTables for summarizing data.
A PivotTable summarizes data from a different table and displays it meaningfully. Describe the workflow: clean the source into a proper table with one header row, insert the PivotTable, drag fields into Rows, Columns and Values, then group dates or add a slicer. Say what you did with one. "I summarized 40,000 order lines by region and month so the manager could spot slow regions" beats any definition.
Power Query can find, combine and refine data across a wide variety of internal and external sources. In an interview, frame it as the tool you use when you would otherwise repeat the same cleanup every month: import, remove blanks, split columns, merge files, then refresh when new data arrives.
A macro records or scripts a sequence of actions so you can replay it. It is right for repetitive formatting or report assembly. It is the wrong answer when a formula, a PivotTable or Power Query can do the job, because macros are harder for coworkers to audit and may not run in every environment. Showing that judgment is worth more than showing you can record one.
A solid sequence: back up the raw data, remove duplicates, trim extra spaces, fix data types (text-numbers and text-dates), standardize categories with a dropdown or lookup table, then check totals against the source. Name the functions you would use, such as TRIM, TEXT, LEFT, RIGHT, and TEXTSPLIT or Text to Columns.
It lets you change inputs and watch results change. Goal Seek works backward from a target (what sales do I need to hit a profit goal), Scenario Manager stores sets of assumptions, and data tables show many outcomes at once. Give one example from a budget or forecast.
A timed test usually hands you a workbook and a list of tasks. Typical ones:
A right answer delivered badly still loses points. Three habits help.
Answer the question asked. The University of Massachusetts Isenberg School of Management advises answering the question actually asked, asking for clarification when needed, using specific examples tied to job requirements and never exaggerating your skills. If you have used VLOOKUP daily but never touched macros, say so, then say how you would learn.
Use a structure for experience questions. Indeed recommends the STAR method: Situation, Task, Action, Resolution. Example: "Our monthly sales report took a day to assemble (situation). I was asked to shorten it (task). I replaced copy-paste with a PivotTable and lookups (action). It now takes an hour, and errors dropped (result)." Only say numbers that are true.
Explain the why. "I'd use XLOOKUP because it won't break if columns move" shows reasoning. Reciting syntax does not.
We built LogicExcel around one observation: people who prepare for Excel interviews by watching videos or reading Q&A lists tend to recognize answers but freeze when asked to produce one. Recognition is not recall. Interviews, especially hands-on tests, reward recall under time pressure, and recall comes from typing the formula yourself and being told immediately when it is wrong.
That is why every exercise on our platform asks you to enter a formula in an Excel-like environment and gives instant feedback, with an explanation of each mistake. We think the mistakes are the useful part. If you write VLOOKUP with the wrong match type and see why it returned the wrong value, you are far less likely to repeat it in front of an interviewer.
Our advice for any candidate: spend most of your prep time typing, not reading. Read a question list once to see the territory, then close it and write the formulas from scratch.
> — Thomas Houza
If you want to rehearse the formulas in this guide rather than just read them, our 95 free Excel exercises run in an Excel-like environment with instant feedback. You do not need an account or any software installed.
For a structured route, the Excel courses go from the fundamentals up through more advanced skills. If your role involves finance, the free 5 Days to Better Accounting Spreadsheets mini course applies the same skills to accounting work. Beginners can start with our Excel exercises for beginners.
| Day | Focus | What to do |
| 1 | Basics | References, formats, Paste Special, sorting, filtering, freeze panes |
| 2 | Core formulas | SUM, AVERAGE, COUNT, IF, SUMIF, COUNTIF, nested IF |
| 3 | Lookups | VLOOKUP, XLOOKUP, INDEX and MATCH, plus the errors they produce |
| 4 | Analysis | PivotTables, charts, conditional formatting, data validation |
| 5 | Mock test | A timed test, then review every mistake and your two best work stories |
You do not need to memorize 100. Prepare roughly 20 well: the basics, the core formulas, lookups, PivotTables and errors. For each one, know the definition, one example and one mistake people make. That depth handles variations you have not seen.
Questions about VLOOKUP, or its replacement XLOOKUP, come up constantly, along with PivotTables and IF statements. Expect to explain them and to write a formula on the spot. Practice both the spoken explanation and the typed version.
Only if the job posting mentions them or the role is heavily reporting-focused. For most roles, a clear explanation of what macros do and when you would choose something simpler is enough. Never claim VBA skills you cannot demonstrate.
Say what you do know, then explain how you would find out. For example: "I haven't used Power Query much, but I would start by importing the file and cleaning the columns step by step." Honest and logical beats bluffing, and bluffing is easy to expose with one follow-up.
Yes. You can work through exercises in a spreadsheet-like environment with feedback, with no sign-up. Our free Excel certification prep and interview test pages are built for this, and you can start today.
Guides people read next.
Learn which Excel skills belong on a resume, how to word them for ATS and recruiters, and how to back them with numbers and real practice before you apply.
15 minFree Excel courses with a certificate compared: what you do to earn each one, what it proves, and when you need a paid Microsoft certification instead.
5 minMaster what excel is used for: syntax, examples, and step-by-step guidance with free interactive practice from LogicExcel.
12 min