Microsoft Excel Interview Questions and Answers

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?

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?

What are different Functions in Excel?

No Comments

Post a Reply