Top 10 Excel Interview Questions for Freshers (2026)

How Excel is Tested in Interviews

Excel interviews for freshers typically have two components: a verbal round and a practical test.

Verbal round: The interviewer asks you to explain concepts, give examples, and describe how you have used Excel. Questions like "What is VLOOKUP?", "When would you use a PivotTable?", "What does #N/A mean?" are verbal questions. They test whether you understand the tool conceptually.

Practical test: You are given a dataset and a brief (e.g., "find total sales by region and identify the top 5 products"). You have 15–30 minutes. The test measures speed, accuracy, and professional habits (locking references with $, using IFERROR, naming sheets clearly).

Prepare for both. Knowing the answers verbally but being slow in the practical test is a common reason freshers fail. Practise the practical test until you can complete a VLOOKUP + SUMIFS + PivotTable task in under 15 minutes.

Q1: Explain VLOOKUP with an Example

TESTED Asked in 78% of data role fresher interviews.

What is tested

Whether you can explain the concept clearly AND whether you know the 4 arguments AND whether you know the common pitfalls (approximate vs exact match, left-side limitation).

Sample answer

"VLOOKUP stands for Vertical Lookup. It searches for a value in the first column of a table and returns a value from a specified column in the same row. It has four arguments: the lookup value, the table range, the column number to return, and whether to use exact or approximate match.

For example: if I have a product code in cell A2 and a reference table of products in columns D through G, I would write: =VLOOKUP(A2,$D$2:$G$100,2,FALSE). This returns the value from the second column of the table (the product name) where the product code matches A2. The FALSE at the end ensures an exact match — which is almost always what you want."

Practical example (say this too)

"I used VLOOKUP in a project where I had a list of 500 customer orders and a separate customer master file. I used VLOOKUP to pull the customer name, region and account manager from the master file into the orders sheet — so I could analyse orders by region without manually copying data."

Follow-up question

"What is the limitation of VLOOKUP?" — Answer: it can only look to the right (the lookup column must be leftmost), column numbers break when columns are inserted, and it needs IFERROR for error handling. XLOOKUP solves all three.

Weak answer to avoid

"VLOOKUP looks up a value." — This shows you know the name but not the mechanics. Always explain all 4 arguments and give a concrete example.

Q2: What is a PivotTable and When Would You Use It?

TESTED Asked in 71% of data role fresher interviews. Often followed by a practical test.

What is tested

Conceptual understanding AND ability to create one quickly in a practical test. Being able to explain but taking 5 minutes to create a PivotTable is a red flag.

Sample answer

"A PivotTable is a tool that summarises large datasets into a cross-tabulation table without writing formulas. You drag fields into rows, columns, values and filters areas and Excel aggregates the data automatically.

I would use a PivotTable when I need to quickly answer a question like 'what are total sales by region and product category?' from a dataset with thousands of rows. A PivotTable answers that in 60 seconds. Writing SUMIFS formulas for the same analysis would take 30 minutes."

Practical example

"In my project, I had 2,000 rows of sales transactions. I created a PivotTable showing revenue by salesperson for each month, then added a slicer to filter by region. The sales manager used it to identify that two salespeople in the East region had unusually low Q2 numbers — which turned out to be a system entry error, not actual low performance."

Follow-up question

"What is a PivotChart?" — A PivotChart is a chart connected to a PivotTable that updates automatically when the PivotTable changes. It responds to slicers, making it the right choice for interactive dashboards.

Q3: What is the Difference Between SUMIF and SUMIFS?

TESTED Asked in 65% of data role fresher interviews.

Sample answer

"SUMIF sums values based on a single condition. SUMIFS sums values based on multiple conditions. The key syntax difference is that SUMIFS puts the sum range first, while SUMIF puts it last.

Example with SUMIF: =SUMIF(B2:B100,"North",C2:C100) — sum of column C where column B equals 'North'.

Example with SUMIFS: =SUMIFS(C2:C100,B2:B100,"North",D2:D100,"Q3") — sum of column C where column B equals 'North' AND column D equals 'Q3'.

In practice, I always use SUMIFS even for single conditions — it handles everything SUMIF does and I only need to remember one syntax."

Q4: What Are the Common Excel Errors and What Do They Mean?

TESTED Classic verbal question. Shows whether you have worked with real data.

Sample answer

"The most common Excel errors are:

• #N/A — value not found. Most common in VLOOKUP or XLOOKUP when the lookup value does not exist in the table, or when there are extra spaces causing a mismatch.
• #VALUE! — wrong data type. Happens when a formula expects a number but receives text, for example trying to add a cell that contains 'N/A' as text.
• #REF! — a referenced cell or range was deleted, so the formula now points to nothing.
• #DIV/0! — division by zero or by an empty cell. Wrap in IFERROR to display 0 or 'N/A' instead.
• #NAME? — misspelled function name, for example typing VLOOKUP but writing VLOOKPU.

I handle errors proactively by wrapping lookup formulas in IFERROR and checking data types before writing formulas."

