Basic Excel Interview Questions:
- What is Excel and what is it used for?
- What is a cell in Excel?
- What is a workbook in Excel?
- What is a formula in Excel and how is it created?
- What is a worksheet in Excel?
- What is a function in Excel and how is it used?
- How do you format cells in Excel?
- What is conditional formatting in Excel?
- What is a chart in Excel and how is it created?
- What is a pivot table in Excel and how is it created?
Intermediate Excel Interview Questions:
- What is the difference between relative and absolute cell references in Excel?
- How do you use VLOOKUP in Excel?
- How do you use IF statements in Excel?
- How do you use COUNTIF and SUMIF functions in Excel?
- How do you create a macro in Excel?
- What is data validation in Excel and how is it used?
- How do you use filters in Excel?
- What is the difference between a chart and a graph in Excel?
- How do you use named ranges in Excel?
- What is the purpose of the INDEX and MATCH functions in Excel?
Advanced Excel Interview Questions:
- How do you use array formulas in Excel?
- What is Power Pivot in Excel and how is it used?
- How do you use Power Query in Excel?
- What is Power View in Excel and how is it used?
- How do you use Goal Seek and Solver in Excel?
- What is the difference between a workbook and a worksheet in Excel?
- How do you use conditional formatting to create heat maps in Excel?
- How do you use data tables in Excel?
- What is the difference between a pivot table and a pivot chart in Excel?
- How do you use advanced filter options in Excel?