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 interview questions.

I have tried to cover all the popular Excel interview questions I have seen being asked, 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

## Excel Interview Questions Topics

### Excel Formatting Questions

Below are some common formatting Excel interview 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 for interviews (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 interview questions about keyboard shortcuts 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 interview questions about Pivot Table 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 interview questions about charting 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 interview questions about Data Analysis 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 interview questions about VBA 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 interview questions about dashboards 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 'Excel Interview Questions & Answer' guide error-free, in case you find any errors in any of the questions, please let me know in the comments area.

**Related**: Free Online Excel Training (7-part video course)

good

hello Experts

Can you help me below. I have multiple pivot tables in one big workbook. But whenever i save as file with different name and try to update the pivot table, it is still keeps referring to old file name. It is painful for me to change data source everytime. How to fix this? why it is still keeps referring to old file? i am using excel 2016 pro plus.

thanks a lot

Excellent!!

You are so amazing Sumit…. I keep learning and practicing whatever material you share.

Great Job sir!!!