Top 50+ Excel Interview Questions and Answers

Microsoft Excel is one of the most widely used spreadsheet tools in the world. It was first released in 1985 by Microsoft and created by Doug Klunder. Excel started with simple calculations and later grew into a powerful tool for data analysis. Professionals in every industry use it daily. Accountants use it for reports. Analysts use it for data. Managers and administrators use it to organize and track work. Because it is so important, employers often test Excel skills in job interviews. This blog shares 50+ common Excel interview questions with answers to help you prepare.

Fun Fact: Over 750 million people worldwide use Microsoft Excel.

Understanding the Basics of Excel

Here is a labeled diagram of the Excel interface, showing its main components to help you understand the basics.

Source

Note for Readers:

This guide covers Excel job questions for all levels – basic, intermediate, and advanced. You will also find:

● Questions for freshers

● Technical and scenario-based questions

● Topic-wise interview questions

● Excel questions asked by top IT companies

● Additional viva questions and MCQs

Use this list to prepare with confidence for your next Excel interview.

Basic Excel Interview Questions

Here are some basic interview questions in Excel that test your fundamental knowledge and skills.

1. What does a ribbon in Excel display and how do you toggle it?

The ribbon is the strip at the top of Excel that holds all the tabs, tools, and commands. It includes sections like Home, Insert, Data, and View. To toggle it, I can press Ctrl + F1 or use the small arrow on the right corner of the ribbon.

Source

2. How do you freeze panes, and why would you use this feature?

Freeze Panes are used to lock rows or columns while scrolling. For example, I can keep headers visible while moving down a large dataset. To apply it, I select the row or column and go to View > Freeze Panes.

Source

3. What is a cell address and how is it used in formulas?

A cell address is the unique location of a cell, shown by column letter and row number, such as A1 or B5. In formulas, Excel uses these addresses to calculate results. For example, =A1+B1 adds the values in those two cells.

Source

4. How do you insert a new worksheet using the keyboard?

I can press Shift + F11 to quickly add a new worksheet in the same workbook.

5. Explain the difference between a formula and a function.

6. What is the order of operations in Excel calculations?

Excel follows PEMDAS: Parentheses, Exponents, Multiplication/Division, and then Addition/Subtraction.

So, formulas like =2+3*4 return 14, not 20.

7. How do you merge text from multiple cells into one?

I can use the CONCAT or TEXTJOIN functions. For example, =TEXTJOIN(” “, TRUE, A1:A3) combines text from cells with spaces in between.

Source

8. How do you use conditional formatting to highlight specific values?

Select the range, then go to Home > Conditional Formatting. I can choose rules like “Highlight cells greater than 1000” or create custom formulas. Excel will automatically format only the matching cells.

Source

Intermediate Level Excel Interview Questions

Let’s go through some Excel questions asked in interview to check your skills beyond the basics.

9. How do you use VLOOKUP, and what are its limits?

VLOOKUP searches for a value in the first column of a table and returns data from another column in the same row.

For example, =VLOOKUP(101, A2:D20, 3, FALSE) looks for 101 in column A and returns the third column’s value.

Its main limits are that it can only look to the right, breaks if columns are moved, and can be slower on very large datasets.

Source

10. When would you use INDEX and MATCH instead of VLOOKUP?

INDEX and MATCH are more flexible than VLOOKUP. With them, I can search in any direction, not just to the right. They also handle large datasets faster and don’t break when columns are inserted.

A common example is =INDEX(F2:F6, MATCH(“Beta Limited”, B2:B6, 0)).

Source

11. How do you create a drop-down list using Data Validation?

Select the target cells, go to Data > Data Validation, and choose “List.” Enter the list items separated by commas or reference a range of cells. This is often used to standardize data entry, like limiting entries to department names.

Source

12. What is a Pivot Table and how would you apply it to summarize data?

A Pivot Table is an interactive summary tool. It lets me drag fields into rows, columns, and values to group and calculate data. For instance, I can use it to summarize sales by region, showing totals and averages in seconds.

Source

13. Explain how to use wildcards (*, ?) in filters or lookup formulas.

The asterisk (*) represents any number of characters, and the question mark (?) represents a single character.

For example, =COUNTIF(A2:A20, “Ap*”) counts entries starting with “Ap.”

Filters also support wildcards to quickly locate partial matches.

14. How do you remove duplicates from a dataset?

Highlight the range, go to Data > Remove Duplicates, and select the columns to check. Excel deletes duplicates and keeps the first instance. For a dynamic solution, the UNIQUE function in Excel 365 is better.

Source

15. Describe how Flash Fill works and when it is useful.

Flash Fill recognizes patterns in my typing and fills the rest automatically. If I type “John Doe” as “John” in a new column, Excel suggests the remaining names are split the same way. I confirm by pressing Ctrl + E.

Source

