Excel Interview Questions

Aiming for a data analyst role? Make sure your Excel game is strong. Here are some interview-style questions to challenge your skills:

1. Which Excel functions are most commonly used for analyzing data?
2. Can you explain how VLOOKUP and HLOOKUP work?
3. What’s the key difference between relative and absolute cell references?
4. How would you build and customize pivot tables and charts in Excel?
5. Describe how conditional formatting is applied to highlight data trends.
6. What steps do you take to remove duplicate entries from a dataset?
7. What are macros in Excel, and how can you create and run them?
8. How is the IF function used, and how do you nest it with AND/OR?
9. How do you combine text using CONCATENATE or the ampersand (&) operator?
10. What is data validation in Excel, and why is it important?

📄 Want more? Grab the full list in our downloadable PDF!