Basic Level Questions

Q1. What is XLOOKUP?
👉 Modern lookup function that replaces VLOOKUP & HLOOKUP

Q2. Syntax of XLOOKUP?
👉 =XLOOKUP(lookup_value, lookup_array, return_array)

Q3. Advantage of XLOOKUP over VLOOKUP?
👉 Works left/right, no column index needed

Q4. What is INDEX function?
👉 Returns value from a position

Q5. MATCH function?
👉 Finds position of value

Q6. INDEX + MATCH use?
👉 Flexible lookup

Q7. What is IFERROR?
👉 Handles errors

Q8. What is nested IF?
👉 Multiple conditions

Q9. What is COUNTIF?
👉 Count with condition

Q10. What is SUMIF?
👉 Sum with condition

Q11. What is data validation list?
👉 Dropdown selection

Q12. What is conditional formatting rule?
👉 Apply logic-based formatting

Q13. What is named range?
👉 Custom name for cells

Q14. What is table in Excel?
👉 Structured dynamic range

Q15. What is structured reference?
👉 Table-based formula

Q16. What is freeze panes?
👉 Lock rows/columns

Q17. What is sort multi-level?
👉 Sort by multiple columns

Q18. What is filter by condition?
👉 Show specific data

Q19. What is subtotal?
👉 Group-based calculation

Q20. What is pivot table?
👉 Data summary tool