MS Excel Interview Questions And Answers [2026]

Summary: Preparing for an Excel interview? Study basic spreadsheet concepts to advanced functions, VBA, macros, and data analysis. Most importantly, read the job description, analyze the roles and responsibilities of the job opening you want to apply for, and prepare effectively for the interview.

MS Excel allows users to perform calculations and present data systematically. It is a powerful tool used by over 750 million users to analyze, format, organize, and manipulate data. Almost every field utilizes this software for one purpose or another. Thus, every candidate must be well-versed in the ins and outs of the tools available in MS Excel.

You must prepare thoroughly for Excel interview questions to succeed in any job interview. Strong knowledge of these questions can demonstrate your Excel proficiency and potentially improve your job prospects. In this blog, we will cover the most commonly asked MS Excel interview questions and answers. 

Why is Excel Used Extensively?

Excel is widely used across industries to organize data, perform calculations, create reports, and track information. If you understand these uses, you can move on to the Excel interview questions that test your basic knowledge. Here are several reasons why Excel is used extensively:

• Data Management: Excel helps users store, organize, sort, and filter large amounts of information.
• Calculations: Users can perform simple calculations or use formulas and functions for more complex tasks.
• Data Analysis: Features such as PivotTables, charts, and conditional formatting make it easier to analyze and understand data.
• Reporting: Excel can help create reports, budgets, schedules, financial statements, and other business documents.
• Accessibility: Excel is widely available and familiar to many professionals, making it easy for teams to work with and share spreadsheets.

Excel Interview Questions for Freshers

Freshers may face Excel questions that focus mainly on basic concepts and practical tasks. Interviewers often use these questions to understand whether you can work with spreadsheets and handle common workplace data. Here are some Excel questions asked in an interview:

Q1. Explain the difference between COUNT, COUNTA, and COUNTBLANK.

COUNT, COUNTA, and COUNTBLANK are Excel functions used to count different types of data in a selected range:

• COUNT: Counts cells that contain numbers.
• COUNTA: Counts cells that contain any data, including text, numbers, and errors.
• COUNTBLANK: Counts empty cells.

Q2. Explain the shortcut that is used to add a filter to a table.

The shortcut to add or remove filters in Excel is Ctrl + Shift + L. This shortcut applies filters to the selected data range.

Q3. How do you create a hyperlink in Excel?

Select the cell where you want to add the hyperlink and press Ctrl + K. Enter the web address or select the file or location you want to link to, then click OK.

Q4. How can you merge multiple cells’ text strings in a cell?

You can combine text from multiple cells using functions such as CONCAT, CONCATENATE, or TEXTJOIN. For example, =CONCAT(A1,” “,B1) combines the text in A1 and B1 with a space between them.

Q5. Name the report formats available in Excel.

Excel provides three PivotTable report layouts: Compact Form, Outline Form, and Tabular Form. These layouts control how information is displayed in a PivotTable.

Q6. How would you create a drop-down list in Excel?

You can create a drop-down list in Excel using Data Validation:

• Select the cell or cells where you want the drop-down list.
• Go to Data > Data Validation.
• Select List under Allow.
• Enter the options or select the cells containing them.
• Click OK to create the drop-down list.

Q7. How would you apply advanced filters in Excel?

Select your data and go to Data > Advanced in the Sort & Filter group. Choose the list range and specify a criteria range to filter the data based on specific conditions.

Q8. How can you use the SUMIF() function in Excel?

The SUMIF() function adds numbers in a range based on a specific condition. For example, you can use it to calculate the total sales for a particular product.

Syntax: =SUMIF(range, criteria, sum_range)

Q9. How would you find duplicate values in a column?

You can find duplicate values using Conditional Formatting in Excel.

• Select the column you want to check.
• Go to Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.
• Choose a formatting option and click OK.

Excel highlights values that appear more than once.

Q10. How can you remove duplicate values in a range of cells?

You can use the Remove Duplicates feature to delete repeated values.

• Select the range of cells.
• Go to Data > Remove Duplicates.
• Select the columns you want Excel to check.
• Click OK.

Excel removes duplicate entries while keeping the first occurrence.

Q11. What is the Excel shortcut for spell check?

The shortcut for spell check in Excel is F7. Pressing F7 opens the spell checker, which lets you review and correct spelling errors in your worksheet.

Q12. How to cancel an entry using a shortcut in Excel?

Press the Esc key to cancel an entry before you confirm it. This removes the current entry and returns the cell to its previous state.

Q13. Explain the new enhancement in Excel.

Excel receives regular enhancements that improve data analysis, collaboration, formulas, charts, and AI-powered features. Recent versions also include features such as dynamic arrays, improved data tools, and Copilot integration.

