100+ Excel Questions To Make You Interview Ready

Excel Questions for Job Interview - Cover

Microsoft applications such as Word, Excel, PowerPoint are used in almost every large organization as well as by millions of small businesses, freelancers, and entrepreneurs.

For something that is so popular, it makes sense to have a decent knowledge on how to use these applications efficiently. In some job roles, a major part of the work involves working with these applications on a daily basis.

I have been part of many interview panels where I have seen the candidates mention Excel as one of the skills they are expert in, but when asked a few questions on it, the expertise fizzled out.

In case you're prepping up for your next interview, and have listed Excel as one of your skills, take some time to go through these common Excel questions.

I have tried to cover all the popular Excel questions I have heard during interviews, as well as some that I thought could be good to know.

This guide can also be used by interviewers who want to gauge the Excel skill of the candidates in the interview.

Note: I will keep on adding new questions to this guide. You can bookmark it so that you can come back and check it later.

How to Use this Excel Interview Questions Guide

  • If you have time, go through each of the questions.
  • If you want to learn about specific topics, click on the topic name from the table of contents. Then you can go through all the Excel questions for that topic.
  • arrow-right
    In most of the questions, further reading has been suggested and relevant tutorials has been linked. You can go through those tutorials to get a deeper understanding of the topic.
  • If you only want to get the basics right, go through all the questions except the ones in the boxes highlighted in blue. Excel questions in the blue box are of an advanced level.

Excel Questions Topics

Excel Formatting Questions

Below are some common formatting Excel questions (click on the question to view the answer to it).

What are the different data formats in Excel?

How can you wrap text in Excel?

How can you merge cells in Excel?

What is 'Format Painter' used for?

How would you clear all the formatting without removing the cell contents?

What is conditional formatting?

How would you highlight cells with negative values in it?

How would you highlight cells with duplicate values in it?

How would you highlight cells with errors in it?

How can you make text invisible in Excel?

Excel Formula Questions

Below are some common Excel formula questions (click on the question to view the answer to it).

What is the order of operations used when evaluating formulas in Excel?

What is the difference between a function and a formula in Excel?

What according to you are the top 5 functions in Excel?

What is the difference between absolute and relative cell references?

What are the different types of errors you can encounter in Excel?

How can you tackle errors when working with Excel Formulas?

Which function would you use to get the current date and time in Excel?

How can you combine the text from multiple cells using a formula?

What formula would you use to find the length of a text string in a cell?

What is the syntax of the VLOOKUP function?

How would you get rid of leading / trailing / double spaces in a text in Excel?

What are the known limitations of the VLOOKUP function?

When would you use the SUBTOTAL function?

What are volatile functions? Can you name a few?

Excel Keyboard Shortcuts

Below are some common Excel keyboard shortcut questions that you might get asked in an interview (click on the question to view the answer).

What are the most useful keyboard shortcuts you use?

What is the shortcut for opening the find and replace dialog box

What is the shortcut for spell check?

What is the shortcut to quickly auto-sum rows/columns?

What is the shortcut to open a new Excel workbook?

How can you select all the cells in the worksheet

How would you insert a new line in the same cell?

What's the shortcut to insert a comment in Excel?

Excel Pivot Table Questions

Below are some common Excel Pivot Table questions that you might get asked in an interview (click on the question to view the answer).

What is a Pivot Table, and when would you use one?

What are the various sections in a Pivot Table?

What are slicers?

What is a Pivot Chart

What are the difference between Pivot Charts Vs Regular Charts?

How can you refresh a Pivot Table?

Can you group dates in Pivot Tables?

What is a Pivot Cache?

Can you make a Pivot Table from multiple tables?

What are Calculated Fields in Pivot Table?

Excel Charting Questions

Below are some common Excel charting questions that you might get asked in an interview (click on the question to view the answer).

What is a Column chart?

What is a Bar chart?

What is a Line chart?

What is a Scatter chart?

Are Pie charts good? Should it used in reports/dashboard?

What is a Waterfall chart? When would you use it?

What are Combination charts?

What is a secondary axes in a chart?

What is a Bullet chart? When should we use it?

Excel Data Analysis Questions

Below are some common Excel Data Analysis questions that you might get asked in an interview (click on the question to view the answer).

How to replace one value with another in Excel?

What kind of data filters are available in Excel?

How can you sort data in Excel?

What is data validation?

How can you transpose a data set in Excel?

How can you select all blank cells in Excel?

How can you remove duplicates from a data set?

What is an advanced Filter in Excel?

Can you sort multiple columns at one time?

What is a one-variable data table?

What is a two-variable data table?

What is Scenario Manager?

What is Goal Seek?

What is a Solver?

Excel VBA Questions

Below are some common Excel VBA questions that you might get asked in an interview (click on the question to view the answer).

What is VBA?

What are the benefits of using VBA in Excel?

What is a macro in Excel?

How can you record a macro in Excel?

What are limitations of recording a macro in Excel?

What is a UDF in Excel VBA?

What are Events in VBA?

What are some of the useful loops in VBA?

What are the different ways to run a macro in Excel?

What are UserForms?

What are add-ins?

Excel Dashboard Questions

Below are some common Excel Dashboard questions that you might get asked in an interview (click on the question to view the answer).

What is difference between a dashboard and a report?

What are some of the questions you should ask a client/stakeholder before creating a dashboard?

What are some interactive controls you can use in dashboards?

What are some useful chart types that you can use in a dashboard?

What are some best practices when creating a dashboard in Excel?

Other Excel Questions

These are the questions that I could not fit in any of the above categories. So I am putting all these together here (click on the question to view the answer).

What is an Excel Table?

What are the benefits of using Excel Table?

What are structured references?

What are the commonly used file formats in which an Excel file can be saved?

How to reduce the size of an Excel file?

What steps can you take to handle slow Excel workbooks?

How many rows and columns are there in an Excel worksheet?

How to add/delete rows in Excel?

How can you zoom in or zoom out in Excel?

How to protect a sheet In Excel?

What are named ranges? What are its benefits?

Can you make the header rows/columns stick and be visible when you scroll?

How would you identify cells that have comments in it?

How would you save an Excel worksheet as a PDF?

How to create a hyperlink in Excel?

When would you consider switching from automatic to manual calculation in Excel?

What is Flash Fill?

What is a Fill Handle?

What are wildcard characters in Excel?

What is a Print Area and how can you set it in Excel?

How can you insert Page Numbers in Excel?

While I have tried to keep this guide error-free, in case you find any errors in any of the Excel questions please let me know in the comments area.