Advanced Excel Interview Questions

These are advanced Excel interview questions and answers that are commonly asked to experienced professionals.

16. What does Power Query do, and how is it used in Excel?

Power Query is Excel’s tool for importing, cleaning, and transforming data. It lets me connect to sources like databases, CSVs, or web pages, then shape the data without altering the original file.

I can merge tables, remove duplicates, split columns, and refresh data with one click. It is useful for recurring reports where the raw data changes often.

Source

17. How do you use XLOOKUP, and why is it preferred over VLOOKUP?

XLOOKUP is a modern lookup function that replaces both VLOOKUP and HLOOKUP. Unlike VLOOKUP, it can search left, right, up, or down.

The formula is simple: =XLOOKUP(lookup_value, lookup_array, return_array).

It is also more stable since column insertions don’t break it. Another advantage is it handles exact and approximate matches better.

Source

18. What is the Solver tool in Excel, and what scenario would you use it for?

Solver is an optimization tool. It finds the best solution by changing variables within constraints. For example, in finance, I can use it to maximize profit while limiting costs. In project planning, it can allocate resources without going over capacity. Solver is found under Data > Analysis > Solver, though it needs to be enabled first.

Source

19. How do you build a dynamic named range using OFFSET?

A dynamic named range grows automatically as new data is added. The OFFSET function is often used:

=OFFSET($A$1,0,0,COUNTA($A:$A),1)

This formula starts at A1 and expands downward depending on the number of filled cells. It is useful for charts and formulas that must adjust to data changes.

20. What does the UNIQUE function do and where would it help?

The UNIQUE function extracts distinct values from a list or range. For example, =UNIQUE(A2:A20) lists all different entries. It is helpful when cleaning survey results, preparing dropdown lists, or analyzing sales by unique products.

Source

21. How does the LET function improve formula readability?

The LET function allows me to assign names to parts of a formula. For instance, instead of repeating (A1+A2) several times, I can define it once inside LET. The formula becomes shorter, easier to read, and faster to calculate.

Source

22. How would you calculate ROI or CAGR using Excel formulas?

ROI is (Net Profit / Cost) * 100.

For example, if profit is 2000 and cost is 5000, ROI is 40%.

CAGR is (Ending Value / Beginning Value)^(1/Years) – 1.

So, growing from 10,000 to 20,000 in 5 years gives about 14.87%.

Note: Excel related interview questions are common in jobs like data analyst, business analyst, accountant, financial analyst, MIS executive, and many administrative roles.

Excel Interview Questions for Freshers

Now, let’s cover some Excel interview questions and answers for freshers.

23. What is Microsoft Excel used for in business environments?

Microsoft Excel is used to organize, analyze, and present data. Businesses rely on it for budgeting, reporting, project tracking, and data analysis. It’s also used for creating dashboards, managing sales records, and preparing financial forecasts.

24. How do you save a file and why would you use Ctrl+S?

I save a file by clicking File > Save or pressing Ctrl+S. Ctrl+S is faster and helps me avoid losing work if something goes wrong. I often press it multiple times while working.

Source

25. How do you wrap text within a cell?

To wrap text, I select the cell, go to the Home tab, and click Wrap Text. This keeps all the content visible within the same cell without spilling over to others.

26. What is the difference between a workbook and a worksheet?

27. How do you sort data in ascending or descending order?

To sort data, I select the range and go to Data > Sort A to Z for ascending or Sort Z to A for descending. Sorting is useful when I want to arrange employee names alphabetically or sales figures from highest to lowest.

Source

28. How do you add comments to a cell?

I right-click the cell and choose New Comment (or Insert Comment) and then type my note. A small red indicator appears in the corner, showing the cell has a comment. Comments are useful for giving context or explanations.

Note: In modern Excel, “Notes” are the old-style comments used for personal annotations, while “Comments” are now threaded discussions for collaboration.

Source

Excel Technical Interview Questions

These MS Excel interview questions will test your practical knowledge and ability to apply Excel in real tasks.

29. How do you write a macro to automate repetitive tasks?

I can record a macro from the Developer tab by choosing Record Macro. After performing the steps, Excel saves them as VBA code. For example, I can automate formatting or data cleaning. I can also write VBA code directly in the editor for more control.

Source

30. What is the difference between ThisWorkbook and ActiveWorkbook in VBA?

ThisWorkbook refers to the workbook that contains the VBA code. ActiveWorkbook is the workbook currently in focus, which could be different if I have multiple workbooks open. Using the wrong one can cause errors.

31. How would you find the last used row or column in VBA?

In VBA, I can use:

LastRow = Cells(Rows.Count, 1).End(xlUp).Row

This finds the last used row in column A. Similarly, for columns:

LastCol = Cells(1, Columns.Count).End(xlToLeft).Column

32. How do you debug VBA code step-by-step?

