Microsoft Excel Interview Questions and Answers

excel interview questions

Microsoft Excel Interview Questions and Answers

What is Excel?

What is Freeze Panes in Excel?

Is it possible to hide or show the ribbon?

What is the sequence of operating mathematical operation in Excel?

How many rows and columns are there in Microsoft Excel 2003 and later versions?

How many characters can fit into a single cell in Excel?

How to get to the last row of a worksheet in Excel?

How to get to the last column of a worksheet in Excel?

What is VLOOKUP? What is Syntax of VLOOKUP?

How to define a name for a range of cells in Microsoft Excel?

How many report formats are available in Excel?

What is the difference between function and formula in MS-Excel?

What is the use of the “ What If” condition?

What is the syntax of SUBSTITUTE function in Excel?

What is central order of operations used to make calculations on MS Excel?

What are the volatile functions in Excel?

How can you prevent pivot tables from losing column width when you refresh?

What are the most used basic Excel Formulas?

What are most popular functions in EXCEL?

Read More:

How to use CELL Function in Excel?

How can you stop format losing in a Pivot table?

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

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

How is Dynamic range provided in Data Source of Pivot Tables?

Is there any particular use of cell reference in the calculation?

What are Macros?

How can you format a cell?

Which filter is used to analyze the list that is employed with database function?

Which symbol is used to lock or fix the reference?

What is the spreadsheet?

What is shortcut for find and replace tab in Excel?

What are the popular methods to transpose a data set in Excel?

Does VBA support OOPs concepts?

Can you explain, how do you create dropdown lists in Excel?

Read More : Excel Formula Errors and How to fix them

What is the syntax of SUBSTITUTE function in Excel?

How to open the Spellcheck using shortcut key?

How will you debug codes in VBA?

What do you know about Pivot Table?

What is conditional formatting in Excel?

Can you explain, how to use Conditional Formatting in Excel?

What are the keys used to move to the previous/next worksheet in Excel?

What is use of the name box in MS-Excel?

What are the most used excel functions according to you?

What is use of Data Validation in Excel?

Where we can use the SUBTOTAL function?

What is the use of Slicer in Excel?

What is the use of Timeline in Excel?

How can you protect workbooks in Excel?

What is the easiest method to reduce the file size?

What is the syntax of calculate compound interest in Excel?

Explain, how can you highlight cells with negative values in Excel?

You know how to work on excel?

What are different Functions in Excel?