If you’re applying for a data analyst, finance, operations, or business role, Excel interviews are still very common in 2026.

You may be tested on:

• Formulas
• Pivot Tables
• Logical thinking
• Data cleaning
• Reporting structure

In this guide, I’ll walk you through 20 Excel interview questions with practical answers so you can prepare confidently.

Basic Excel Interview Questions

1. What is the difference between a Workbook and a Worksheet?

• A Workbook is the entire Excel file.
• A Worksheet is an individual sheet inside the workbook.

Simple but commonly asked.

2. How do you remove duplicates in Excel?

Use:
Data → Remove Duplicates

Or use the UNIQUE() function in modern versions of Microsoft Excel.

3. What is the difference between VLOOKUP and XLOOKUP?

• VLOOKUP searches vertically and requires column index numbers.
• XLOOKUP is more flexible and can search in any direction.

Example:

=XLOOKUP(A2, A:A, B:B)

4. How do you freeze rows or columns?

Go to:
View → Freeze Panes

Useful for large datasets.

5. What is a Pivot Table?

A Pivot Table summarizes large datasets quickly without complex formulas.

It allows grouping, filtering, and aggregation.

Intermediate Excel Interview Questions

6. How do you use INDEX and MATCH together?

=INDEX(B:B, MATCH(A2, A:A, 0))

This is more flexible than VLOOKUP.

7. What is conditional formatting?

It visually highlights data based on rules (e.g., values above average).

Interviewers like this because it improves reporting clarity.

8. How do you calculate a running total?

Option 1:
Use a formula like:

=SUM($B$2:B2)

Option 2:
Use Pivot Table cumulative totals.

9. What is the difference between COUNT, COUNTA, and COUNTIF?

• COUNT → Counts numbers
• COUNTA → Counts non-empty cells
• COUNTIF → Counts based on a condition

10. How do you handle errors like #N/A?

Use:

=IFERROR(A2/B2, 0)

Recruiters expect clean outputs.

Advanced Excel Interview Questions

11. How do you use SUMIFS?

=SUMIFS(B:B, A:A, "East", C:C, "Completed")

Used for multi-condition aggregation.

12. What are absolute vs relative references?

• Relative: A1 (changes when copied)
• Absolute: $A$1 (does not change)

Very common test question.

13. How do you clean messy text data?

Use:

• LEFT
• RIGHT
• MID
• TRIM
• SUBSTITUTE

Example:

=TRIM(A2)

14. How do you create a drop-down list?

Use:
Data → Data Validation → List

Helpful for controlled inputs.

15. What is a calculated field in Pivot Tables?

It allows you to create new metrics inside a Pivot Table without modifying source data.

Scenario-Based Excel Interview Questions

16. How would you analyze monthly sales trends?

• Create a Pivot Table
• Group by Month
• Add line chart for trend visualization

Clear structure is key.

17. How do you find top 5 products by revenue?

• Use Pivot Table
• Sort by revenue descending
• Apply Top 5 filter

18. How do you compare actual vs budget?

• Create variance column:
  =Actual - Budget
• Add % variance
• Use conditional formatting

Recruiters love variance analysis.

19. How do you protect formulas in a worksheet?

• Lock cells
• Protect sheet from Review tab

Shows understanding of reporting control.

20. How would you reduce file size in Excel?

• Remove unused formatting
• Delete unnecessary sheets
• Avoid volatile formulas
• Use structured tables

Practical knowledge impresses interviewers.

What Recruiters Are Really Testing

Excel interviews test:

• Logic
• Business understanding
• Efficiency
• Clarity

It’s not just about formulas. It’s about how you think.

Since codewithfimi.com focuses on data and analytics growth, Excel interview content performs well because it targets high-intent job seekers especially entry-level candidates.

To pass Excel interviews:

• Practice with real datasets
• Understand why formulas work
• Learn Pivot Tables well
• Clean your outputs

Excel remains one of the most demanded foundational skills in data analytics.

Master these 20 Excel interview questions with practical answers, and you’ll walk into your next interview prepared.

FAQs