✅ Top 10 Excel Interview Questions 📊💼

1️⃣ What’s the difference between relative, absolute & mixed reference?
⦁ Relative: Changes when copied (A1)
⦁ Absolute: Fixed ($A$1)
⦁ Mixed: Part fixed (A$1 or $A1)

2️⃣ What is VLOOKUP and how does it work?
Searches a value vertically in the first column of a range:
VLOOKUP(value, table, col_index, [range_lookup])

3️⃣ Difference between VLOOKUP and INDEX-MATCH?
⦁ VLOOKUP: Left-to-right only
⦁ INDEX-MATCH: More flexible & faster for big data

4️⃣ Explain Pivot Tables.
Summarizes large data sets with dynamic grouping, filtering & aggregation.

5️⃣ What is conditional formatting?
Applies formatting like colors/icons based on rules or formulas.

6️⃣ How to remove duplicates?
Select data → Data tab → Remove Duplicates.

7️⃣ What’s a dynamic named range?
Range that auto-expands/shrinks as data changes, often using OFFSET + COUNTA.

8️⃣ How to handle errors in formulas?
Use IFERROR() or ISERROR() to catch and manage errors.

9️⃣ How to protect a sheet/workbook?
Use Review tab → Protect Sheet/Workbook + password.

🔟 Difference between COUNT, COUNTA, COUNTIF, COUNTBLANK?
⦁ COUNT: Counts numbers only
⦁ COUNTA: Counts non-empty cells
⦁ COUNTIF: Counts based on condition
⦁ COUNTBLANK: Counts empty cells

💬 Tap ❤️ for more Excel interview tips & tricks!