Q14. What is the shortcut key to minimize the workbook in Excel?

You can press Ctrl + F9 to minimize the active workbook window. The workbook remains open but is minimized.

Basic Excel Interview Questions and Answers

Basic Excel interview questions help employers check whether you understand Excel’s core features. These questions usually cover worksheets, cells, formulas, functions, formatting, and simple data management tasks. Here are some basic interview questions in Excel that you may be asked.

Q15. Define Spreadsheets

A spreadsheet is a grid of cells organized in rows and columns that contains data, functions, and formulas. Excel uses a spreadsheet format to store, analyze, and manipulate data.

Q16. Define a cell in Excel

A cell is the intersection of a row and a column in the spreadsheet. It is a basic unit of a spreadsheet where data, functions, and formulas are stored.

Q17. Define a formula in Excel

A formula is an equation that performs calculations and starts with an (=) sign. It starts with the (=)sign and is followed by mathematical operations.

Q18. Explain the method to insert a row or column in Excel

To insert a row or a column, right-click on the row or column where you want to insert a new one, then select ‘Insert’. This will give you a new row or column depending on the requirement.

Q19. How do you format cells in Excel?

The user must select the cell they want to format, then select ‘Format Cells’ to change formatting options like font, color, or number.

Q20. What is a function in Excel?

A predefined formula that specifically performs calculations and manipulation of data is known as a function in Excel. It starts with a function name, followed by arguments enclosed in parentheses.

Q21. Define a pivot table in Excel

A pivot table is a powerful tool for analyzing and summarizing data in a spreadsheet. A pivot table also allows a user to group and aggregate data in different ways.

Q22. Explain the steps to freeze columns and rows in Excel

The Freeze Panes feature keeps selected rows or columns visible while scrolling through a worksheet. To freeze rows or columns:

• Select the cell below the row or to the right of the column you want to freeze.
• Go to the View tab.
• Click Freeze Panes.
• Select Freeze Panes from the drop-down.

For example, to keep the first row visible, select the cell A2 and choose View > Freeze Panes > Freeze Panes. You can also use Freeze Top Row or Freeze First Column directly from the Freeze Panes menu.

Q23. How to sort data in Excel?

Excel lets you sort data by values in one or more columns. To sort data:

• Select the data range or click any cell within the dataset.
• Go to the Data tab.
• Click Sort.
• Select the column you want to sort by.
• Choose the sorting order, such as A to Z, Z to A, Smallest to Largest, or Largest to Smallest.
• Click OK.

For example, if you have a sales dataset, you can sort the Sales Amount column from largest to smallest to identify the highest sales values.

Q24. Explain how to create a chart in Excel?

To create a chart in Excel, select the data you want to visualize and choose a suitable chart type.

• Select the data range, including the relevant headings.
• Go to the Insert tab.
• Choose a chart type, such as Column, Bar, Line, or Pie.
• Excel will insert the chart based on the selected data.
• Use the Chart Design and Format options to change the chart title, labels, layout, or other elements.

For example, use a column chart to compare sales across different months, while a line chart can show how sales change over time.

Q25. What is the difference between Relative cell referencing and Absolute cell referencing?

Relative Cell Referencing	Absolute Cell Referencing
There is a change when copying a formula from one cell to another in Relative Cell Referencing.	There is no change when copying a formula from one cell to another in Absolute Cell Referencing.
Relative Cell Referencing is built by default.	Absolute Cell Referencing is not built by default.
This does not require a dollar sign in the formula when a change is made in it.	This requires a dollar sign in the formula when a change is made in it.

Q26. List the order of operations that are used to evaluate formulas in Excel

The order that is used in Excel while evaluating formulas is known as PEDMAS. Here is the meaning of the order:

• Parentheses
• Exponentiation
• Division/Multiplication
• Addition
• Subtraction

Pro Tip: You can take a professional Excel course for a better and more in-depth understanding of Excel and its functions.

Intermediate MS Excel Interview Questions and Answers

Intermediate Excel questions test how well you can use Excel beyond basic calculations and formatting. You may face questions about functions, data analysis, sorting, filtering, and other features used in everyday work. Here are some MS Excel interview questions that can help you prepare for this level.

Q27. What is the difference between LOOKUP and VLOOKUP?

LOOKUP	VLOOKUP
This function enables the user to look for data in a row or column.	This function enables the user to look for data in the leftmost column of the table.
LOOKUP returns the value in another row or column.	VLOOKUP returns the value in the left to right.
It is easier to use.	It is not as easy to use as LOOKUP.

Q28. What is the difference between a Formula and a Function in Excel?

Formula	Function
An equation in Excel is known as a Formula.	The predefined calculations in Excel are known as Functions.
The calculation type depends on the user.	The calculation is built-in.
It needs to be typed manually.	It is built-in in Excel.
It consumes more time.	Calculations can be done faster.