Q5: What is the Difference Between Absolute and Relative Cell References?

TESTED Fundamental concept — tested in almost every interview.

Sample answer

"A relative reference like A2 shifts when you copy the formula to another cell. If I write =A2*B2 in cell C2 and copy it to C3, it becomes =A3*B3 automatically — the references shift by one row.

An absolute reference like $A$2 does not shift. If I write =A2*$B$1 and copy it down, the A2 shifts to A3, A4, etc. — but $B$1 always stays as B1. This is essential when multiplying a column of values by a single fixed rate in one cell.

I toggle between relative and absolute using the F4 key — pressing F4 cycles through $A$2 (fully absolute), A$2 (row locked), $A2 (column locked), and A2 (fully relative)."

Q6: How Do You Clean Data in Excel?

TESTED Increasingly important — tests practical experience with real data.

Sample answer

"My standard data cleaning process starts with a backup of the raw data. Then I: (1) remove duplicates using Data → Remove Duplicates, (2) fix blank cells using Ctrl+G → Special → Blanks, (3) remove extra spaces with TRIM and CLEAN functions, (4) standardise capitalisation with PROPER or UPPER, (5) fix numbers stored as text using VALUE(), (6) fix dates stored as text using DATEVALUE() or Text to Columns, (7) standardise inconsistent category values using Find and Replace or a mapping table with XLOOKUP, and (8) add data validation to prevent future errors.

For recurring reports where the same data structure arrives monthly, I use Power Query — it records every step and replays it automatically when new data arrives."

Q7: What is Conditional Formatting and How Do You Use It?

TESTED Common in operations, finance and HR role interviews.

Sample answer

"Conditional formatting automatically changes the visual appearance of cells based on their value. You can apply colour scales (green for high, red for low), data bars (in-cell mini bar charts), icon sets (arrows, traffic lights), or custom highlight rules (all cells below target turn red).

I use it to make data tables scannable — a manager can identify all below-target regions at a glance without reading every number. I also use it to flag data quality issues: if a cell in the Amount column is negative (which it should not be), conditional formatting highlights it in orange automatically."

Q8: What is the Difference Between a Measure and a Calculated Column?

TESTED Asked for data analyst and Power BI roles specifically.

Sample answer

"This distinction applies to Power BI and Excel Power Pivot, where both are DAX calculations.

A calculated column is computed row by row when the data model refreshes. It is stored in the table, uses row context, and its value does not change based on what filters or slicers are applied. Use it for categorising rows — for example, creating a 'Price Band' column (Low/Medium/High) based on unit price.

A measure is computed on demand when a visual renders. It uses filter context and responds dynamically to slicers and filters. Use it for aggregations that need to change based on user selections — for example, Total Revenue, Profit Margin, Year-on-Year Growth."

Q9: How Would You Find the Top 5 Values in a Dataset?

TESTED Tests knowledge of statistical functions.

Sample answer

"Several approaches depending on the requirement:

• LARGE function: =LARGE(C2:C100,1) returns the highest value, =LARGE(C2:C100,2) the second highest, and so on. Fast for reading top values.
• PivotTable with value filter: Create a PivotTable, then right-click the values field → Value Filters → Top 10 → change to Top 5. This shows the top 5 rows by any measure you choose.
• Sort and filter: Sort the column descending, select the first 5 rows. Simple but not dynamic.
• FILTER + LARGE (dynamic array): =FILTER(A2:C100, RANK(C2:C100, C2:C100, 0) <= 5) — returns the top 5 rows dynamically in Microsoft 365."

Q10: How Do You Link Data Across Multiple Sheets?

TESTED Tests understanding of workbook structure.

Sample answer

"To reference a cell on another sheet, use the syntax: SheetName!CellReference. For example, to sum cell B5 from the January sheet: =January!B5. For a range on another sheet: =SUM(January!B2:B100).

To reference cells across multiple sheets in one formula, use a 3D reference: =SUM(January:March!B5) — this sums cell B5 from every sheet between January and March, which is efficient for monthly report aggregation.

I also use INDIRECT for dynamic sheet references — the sheet name comes from a dropdown cell, and the formula automatically pulls data from whichever sheet the user selects."

5-Minute Mock Test

3 Questions to Ask the Interviewer

Asking good questions at the end of an Excel interview shows that you are thinking about the role professionally, not just trying to pass a test.

1. "What does a typical Excel workbook look like in this role — single sheets or multi-sheet workbooks connected to external data sources?" — This shows you know that Excel complexity varies greatly and you are asking about the real work environment.
2. "Does the team use Power Query or Power Pivot, or primarily formula-based approaches?" — This signals awareness of modern Excel capabilities and helps you understand the tool maturity of the team.
3. "What is the biggest data challenge the team faces with Excel right now?" — Opens a genuine conversation and shows you are thinking about solving real problems, not just answering interview questions.

Portfolio Project Framework

Adding an Excel project to your resume is more powerful than listing Excel as a skill. Here is the framework for describing it:

Interview Preparation Checklist

Frequently Asked Questions