## Excel Interview Questions and answers

- What is Excel and what is it used for?
- What are the advantages of Microsoft Excel?
- Explain the main features of MS Excel?
- Why do we use formulas in Excel?
- What are the basic formulas in Excel?
- How can you resize the column?
- How do I freeze panes in Excel 2017?
- How can you format a cell what are the options?
- What are absolute and relative cell references?
- How do I do an IF-THEN formula in Excel?
- Explain the essential data formats seen in Excel?
- How many cells are in an Excel sheet?
- What is a macro in MS Excel?
- What is financial modeling in Excel?
- How do I merge two cells in Excel without deleting data?
- What is function and formula in Excel?
- What are the different types of errors in Excel?
- What is the syntax of the Vlookup function?
- How are count Counta and Countif functions different from each other?
- What is the order of precedence for Excel operators?
- How do you enter a complicated formula in Excel?
- What is the use of subtotal function in Excel?
- Is there a shortcut key for AutoSum in Excel?
- What is pivot cache in Excel VBA?
- What is a waterfall chart in Excel?
- How to sort numerically in Excel?
- Why is VBA used in Excel?
- What are the difference between SUBSTITUTE and REPLACE function in MS-Excel?

*Looking for a new job? Do not miss to read our ***Excel Interview Questions and answers**. Whether you are a fresher or an experienced, these questions and answers that can help you to crack your interview.

**Excel Interview Questions and answers**. Whether you are a fresher or an experienced, these questions and answers that can help you to crack your interview.