I press F8 in the VBA editor to run the code line by line. I can also set breakpoints by clicking on the left margin. This helps me check variables and flow as the code executes.

33. How do you pass parameters to a VBA function?

A function in VBA can take arguments inside parentheses.

Example:

Function AddNumbers(x As Integer, y As Integer) As Integer
AddNumbers = x + y
End Function

Calling AddNumbers(5, 10) returns 15. Parameters make functions reusable for different inputs.

Also Read - Top 25+ Excel Interview Questions for Data Analyst

Excel Scenario Based Questions

This section covers practical questions on Excel for interview that focus on workplace scenarios and problem-solving.

34. How would you reconcile two lists to find mismatches?

I would use functions like VLOOKUP, XLOOKUP, or MATCH to compare items between the two lists. Another method is to apply conditional formatting to highlight cells in one list that don’t appear in the other. This makes mismatches easy to spot.

35. If asked to highlight sales above a threshold across a dataset, how would you apply it?

I would select the dataset, go to Home > Conditional Formatting > Highlight Cells Rules > Greater Than, and enter the threshold value.

For example, highlighting sales above 50,000 in red. It’s a quick way to identify top-performing figures.

36. How would you calculate employee turnover rate using Excel?

Turnover rate can be calculated using the formula:

(Number of employees who left ÷ Average number of employees) × 100

If 10 people left out of 200 average staff, the formula returns 5%. I would place the numbers in cells and link them to make it automatic.

37. What steps would you take to clean up messy data?

First, I would use the TRIM function to remove extra spaces. For non-printable characters, the CLEAN function works best. I could also split combined data using Text to Columns or use Find and Replace to remove unwanted characters. Flash Fill is useful when fixing patterns like separating first and last names.

38. How would you build a Gantt-style project timeline in Excel?

I would create a table with tasks, start dates, and durations. Then I’d use a stacked bar chart to display the timeline visually. The first bar segment represents the start date offset, and the second shows task duration. Applying conditional formatting helps highlight overdue tasks.

Source

Additional Excel Interview Questions (Topic-Wise)

Here are topic-wise questions on Excel for interview to help you practice by category and strengthen specific skills.

VLOOKUP Interview Questions

1. Explain how VLOOKUP works with exact and approximate matches.
2. What happens if the lookup value is not in the leftmost column?
3. How do you use IFERROR with VLOOKUP?
4. Can VLOOKUP reference multiple sheets?
5. What are alternatives if VLOOKUP is too slow on large datasets?

Pivot Table Interview Questions

1. How do you group and filter fields in a Pivot Table?
2. How do you create calculated fields within a Pivot Table?
3. What’s the difference between a Pivot Table and a Pivot Chart?
4. How do you show values as a percentage of grand total?
5. How do you use a slicer to filter multiple Pivot Tables?

HLOOKUP Interview Questions

1. How is HLOOKUP different from VLOOKUP?
2. What does the row_index argument do in HLOOKUP?
3. When would you use HLOOKUP vs INDEX-MATCH?
4. Can HLOOKUP return arrays?
5. What pitfalls should you watch when using HLOOKUP on unsorted data?

Excel Sheet Interview Questions

1. How do you protect a worksheet while allowing editing specific cells?
2. How do you rename, add, or delete sheets efficiently?
3. How do you reference a cell from another sheet in a formula?
4. How do you set the print area to a specific range?
5. How do you group multiple worksheets before editing?

Excel VBA Interview Questions

Here are some interview questions for VBA that test your knowledge of macros, automation, and advanced Excel programming.

1. What is VBA and how do you access the VBA Editor?
2. How do you record a macro and link it to a button?
3. How do you write a VBA function that returns a value to a cell?
4. Explain how to pass values by reference vs by value in VBA.
5. How do you check if a file exists using VBA?

Note: VBA macro interview questions are often asked in roles that require automation, reporting, or handling large data sets.

Also Read - Top 35+ Data Analyst Interview Questions and Answers

Excel Interview Questions Asked at Top IT Companies

Now, let’s go through some Excel job questions that top IT companies commonly ask during interviews.

Deloitte Excel Interview Questions

1. How would you create a dynamic, auto-updating chart range?
2. Explain how to model scenarios using What-If Analysis.
3. How do you forecast future values using Excel tools?
4. Describe how to clean and merge data using Power Query.
5. How do you calculate internal rate of return (IRR) or NPV?

Accenture Excel Interview Questions

1. How would you build a dashboard combining charts, slicers, and Pivot Tables?
2. What is the most efficient way to lookup multiple columns?
3. How would you automate monthly report creation with VBA or Power Query?
4. Describe how you would do regression analysis using the ToolPak.
5. How would you present insights to non-technical stakeholders using Excel?

Amazon Excel Interview Questions

