Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Excel tests › Excel interview questions

Excel interview questions and answers

These are the Excel questions recruiters and hiring managers ask most, with short answers you can give in an interview. They go from basic to advanced, plus a few for data analyst roles. Two of them you can practise right here in an Excel window, the way a live interview task works.

In this guide
  1. How Excel is tested
  2. Basic questions
  3. Intermediate questions
  4. Advanced questions
  5. For data analysts
  6. How to answer
  7. Test yourself
  8. FAQ

How Excel comes up in an interview

Excel usually comes up in one of three ways: a few spoken questions ("how does VLOOKUP work?"), a short task during the interview where you share your screen, or an Excel assessment test you take online. The questions below prepare you for all three. Answer briefly, name the function and give a small example.

Basic Excel interview questions

What's the difference between a formula and a function?

A formula is anything you type that starts with =, such as =A1+B1. A function is a built-in formula with a name, such as SUM or VLOOKUP. Functions are used inside formulas.

What's the difference between COUNT, COUNTA and COUNTBLANK?

COUNT counts cells with numbers, COUNTA counts all non-empty cells (text too), and COUNTBLANK counts empty cells.

What's the difference between a relative and an absolute reference?

A relative reference (A1) moves along when you copy a formula. An absolute reference ($A$1) stays fixed. Press F4 while typing to switch. Use it for a rate or a total that every row needs.

How do you remove duplicates from a list?

Select the data and use Data › Remove Duplicates. In Microsoft 365 you can also use =UNIQUE(A2:A100), which keeps the original list intact.

How do you freeze the top row?

View › Freeze Panes › Freeze Top Row. The headers stay visible while you scroll.

How do you calculate a percentage change?

=(new-old)/old, then format the cell as a percentage. From 400 to 500 is =(500-400)/400 = 25%.

Intermediate Excel interview questions

How does VLOOKUP work?

=VLOOKUP(lookup_value, table, col_index, FALSE) finds a value in the first column of a table and returns a value from another column in the same row. FALSE makes it look for an exact match.

What are the limits of VLOOKUP, and what do you use instead?

VLOOKUP only looks to the right, breaks when you insert a column, and needs FALSE for an exact match. XLOOKUP and INDEX MATCH don't have these problems.

What's the difference between SUMIF and SUMIFS?

SUMIF adds up with one condition, SUMIFS with one or more. Watch the order: in SUMIFS the sum range comes first.

How do you handle errors like #N/A in a formula?

Wrap the formula in IFERROR: =IFERROR(VLOOKUP(…),"Not found"). Or use XLOOKUP's own "if not found" argument.

What is a pivot table and when do you use it?

A pivot table summarises a large table in a few clicks: totals per region, counts per month, averages per product. Use it whenever you'd otherwise write many SUMIFS formulas.

How do you combine text from two cells?

With the & sign, =A2&" "&B2, or with CONCAT or TEXTJOIN. TEXTJOIN can add a separator and skip empty cells.

How do you split a full name into first and last name?

Use Data › Text to Columns with a space as the separator, or formulas like TEXTBEFORE(A2," ") and TEXTAFTER(A2," ").

Try it: a lookup like interviewers ask for.

  1. Find the city of customer C-03 with an exact match, in F2

Advanced Excel interview questions

Why use INDEX MATCH instead of VLOOKUP?

INDEX MATCH can look to the left, doesn't break when columns move and is fast on big tables: =INDEX(return_range,MATCH(value,lookup_range,0)).

What are dynamic arrays?

Functions like FILTER, SORT and UNIQUE return several values that spill into the cells below. One formula replaces a whole column of formulas.

What does SUMPRODUCT do?

It multiplies ranges row by row and adds up the results: =SUMPRODUCT(B2:B10,C2:C10) gives the total of quantity × price in one formula.

How do you look up with two conditions?

With XLOOKUP on joined ranges, =XLOOKUP(1,(A2:A99=F1)*(B2:B99=F2),C2:C99), or with INDEX MATCH in the same way.

How do you make a report that updates by itself?

Turn the data into an Excel table (Ctrl+T), base your formulas and pivot tables on that table, and refresh. New rows are picked up automatically.

Try it: a sum with two conditions, a classic in live interview tasks.

  1. Add up the sales of the Web channel in Q1, in F2

Excel interview questions for data analysts

How do you clean a messy dataset?

Remove duplicates, fix spaces with TRIM, convert text-numbers to real numbers, split columns with Text to Columns, and check blanks with a filter. Keep the raw data on a separate sheet.

How do you find outliers quickly?

Sort the column, use conditional formatting (top/bottom 10 or a colour scale), or compare each value with the average and standard deviation.

How to answer Excel questions well

  • Give an example from your work. "I used SUMIFS to report sales per region every month" beats a textbook definition.
  • Name the alternative. Mentioning XLOOKUP when asked about VLOOKUP shows you're up to date.
  • Be honest about your level. Interviewers often follow up with a live task. Say what you can do, and that you know how to look up the rest.
  • Practise out loud. Explaining a formula is harder than typing it.

Test yourself before the interview

Knowing the answers is one thing; typing the formula under pressure is another. Take the Excel level test to see where you stand, then the basic, intermediate or advanced Excel test for your role.

Frequently asked questions

What Excel questions are asked in an interview?

Most interviews ask about lookups (VLOOKUP, XLOOKUP, INDEX MATCH), conditional sums and counts (SUMIFS, COUNTIFS), IF, pivot tables, absolute references and handling errors. Analyst roles add data cleaning and dynamic arrays.

How do I prepare for an Excel interview?

Go through the questions on this page, practise the formulas in an Excel window and take a practice test under time pressure. Prepare one example from your own work for each main function.

What are basic Excel interview questions?

Questions about formulas versus functions, COUNT versus COUNTA, relative and absolute references, percentages, sorting and filtering, and removing duplicates.

What are advanced Excel interview questions?

Questions about INDEX MATCH, lookups with two conditions, dynamic arrays like FILTER and UNIQUE, SUMPRODUCT and building reports that update themselves.

Will I get a live Excel test in the interview?

Often, yes, especially for admin, finance and analyst roles. It's usually a short task in a shared spreadsheet or an online assessment with real tasks.