Excel Interview Questions: Prepare for Success

1. What is operator precedence of formulas in Excel?
2. What is the primary difference between functions and formulas in Excel?
3. Name the different data formats in Excel and the uses.
4. Difference between SUM and SUMIF functions.
5. What is the difference between COUNT, COUNTA, COUNTBLANK and COUNTIF?
6. How to detect duplicate cells in a table? How to detect blank cells in a table?
7. What are freeze panes in Excel? Under which tab can you find freeze panes?
8. Difference between VLOOKUP and INDEX MATCH functions. Mention the syntax of VLOOKUP and INDEX MATCH.
9. How to use wildcards in VLOOKUP?
10. Does VLOOKUP perform search horizontally? How to do horizontal lookup in Excel?
11. What is relative cell address? What is absolute cell address?
12. What is ribbon in Excel?
13. How to add comments in a cell in Excel?
14. What is macro in Excel?
15. What are different kinds of volatile functions in Excel? Identify types of highly volatile and almost volatile functions.
16. How to create pivot tables using multiple tables? How to create pivot tables from different worksheet?
17. What are calculated fields in Pivot Tables?
18. Difference between pivot charts and regular charts.
19. What are slicers?
20. What is the difference between SUBSTITUTE and REPLACE function in Excel?
21. What is a secondary axis in a chart?
22. Difference between one-variable and two-variable data table?
23. What is what-if analysis?
24. What is the difference between dashboard and report in Excel?
25. Mention the different kinds of error in Excel. When do these errors occur?

Also may find Excel FAQ interested.

Good like with your new job and learning to create formulas like this one 🙂