🥳 Flat 40% OFF on All Masterclasses TB40
```html
excel interview questions and answers

Excel Interview Questions and Answers (Beginner to Advanced)

By Thinking Bridge Team | Published on: Thu Jan 15, 2026

If you’re preparing for interviews, there’s a high chance of Excel interview questions and answers. Whether you’re applying for finance, HR, operations, marketing, or analyst roles, Excel is expected. Recruiters don’t care if you “know the basics.” They want proof that you can handle data confidently.

This guide breaks down the most important Excel interview questions from beginner to advanced level with practical clarity.

Why Excel Is So Important in Interviews?

Excel is not just a spreadsheet tool. It is a problem-solving tool. Companies use it for reporting, budgeting, performance tracking, data cleaning, and decision-making.

When interviewers ask Excel interview questions, they’re testing whether you:

  • Can you organize messy data?
  • Can you use formulas correctly?
  • Can you explain your logic clearly?
  • Can you summarize data for decision-making?

Now let’s move level by level.

Beginner Level Excel Interview Questions

At the beginner level, interviewers test fundamentals. These MS Excel interview questions focus on whether you understand how Excel works and how to build strong basics.

1. What is Microsoft Excel?

Microsoft Excel is a spreadsheet software used to store, organize, and analyze data in rows and columns. Companies use it for tracking sales, expenses, employee data, and reports.

2. What is a cell and a range?

A cell is a single box like A1. A range is a group of cells like A1:A10.
Ranges are used when applying formulas to multiple cells.

3. What is the main difference between a worksheet and a workbook?

A workbook is the entire Excel file. A worksheet is one sheet inside the file. Think of it like a notebook (workbook) and its pages (worksheets).

4. What are basic Excel functions?

Basic functions are pre-built formulas used daily. Common ones include:

  • SUM() – Adds numbers in a range.
  • AVERAGE() – Calculates the average value.
  • COUNT() – Counts numeric cells only.
  • MAX() and MIN() – Finds highest or lowest value.

These are very common Excel questions for interview rounds.

5. What is sorting and filtering?

Sorting arranges data in ascending or descending order.
Filtering shows only specific data based on conditions (e.g., only Sales department employees).

6. What is the difference between a relative and an absolute reference?

Relative references (A1) change when copied.
Absolute references ($A$1) stay fixed.

7. What is the Formula Bar in Excel?

The Formula Bar displays the content or formula entered in the selected cell. You can use it to view, enter or edit data and formulas without editing directly inside the cell.

For example, if cell C2 contains =SUM(A2:B2), the Formula Bar displays this formula when you select C2.

8. What is the difference between COUNT, COUNTA, and COUNTBLANK?

These functions count cells in different ways:

  • COUNT: Counts cells containing numbers.
  • COUNTA: Counts non-empty cells, including text and numbers.
  • COUNTBLANK: Counts empty cells in a selected range.

For example, if you want to count how many employees have entered their employee IDs, you can use COUNTA.

9. What is Freeze Panes in Excel?

Freeze Panes keeps selected rows or columns visible while you scroll through a worksheet.

For example, if you have a sales report with hundreds of rows, you can freeze the top row to keep the column headings visible while reviewing the data.

10. What is the difference between Save and Save As in Excel?

Save updates the existing workbook with your latest changes. Save As allows you to save a workbook with a different name, location, or file format.

For example, you can use Save As to create a separate copy of a monthly sales report before making changes.

This is one of the most common interview questions on Excel for freshers.

Also read- 5 Best Tools & Software for Internal Audit in 2026

Intermediate Level MS Excel Interview Questions and Answers

At the intermediate level, recruiters expect you to work with real business data. These MS Excel interview questions and answers test logical thinking and data handling.

You should explain not just “what” a function does, but “why” it’s used.

1. What is VLOOKUP?

VLOOKUP searches for a value in a table and returns related data for that value.

Example: Fetching employee salary using employee ID.
It is widely used in reporting roles.

2. What is the IF function?

The IF function performs logical testing.

Example:
If marks are above 50, show “Pass,” otherwise “Fail.”
It helps automate decisions inside spreadsheets.

3. What is a Pivot Table?

A Pivot Table summarizes large data sets quickly.

Example: Instead of manually calculating total sales by region, a Pivot Table does it in seconds.
Pivot tables are frequently asked in Excel interview questions and answers for analyst jobs.

4. What is Conditional Formatting?

Conditional formatting automatically highlights data based on rules.

Example: Highlighting negative profits in red makes patterns easy to spot.

5. What is Data Validation?

Data validation restricts user input.

For example, creating a dropdown list for department names to avoid typing errors.

6. What is XLOOKUP?

XLOOKUP searches for a value in one range and returns the corresponding result from another range. Unlike VLOOKUP, it can search in any direction and does not require a column index number.

It also allows you to specify what should be displayed when a match is not found.

Example:

=XLOOKUP(E2,A2:A100,C2:C100,"Not Found")

7. What is the SUMIF function in Excel?

SUMIF adds values that meet a specific condition.

For example, if column A contains region names and column B contains sales figures, you can calculate sales for the North region using:

=SUMIF(A2:A100,"North",B2:B100)

This is useful when preparing department-wise, region-wise or category-wise reports.

8. What is the difference between SUMIF and SUMIFS?

Both functions add values based on conditions, but they differ in how many conditions they can handle.

  • SUMIF: Adds values based on one condition.
  • SUMIFS: Adds values based on multiple conditions.

For example, to calculate sales for the North region for the Electronics category:

=SUMIFS(C2:C100,A2:A100,"North",B2:B100,"Electronics")

This is particularly useful when analysing large business datasets.

9. What is the COUNTIF function?

COUNTIF counts the number of cells that meet a particular condition.

For example, if column A contains employee status, you can count how many employees are marked as Completed using:

=COUNTIF(A2:A100,"Completed")

It is commonly used in attendance reports, employee tracking and performance analysis.

10. What is the IFERROR function in Excel?

IFERROR returns a specified result when a formula produces an error. If there is no error, it returns the original formula's result.

For example:

=IFERROR(A2/B2,"Check Data")

If B2 contains zero or another value that causes a calculation error, Excel displays "Check Data" instead of an error message.

11. What are LEFT, RIGHT, and MID functions in Excel?

These are text functions used to extract specific characters from a cell.

  • LEFT: Extracts characters from the beginning of text.
  • RIGHT: Extracts characters from the end of text.
  • MID: Extracts characters from a specified position.

For example, =LEFT(A2,3) extracts the first three characters from cell A2.

These functions are useful when cleaning employee records, product codes, and customer information.

12. How do you remove duplicate values in Excel?

Excel provides a Remove Duplicates feature under the Data tab.

To remove duplicates:

  1. Select the dataset.
  2. Go to the Data tab.
  3. Click Remove Duplicates.
  4. Select the columns you want Excel to check.
  5. Click OK.

Excel removes duplicate records based on the selected columns. It is a useful feature when cleaning customer lists, transaction records, and employee databases.

These are common Excel questions for interviews in mid-level roles.

Advanced Excel Interview Questions

Advanced rounds test analytical ability. These advanced Excel interview questions are common in finance, MIS, and analytics profiles.

Here, interviewers check whether you can solve business problems using Excel.

1. What is INDEX and MATCH?

MATCH finds the position of a value.
INDEX returns the value from that position.

Together, they are more powerful than VLOOKUP because they work in any direction.

2. What are Macros?

Macros automate repetitive tasks using VBA.

Example: Automatically formatting monthly reports instead of doing it manually every time.

3. What is Power Query?

Power Query is used for cleaning and transforming large datasets from different sources before analysis.

4. What is Goal Seek?

Goal Seek finds the required input to achieve a desired output.

Example: Calculating required sales to achieve a target profit.

5. What are common Excel errors?

Here are some common Excel errors

1. #DIV/0! – Dividing by zero

This error appears when a formula tries to divide a number by an empty cell or by zero.

How to fix it:

  • Make sure the denominator cell is not zero.
  • Check if the referenced cell is blank.
  • Use IFERROR() to handle it safely.
    Example:
    =IFERROR(A1/B1, "Enter valid number")
  • You can also use an IF condition:
    =IF(B1=0, "", A1/B1)

This shows the interviewer that you not only understand the error but also know how to prevent it.

2. #N/A – Value not found

This usually happens in lookup functions like VLOOKUP, HLOOKUP, or XLOOKUP when the value is not available in the selected range.

How to fix it:

  • Check if the lookup value already exists in the table.
  • Make sure there are no extra spaces in the data.
  • Ensure the correct range is selected.
  • Use IFERROR() or IFNA() to handle missing values.

Example:
=IFNA(VLOOKUP(A2, Sheet2!A:B, 2, FALSE), "Not Found")

Interviewers often test this in advanced interview questions on Excel because lookup errors arecommon in real work.

3. #VALUE! – Incorrect data type

This error appears when Excel expects a number but gets text, or when incompatible data types are used in a formula.

How to fix it:

  • Check if numbers are stored as text (you may see a green triangle).
  • Remove unwanted spaces using TRIM().
  • Convert text to numbers using the VALUE() function.
  • Double-check formula references to ensure correct cell types.

Example:
If A1 contains text instead of a number, use:
=VALUE(A1)

6. What is the difference between VLOOKUP and INDEX-MATCH?

VLOOKUP searches for a value in the first column of a selected table and returns a value from a specified column to its right.

INDEX-MATCH combines two functions. MATCH finds the position of a value, while INDEX returns the corresponding value from a selected range.

Unlike traditional VLOOKUP, INDEX-MATCH can retrieve values from columns on either side of the lookup column.

Example:

=INDEX(C2:C100,MATCH(E2,A2:A100,0))

This formula finds the value in E2 within column A and returns the corresponding value from column C.

7. What is the difference between Power Query and Pivot Tables?

Power Query and Pivot Tables serve different purposes in Excel.

  • Power Query: Used to import, clean, combine, and transform data before analysis.
  • Pivot Tables: Used to summarise and analyse data based on different categories.

For example, Power Query can combine monthly sales files and remove unwanted rows. A Pivot Table can then summarise the cleaned data by region or product.

8. What are dynamic array functions in Excel?

Dynamic array functions return multiple results that automatically spill into neighbouring cells.

Some commonly used functions include:

  • FILTER: Returns records that meet specific conditions.
  • SORT: Sorts a selected range.
  • UNIQUE: Returns distinct values from a dataset.

For example:

=UNIQUE(A2:A100)

This formula returns a list of unique values from the selected range.

These functions are available in supported modern versions of Excel, including Microsoft 365 and Excel 2021 or later.

9. What is Power Pivot in Excel?

Power Pivot is an Excel feature used to work with large datasets and create relationships between different tables.

It allows users to build a Data Model, create calculated columns and measures using DAX, and analyse data from multiple sources.

It is particularly useful for financial reporting, business intelligence and advanced data analysis.

How to Prepare for Excel Interview Questions?

Preparing for Excel interview questions and answers is about practice, not memorization.

Here’s what actually works:

  • Practice real datasets like sales or expense sheets.
  • Master SUM, IF, VLOOKUP, and Pivot Tables first.
  • Learn shortcuts to improve speed.
  • Build at least one small dashboard.
  • Practice explaining formulas out loud.

In interviews, clarity matters more than complexity. Always explain:

  1. What does the function do?
  2. When would you use it?
  3. A simple real example.

That structure alone makes your answers stronger.

Also read- Top Deloitte Interview Questions for Freshers & CAs (2026 Guide)

FAQs

1. What are the most asked Excel interview questions?

The most common Excel interview questions include SUM, IF, VLOOKUP, Pivot Tables, sorting, filtering, and conditional formatting.

2. How to prepare for MS Excel interview questions and answers?

Start with the basics, practice regularly, and apply formulas to real business scenarios. Understanding practical usage is more important than memorizing MS Excel interview questions and answers.

3. What are the advanced Excel interview questions asked in jobs?

Advanced roles focus on INDEX-MATCH, Macros, Power Query, dashboards, and data modeling. These are typical advanced Excel interview questions in finance and analytics jobs.

Conclusion

Strong knowledge of Excel interview questions with answers can immediately set you apart from other candidates. Excel is not just about formulas; it’s about solving problems efficiently.

From beginner basics to advanced analytics, every concept builds your confidence. If you practice consistently and understand practical applications, you’ll handle any MS Excel interview rounds smoothly.

In today’s job market, Excel is not optional. It’s expected.

About Author

Author Image

CA Archit Agarwal

A former Deloitte professional with 10+ years of experience, founder Thinking Bridge and who has trained over 60,000+ learners in finance domains like Statutory Audit.

whatsapp icon call icon