Excel Interview Questions for Freshers (With Answers)

Excel interview questions for freshers focus on the basics, but interviewers want precise answers: not "VLOOKUP finds things" but what each part does and why. This guide gives 14 questions that freshers and recent graduates are commonly asked, each with a short answer and a small example. Learn the answers, then type the formulas yourself, because many interviews follow up with a quick hands-on task.

Basic Excel questions (1–4)#

These check that you know how a spreadsheet is organised.

1. What is a cell reference? A cell reference is the address of a cell, written as a column letter and a row number. B3 means column B, row 3. A range like A2:A10 means every cell from A2 to A10.

2. What is the difference between a formula and a function? A formula is anything you type that starts with =, such as =B2*C2. A function is a built-in calculation with a name, such as SUM or AVERAGE. Functions are used inside formulas: =SUM(B2:B10) is a formula that uses the SUM function.

3. What is the difference between COUNT and COUNTA? COUNT counts cells that contain numbers. COUNTA counts cells that are not empty, including text. If A2:A6 holds 10, "Hi", 25, a blank and 7, =COUNT(A2:A6) returns 3 and =COUNTA(A2:A6) returns 4.

4. How do you add up a column quickly? Use =SUM(B2:B10), or select the cell below the numbers and press Alt+= on Windows (Mac: ⌘+Shift+T). AutoSum writes the SUM formula for you.

Cell reference questions (5–6)#

Reference questions separate people who have used Excel from people who have only watched it being used.

5. What is the difference between relative and absolute references? A relative reference like A1 changes when you copy the formula: copied one row down, it becomes A2. An absolute reference like $A$1 stays fixed wherever you copy it. Use absolute references for things that shouldn't move, such as a tax rate in one cell.

6. When would you use $A1 or A$1? These are mixed references. $A1 locks the column but lets the row change; A$1 locks the row but lets the column change. They're used when one formula fills both across and down a table, such as a multiplication grid. Press F4 on Windows (Mac: ⌘T) to cycle through the four types while editing a reference.

IF formula questions (7–9)#

IF is the first logical function most interviewers ask about. The IF function guide covers it in detail.

7. How does the IF function work? IF checks a condition and returns one value if it's true and another if it's false:

=IF(B2>=50,"Pass","Fail")

If B2 holds 72, the result is Pass. If it holds 42, the result is Fail.

8. How do you check two conditions in an IF? Put AND or OR inside it. =IF(AND(B2>=50,C2="Yes"),"Eligible","Not eligible") needs both conditions to be true. With OR, either one is enough.

9. How do you handle more than two outcomes? Nest IFs, or use IFS in Excel 2019 or later: =IFS(B2>=80,"Distinction",B2>=50,"Pass",TRUE,"Fail"). Check the highest band first.

VLOOKUP questions (10–11)#

Lookups are the most common "intermediate" topic in fresher interviews. For more, see the full set of VLOOKUP interview questions.

10. Explain VLOOKUP. VLOOKUP searches the first column of a table for a value and returns a value from another column in the same row. It has four parts:

=VLOOKUP(lookup_value, table, column_number, FALSE)

If A2:C4 holds product codes, names and prices, =VLOOKUP("P2",A2:C4,3,FALSE) returns the price of product P2. FALSE asks for an exact match. See the VLOOKUP function guide.

11. Why does VLOOKUP return #N/A? #N/A means the value wasn't found. Common causes are a typo, extra spaces, a number stored as text, or a value that isn't in the first column of the table. Wrap the formula in IFERROR to show a message instead: =IFERROR(VLOOKUP("P9",A2:C4,3,FALSE),"Not found").

Data tool questions (12–14)#

These check that you can work with lists, not just formulas.

12. What is the difference between sorting and filtering? Sorting changes the order of rows, such as A to Z or largest to smallest. Filtering hides the rows that don't match, so you see only some of them. Neither deletes data.

13. How do you remove duplicates? Select the data, go to Data > Remove Duplicates, and choose the columns to check. It deletes the extra copies, so work on a copy if you need the original. To only highlight duplicates, use Conditional Formatting > Highlight Cells Rules > Duplicate Values.

14. What is a pivot table? A pivot table summarises a table by group without formulas, such as total sales by region. You create one from Insert > PivotTable and drag fields into Rows, Columns and Values.

How freshers should answer Excel questions#

Without work experience, your examples have to come from somewhere else: a college project, an internship, a club budget or your own practice. That's fine. What matters is that the example is real and specific.

1. Define, then show. One sentence on what it does, then a tiny example with real numbers.
2. Be exact. Say "FALSE for an exact match", not "the last bit".
3. Be honest about your level. If you've only used pivot tables a few times, say so, and say you're practising.
4. Expect a test. Many employers add a short practical task. The guide on how to pass an Excel test for a job interview explains what to expect, and the worked Excel test questions and answers show the hands-on version of these topics.

Once you're comfortable here, move on to the wider list of Excel interview questions. Save the advanced Excel interview questions for roles that ask for analysis skills.

Practise it#

Knowing the answer and typing it under pressure are different skills. Practise the IF function in a live spreadsheet and practise VLOOKUP: you type the formula, and it checks it instantly. Then test yourself with the basics skill check, or try the timed Excel screening quiz.