Top 30 MS Excel Interview Questions

Top 30 MS Excel Interview Questions: Here are the top interview questions of MS Excel. Be prepared for the interview. You can download the entire questions in a pdf format. so guys All the best for your interview.

1) What is Microsoft Excel?

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.


2) What are cells?

The area where data is stored is known as cell.


3) Does each cell have unique address?

Yes, each cell has a unique address depends on the row and column value of the cell.


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

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.

You might like: Top 32 Selenium Interview Questions and Answers with PDF Download in 2019


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

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

  • Number
  • Alignment
  • Font
  • Border
  • Fill
  • Protection

6) How can you wrap the text within a cell?

You must select the text you want to wrap, and then clickwrap text from the home tab and you can wrap the text within a cell.

7) Explain Macro in MS-Excel.

Macros are used for iterating over a group of tasks. Users can create macros for their customized repetitive functions and instructions. Macros can be either written or recorded depending on the user.

8)Which are the two macro languages in MS-Excel?

XLM and VBA (Visual Basic Applications). Earlier versions of Excel used XLM. VBA was introduced in Excel 5 and mostly used now.

9) Is it possible to prevent someone from copying the cell from your worksheet?

Yes, it is possible. To protect your worksheet from getting copied, you need to go into Menu bar >Review > Protect Sheet > Password. By entering a password, you can secure your sheet from getting copied by others.

10) What are charts in MS-Excel?

Top 30 MS Excel Interview Questions To enable the graphical representation of the data in Excel, charts are provided. A user can use any chart type, including column, bar, line, pie, scatter, etc. by selecting an option from Insert tab’s Chart group.

11) Which are the different workbook protection types in Excel?

There are three ways to protect a workbook in Excel:

  • Password protection for opening a workbook
  • Protection for adding, deleting, hiding and unhiding sheets
  • Protection from changing size or position of windows.

12) What is the difference among COUNT, COUNTA, COUNTIF, and COUNTBLANK in Ms-Excel?

COUNT is used to count cells containing numbers, dates, etc. any value stored as number excluding blanks.

COUNTA or Count All is used to count any cell value containing numbers, text, logical values, etc. any type of value excluding blanks.

COUNTBLANK count blank cells or cells with an empty string.

COUNTIF and COUNTIFS count cells matching a certain criteria.


13) What is Ribbon?

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.


14) Is it possible to hide or show the ribbon?

You can hide or show (minimize or maximize) the ribbon by pressing CNTRL F1.


15) How to prevent someone from copying the cell from your worksheet?

If you want to protect your worksheet from being copied, go into Menu bar > Review > Protect sheet > Password.

By entering password you can prevent your worksheet from getting copied.

16) How can you resize the column?

Top 30 MS Excel Interview Questions 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.

17) Explain pivot tables and its uses.

A pivot table is a tool that allows for quick summarization of large data. It automatically performs a sort, count, total or average of the data stored in the spreadsheet and displays result in another spreadsheet. It saves a lot of time. Allows linking external data sources to our Excel.

18) What are three report formats that are available in Excel?

Following are the types of report formats

  • Compact
  • Report
  • Tabular

19) How would you provide a Dynamic range in “Data Source” of Pivot Tables?

To provide a dynamic range in “Data Source” of Pivot tables, first, create a named range using offset function and base the pivot table using a named range created in the first step.

20) Is it possible to make Pivot table using multiple sources of data?

If the multiple sources are different worksheets, from the same workbook, then it is possible to make a Pivot table using multiple sources of data.

21) What does the IF function in Excel?

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.


22) What filter should we use, if you want more than two conditions or if you want to analyze the list using database function?

You should use “Advanced Criteria Filter” to analyze the list or test more than two conditions.


23) What are the advantages of using formula in Excel sheet?

Top 30 MS Excel Interview Questions Formula makes it easy to calculate the numbers in the Excel sheet. It also calculates automatically the number replaced by another number or digit. It is used to make complex calculations easy.


24) What is the order of sequence of operating mathematical operation in Excel?

The order of sequence is written as BEDMAS:

  • Brackets
  • Exponents
  • Division
  • Multiplication
  • Addition
  • Subtraction

25) What is the use of LOOK UP function in MS Excel?

The LOOK UP function is used to return a value from an array.

26) Explain the difference between SUBSTITUTE and REPLACE function in MS-Excel?

The SUBSTITUTE function substitutes one or more instances of old text with the new text in a string.

Syntax: SUBSTITUTE(text, oldText, newText, [instanceNumber])

Example: Let text at A2 be Guru99,Guru99

SUBSTITUTE(A2,”9″,”8″,1) =>Guru89,Guru99

SUBSTITUTE(A2,”9″,”8″,2) =>Guru88,Guru99

SUBSTITUTE(A2,”9″,”9″) =>Guru99,Guru99

The REPLACE function swaps part of the text string with another set of text.

Syntax: REPLACE(oldText, startNumber, NumberCharacters, newText)

Example: Let text at A2 be Guru99

REPLACE(A2,5,1,”00″) =>Guru009

27) Difference between COUNT, COUNTA, COUNTIF and COUNTBLANK in Ms-Excel.

COUNT is used to count cells containing numbers, dates, etc. any value stored as number excluding blanks.

COUNTA or Count All is used to count any cell value containing numbers, text, logical values, etc. any type of value excluding blanks.

COUNTBLANK count blank cells or cells with an empty string.

COUNTIF and COUNTIFS count cells matching a certain criteria.

28) What is IF function in Excel?

Top 30 MS Excel Interview Questions To perform the logic test IF function is performed. It checks whether certain conditions are true or false. If the condition is true, then it will give the result accordingly if the condition is false then the result or out-put will be different.

Example: For example, you select the cell, and you want to display that cell as “Greater than five,” when value is true (=5 or 5) and “less than five” when value is false (<5). For that by using IF condition you can display result.

=IF (Logical test, value if true, value if false)

=IF (A1>5, “Greater than five, “Less than five”)

29) Can we create shortcuts to Excel functions?

Yes. ‘Quick Access Toolbar’ above the home button can be customized to display most frequently used shortcuts.

30) What is the use of LOOKUP function in Excel?

In Microsoft Excel, the LOOKUP function returns a value from a range or an array.