1. How would you use Excel to analyze stock levels and reorder points?
2. How do you use conditional formatting to prioritize items based on metrics?
3. How would you simulate demand scenarios with What-If Analysis?
4. Explain how to use INDEX/MATCH when data structure changes.
5. How would you schedule data refresh from external sources?

Genpact Excel Interview Questions

1. How would you merge large datasets using Power Query?
2. Explain how to clean inconsistencies in data (e.g., duplicates, errors).
3. How would you calculate weighted averages using formula logic?
4. How would you generate a summarized report using Pivot and macros?
5. How would you normalize data and identify outliers in Excel?

Excel Viva Questions

Here are some common MS Excel viva questions and answers that help you prepare for oral interview rounds.

1. Explain the difference between relative, absolute, and mixed references.

Relative references like A1 change when copied. Absolute references like $A$1 stay fixed. Mixed references fix either the row ($A1) or the column (A$1).

2. How does COUNTIF differ from SUMIF?

COUNTIF counts cells that meet one condition, such as values greater than 50. SUMIF adds the actual values that meet the condition.

3. What are array formulas and when do you need Ctrl + Shift + Enter?

Array formulas perform multiple calculations in one formula. In older Excel versions, you pressed Ctrl + Shift + Enter to confirm them. In newer Excel, dynamic arrays work without that shortcut.

4. How do you freeze both rows and columns simultaneously?

I select the cell just below the row and to the right of the column I want frozen. Then I click View > Freeze Panes. Both row and column remain fixed while scrolling.

5. What is the purpose of the Name Box?

The Name Box shows the active cell address. I also use it to create or jump to named ranges quickly.

6. How would you lock a cell but still allow formatting?

I right-click the cell, go to Format Cells > Protection, keep it locked, and then protect the sheet. While protecting, I allow formatting permissions for users.

7. Explain how to use the DATE or NETWORKDAYS functions in a formula.

DATE builds a valid date using year, month, and day inputs. NETWORKDAYS calculates working days between two dates, excluding weekends and optional holidays.

Excel MCQs

Here are important excel aptitude questions and answers in MCQ format to test your speed and accuracy.

1. Which function removes non-printable characters from text in Excel?

A. CLEAN
B. TRIM
C. SUBSTITUTE
D. REPLACE

Answer: A. CLEAN

2. Which function in Excel returns the current system date?

A. NOW()
B. DATE()
C. TODAY()
D. TIME()

Answer: C. TODAY()

3. Which lookup method allows an exact, case-sensitive search in Excel?

A. VLOOKUP
B. XLOOKUP
C. INDEX MATCH with EXACT
D. LOOKUP

Answer: C. INDEX MATCH with EXACT

4. What is the keyboard shortcut to insert the current date in Excel?

A. Ctrl + ;
B. Ctrl + Shift + T
C. Alt + D
D. Ctrl + :

Answer: A. Ctrl + ;

5. Which function counts the number of cells that satisfy more than one condition?

A. COUNTIF
B. COUNTIFS
C. SUMIF
D. COUNTA

Answer: B. COUNTIFS

6. What does the shortcut Alt + N + V do in Excel?

A. Open VBA Editor
B. Create a Pivot Table
C. Insert a Chart
D. Open Name Manager

Answer: B. Create a Pivot Table

7. Which function is used to calculate the Internal Rate of Return for cash flows?

A. NPV
B. IRR
C. ROI
D. RATE

Answer: B. IRR

8. Which Excel function extracts unique values from a given range?

A. UNIQUE
B. FILTER
C. SORT
D. REMOVE DUPLICATES

Answer: A. UNIQUE

9. Which function removes extra spaces from text in Excel, leaving only single spaces between words?

A. TRIM
B. CLEAN
C. SUBSTITUTE
D. TEXT

Answer: A. TRIM

10. Which function rounds a number to a specified number of decimal places?

A. ROUNDUP
B. ROUNDDOWN
C. ROUND
D. MROUND

Answer: C. ROUND

How to Prepare for Excel Interview?

Preparing for an Excel interview needs practice with formulas, problem solving, and time management skills. Here are some tips to help you:

● Practice every important Excel formula for interview like VLOOKUP, SUMIF, INDEX MATCH, and text functions

● Solve at least one MS Excel practical question daily to build speed and accuracy

● Take a mock Excel test for interview online to understand the type of questions asked

● Revise shortcuts and data handling methods before your Excel assessment test for interview

● Learn how to create Pivot Tables, charts, and apply conditional formatting for quick analysis

● Stay calm and explain your thought process clearly during the interview

Wrapping Up

So, these are the 50+ commonly asked Excel interview questions and answers to help you prepare. Practicing these will make you more comfortable with both basic and advanced tasks. Keep learning and applying your skills to real problems.

Looking for IT jobs that need Excel skills? Find the best opportunities on Hirist today.

FAQs