Q29. Explain Data Validation

The work of Data Validation in Excel is to restrict the type of values that a user can enter into a particular cell or a range of cells. The user should select the “Data Validation” option in Data Tools, then they should select the kind of data validation they want to apply. 

Q30. Explain how are nested IF statements used in Excel

Nested IF statements are used in Excel when the user has multiple conditions to meet, the FALSE value in the IF function can be replaced with another IF function if any further test is required.

Q31. Explain how Slicer works in Excel

A slicer is used in Excel when the data needs to be filtered in pivot tables. Here are the ways to use Slicer:

• Click on the Insert tab and select the Slicer option which is present under Filter.
• After that, the user should select the list of fields for which they want to create Slicers.

Q32. Can users create a Pivot table using multiple sources?

Yes, it is possible to create a pivot table using multiple sources or worksheets but there must be a common row in the tables, which will act as the Primary key for the first table and the Foreign key for the second one. By creating a relationship between these tables, a user can then build a pivot table.

Q33. Explain the conditioning formula in Excel and how it is used

A tool in Excel that allows the user to apply formatting to cells based on certain criteria is known as the conditioning formula. To use it, the user must select the cells that they want to apply it to, and after that, they must choose the formatting options that they want to apply.

Q34. Explain macros in Excel

A program that resides within Excel and automates the repetitive tasks that the user wants Excel to perform is known as a Macro. It is used by recording the task, and to record the macro the user must go to the Developer tab and then click on Record Macro or they can access it from the View tab. Once it is recorded, the Macro is set to perform its functions.

Q35. How do you create a column in a pivot table?

The user has to go to the PivotTable Analyze and then select the ‘Fields, Items & Sets’ option, and then click on “Calculate Field.” will appear, the user must give a name to the column. Then click “Add” followed by “OK” to create a new column in the pivot table.

Q36. How can you provide Dynamic Range in the Data Source of the Pivot Table?

A dynamic range is used in the Data source of the pivot table to make the pivot table dynamic enough to adjust the new data when it refreshes automatically. The user must create a named table to provide a dynamic range, then go to the Insert tab and select Table, under which they should give a name to the table.

Advanced Excel Interview Questions and Answers

Advanced Excel interview questions focus on more complex features and techniques used to analyze and manage large amounts of data. These questions may cover advanced formulas, PivotTables, lookup functions, and data analysis tools.

Let’s explore some Excel advanced interview questions you should prepare for:

Q37. Explain What-If analysis in Excel

A tool that is powerful enough to perform complex calculations in Excel, experiment with data, and try different scenarios is known as the What-if analysis. The user must go to the “Data” tab and click on “What-If Analysis ” under forecast, which will enable this function to perform all the complex calculations.

Q38. List the differences between a function and a subroutine

Function	Subroutine
They return the value of the task it is performing.	They do not return the value of the task it is performing.
These can be also called a variable.	These can be recalled from anywhere in the program.
These are used as formulas in the spreadsheet.	These are not directly used as formulas in the spreadsheet.
They can carry out repetitive tasks.	The user needs to insert a value to carry out any task.

Q39. How is a VBA code debugged?

The user can use the F8 key to debug the VBA code line by line, they can also create a breakpoint to execute the termination wherever they want. The execution is supposed to start from the beginning and every time the user will press the F8 key, it will execute the next line and this will continue until the end of the code. 

Q40. How to use COUNTIF in Excel?

This formula in Excel allows the user to count the number of cells in a range that meets certain criteria. For example, a user can use the COUNTIF function to count the number of cells in a range that contains the word “banana”.

Q41. List the difference between a worksheet and a workbook in Excel

A single tab within a workbook containing cells, columns, and rows for organizing and analyzing data is known as a worksheet. Whereas, a file in Excel containing one or more worksheets is known as a workbook.

Q42. Explain VBA

A programming language that is used to automate tasks in Excel is known as VBA or Visual Basic for Applications.

Q43. List some useful loops in VBA

The following are some useful loops in VBA:

• For Next Loop
• Do While Loop
• Do Until Loop
• For Each Next Loop

Q44. Name some text functions

CONCATENATE(): It is used to join several text strings into one string.
PROPER(): It arranges the characters properly.
TEXT(): This text function converts a value into text formatting
LEFT(): It returns the specified number of characters from the starting character.

Q45. Define charts in Excel

Charts are provided in Excel to enable the graphical presentation of the data. The user can use any chart type, including column, bar, line, pie, or scatter, by clicking “Insert” and then selecting the type of chart as per their requirement.

Q46. List the different ways to run a macro

Following are the ways to run a macro:

