Microsoft Excel is a spreadsheet software built by Microsoft Corporation. It belongs to the Microsoft Office suite of applications used to create, organize, analyze, and share data in a tabular format.

Excel facilitates users to create and manipulate spreadsheets, which are made up of rows and columns of cells that can contain numbers, formulas, text, and other data types. Prepare this list of Top 100 Microsoft Excel Interview Questions with Answers to prepare for your next data analyst or Business Analyst Interview and get a Job Offer.

Excel includes powerful features like charting, graphing, and conditional formatting, making it a versatile tool for various tasks, including budgeting, financial analysis, data analysis, and more. It is a potent tool for organizing and analyzing data, whether it’s financial data, scientific data, or any other kind of data.

Considering the innumerable benefits of Excel, many companies demand Excel proficiency and ask Excel interview questions for data analysts, financial analysts, accounting, and other job positions. To help you ace any Excel interview , we are listing 100 most commonly asked Microsoft Excel interview questions. The list has been curated after an extensive market survey.

Question 1: What is Microsoft Excel?

Answer:

Microsoft Excel is an electronic worksheet or spreadsheet application which is used for organizing, storing, and manipulating and analyzing data. It is developed by Microsoft.

Question 2: What do you mean by cells in Excel?

Answer:

To put it simply, cells refer to the area where you can store the data. It is situated at the intersection of a row and a column, and a single excel sheet comprises 1,048,576*16.384 cells.

Question 3: What is a cell address?

Answer:

A cell address refers to the address that is primarily used to identify a particular cell in a worksheet. It is a combination of the row number and the column alphabet.

Question 4: How can you add cells, rows or columns in Excel?

Answer:

If you want to add a cell, row or column in Excel, right click the cell you want to add to and after that select insert from the cell menu. The insert menu makes you able to add a cell, a column or a row and to shift the cells affected by the additional cell right or down.

Question 5: How would you format a cell? What are the options?

Answer:

A cell can be formatted by using the format cells options. There are six format cells options:

Number
Alignment
Font
Border
Fill
Protection

Question 6: What does the red triangle indicate at the top right hand corner of the cell?

Answer:

The red triangle at the top right hand corner of a cell indicates that there is a comment linked to the particular cell. If you put your cursor on it, it will show the comment.

Question 7: How would you add comments to a cell?

Answer:

To add a comment to a cell, you right click the cell and choose insert comment from the cell menu. Type your comment in the comment area provided. A red triangle at the top right hand corner of a cell indicates that there is a comment linked to that particular cell. To remove a comment from a cell, right lick the cell and then select delete comment from the cell menu.

Question 8: What is Freeze Panes in MS-Excel?

Answer:

Freeze Panes are used to lock any row or column. The locked row or column will be visible on the screen even after we scroll the sheet vertically or horizontally.

Question 9: What is Ribbon?

Answer:

The ribbon specifies an area which runs along the top of the application and contains menu items and toolbars available in Excel. The ribbon has various tabs that contain groups of commands for use in the application.

Question 10: What are the several report formats in Excel?

Answer:

There are three report formats in Excel:

Compact
Report
Tabular

Question 11: Is it possible to make Pivot table using multiple sources of data?

Answer:

If the multiple sources are different worksheets from the same workbook, then you can use these multiple sources of data to make Pivot table.

Question 12: What does the IF function in Excel?

Answer:

IF function is used in Excel to check whether certain conditions are true or false. If the condition is true, then it will give the result accordingly and if the condition is false the result or output will be different.

Question 13: Can you protect workbooks in Excel?

Answer:

Yes, workbooks can be protected. Excel provides three options for this:

Passwords can be set to open Workbooks
You can protect sheets from being added, deleted, hidden or unhidden
Protecting window sizes or positions from being changed

Question 14: How do you apply a single format to all the sheets present in a workbook?

Answer:

To apply the same format to all the sheets of a workbook, follow the given steps:

Right-click on any sheet present in that workbook.
Then, click on the Select All Sheets option.
Format any of the sheets and you will see that the format has been applied to all the other sheets as well.

Question 15: How do you create Named Ranges?

Answer:

To create named ranges, follow the given steps:

Select the area to which you intend to give a name
From Ribbon, select Formulas
Click on Define Name from Defined Names group
Give any name of your choice

Question 16: How can you resize the column?

Answer:

To resize the column, you should change the width of one column and then drag the boundary on the right side of the column heading till the width you want. The other way of doing it is to select the Format from the home tab, and in Format you have to select AUTOFIT COLUMN WIDTH under cell section. On clicking on this, the cell size will get formatted.

Question 17: What is the quick way to return to a particular area of a worksheet?

Answer:

The quick way to return to a specific area of the worksheet is by using name box. You can type the cell address or range name in name box to return to a specific area of a worksheet.

Question 18: How cell reference is useful in the calculation?

Answer:

In order to avoid writing the data again and again for calculating purpose, cell reference is used. When you write any formula, for specific function, you need to direct Excel the specific location of that data. This location is referred as, cell reference. So, every time a new value added to the cell, the cell will calculate according to the reference cell formula.

Question 19: How can a worksheet protected from getting copied?

Answer:

To restrict someone from copying a cell of your worksheet, follow the below steps.

Go to the Menu Bar
Select the Review option
Click on Protect Sheet
Enter your Password

Question 20: What is the function of Slicer in Excel?

Answer:

Slicer in Excel is used to filter the Pivot Tables quickly and efficiently. In order to insert a Slicer, you need to first click on any cell present inside the pivot table. Following this, go to Analyze, select Filter, and finally, Insert Slicer.

Top 100+ Excel Interview Questions and Answers

Contact Us