*7 Must-Know Excel Interview Questions* 💡 *1. What is the difference between a function and a formula in Excel?* ➡️ A formula is a user-defined calculation, while a function is a predefined formula like `SUM()` or `VLOOKUP()`. *2. How does VLOOKUP work?* ➡️ It searches for a value in the first column of a range and returns a value from the same row in another column. *3. What is the difference between absolute and relative cell references?* ➡️ Relative (A1) changes when copied; absolute (A1) stays fixed. *4. What is conditional formatting?* ➡️ It applies formatting (colors, icons) to cells based on rules like values, text, or formulas. *5. How can you remove duplicates from a dataset?* ➡️ Use *Data > Remove Duplicates* or use formulas like `UNIQUE()` (in newer Excel versions). *6. What are Pivot Tables used for?* ➡️ To summarize, analyze, and visualize large data sets quickly with drag-and-drop fields. *7. Describe a scenario where you automated a task in Excel.* ➡️ Mention using formulas, Pivot Tables, or VBA macros to save time and reduce errors. ✨ *Pro tip:* Practice explaining Excel features with real business examples. *Double Tap ❤️ if this helped you!*