• Assigning it to a particular shape.
• Assigning it to a button.
• Running a macro from the ribbon.
• The user can run a macro using a keyboard shortcut key.

Q47. Define the volatile function in Excel

A function that recalculates the formula so the Excel workbook performance slows down is known as Volatile Function. It automatically recalculates the formula whenever any changes are made in the worksheet.

Q48. Define ADO, ODBC, and OLEDB

• ADO: a data access framework that is useful to get the data from the databases is known as ActiveX Data Objects.
• ODBC: It stands for Open Database Connectivity and is used to get the data from the external database.
• OLEDB: It is known as Object Linking and Embedding, Database.

AI-Related Excel Interview Questions 

As AI becomes more common in workplace tools, interviewers may also ask how you can use AI with Excel. These Excel interview questions can test your understanding of AI-powered features and how they can support data analysis and everyday Excel tasks. 

The following questions will help you prepare for this growing area of Excel interviews.

Q49. What is Microsoft Copilot in Excel?

Microsoft Copilot in Excel is an AI-powered assistant that can help users build and edit workbooks, generate formulas, analyse data, create charts and PivotTables, and apply formatting based on natural-language instructions.

Q50. How can Copilot help with Excel formulas?

Copilot can generate formulas based on a user’s instructions and suggest formulas using the context of the data in the worksheet. It can also help users understand existing formulas.

Q51. How can AI help with data analysis in Excel?

Copilot can analyse data to identify trends, patterns, and outliers. Users can ask questions about their data in natural language and receive answers, summaries, charts, or other visualisations.

Q52. Can Copilot create charts and PivotTables in Excel?

Yes. Copilot can create charts and PivotTables based on the user’s instructions. It can also highlight, sort, and filter data to help users focus on relevant information.

Q53. How can natural-language prompts be used in Excel?

Users can describe the task they want to perform instead of manually specifying every step. For example, they can ask Copilot to compare sales across regions, identify trends, or create a chart. Specific prompts can help generate more relevant results.

Q54. Can AI help identify trends and outliers in Excel data?

Yes. AI can analyze Excel data to identify patterns, trends, and unusual values. For example, it can help spot sudden changes in sales or values that differ significantly from the rest of the data. This makes it easier to find areas that may need further review.

Q55. Can Copilot help with advanced data analysis in Excel?

Yes. Copilot can help with advanced data analysis by creating formulas, summarizing datasets, identifying trends, and suggesting useful insights. You can also ask questions about your data in natural language, which can make complex analysis easier.

Q56. Should you verify AI-generated results in Excel?

Yes. Always verify AI-generated results before using them. AI can sometimes produce incorrect formulas or misunderstand the data. Checking the calculations and results helps ensure that your final analysis is accurate. 

Tips to Prepare for Excel Interview Questions and Answers

Excel interview preparation requires a good understanding of basic and advanced features, along with enough practice to use the formulas and logics confidently. Interviewers may ask you to explain a function, solve a data-related problem, or complete a practical task. Use the following tips to prepare effectively for your MS Excel interview questions:

• Revise Basic Excel Concepts: Review cells, rows, columns, worksheets, formulas, functions, formatting, sorting, filtering, and cell references.
• Practise Important Functions: Make sure you understand commonly used functions such as SUM, AVERAGE, IF, COUNTIF, SUMIF, VLOOKUP, and XLOOKUP. Focus on when and why you would use each function.
• Practise with Sample Datasets: Use simple datasets to practise finding duplicates, removing duplicate values, applying filters, creating PivotTables, and generating charts.
• Learn Useful Shortcuts: Familiarise yourself with shortcuts for common tasks such as copying, pasting, saving, undoing actions, finding data, and checking spelling. This can help you work more efficiently during a practical test.
• Prepare for Practical Questions: Do not focus only on memorising definitions. Practise solving common Excel tasks so you can explain the steps clearly if an interviewer asks you to demonstrate your skills.
• Review Your Mistakes: When practicing, check your formulas and results carefully. Understanding why an answer is incorrect can help you avoid similar mistakes during the interview.
• Be Ready to Explain Your Approach: If an interviewer gives you an Excel problem, explain the steps you would take to solve it. It helps demonstrate that you understand how Excel features work and when to use them.

Conclusion

Excel is a useful skill for many roles, so interview prep requires both knowledge and practice. Review basic functions, advanced features, shortcuts, data analysis tools, and AI-powered features such as Copilot. Practice common Excel questions and work with sample datasets to improve your confidence. With regular practice, you can explain your Excel skills clearly and handle practical interview tasks more effectively.

Want to strengthen your Excel skills before your interview? Explore our guide to basic and advanced Excel formulas to learn commonly used formulas and understand how to apply them in practical situations.

FAQs