10.30.3
- 1. How do you combine INDEX and MATCH for advanced lookups?
- 2. How does the MATCH function work in Excel?
- 3. What is the INDEX function used for in Excel?
- 4. How can XLOOKUP return a default value when no match is found?
- 5. How do you perform a vertical lookup using XLOOKUP?
- 6. How does the XLOOKUP function improve upon VLOOKUP?
- 7. What is the difference between VLOOKUP and HLOOKUP?
- 8. How can VLOOKUP return errors, and how can they be avoided?
- 9. What is the difference between approximate and exact match in VLOOKUP?
- 10. How do you structure a VLOOKUP formula?
- 11. What is the purpose of the VLOOKUP function?
- 12. How do logical operators like >, <, >=, <= work in Excel formulas?
- 13. What is the difference between AND and OR functions in logical tests?
- 14. Give an example of using IF with multiple conditions.
- 15. How do you combine the IF function with OR?
- 16. How do you combine the IF function with AND?
- 17. How can the IFS function simplify multiple nested IF statements?
- 18. What is the difference between IF and IFS functions?
- 19. How do you write a basic IF formula in Excel?
- 20. What is the purpose of the IF function in Excel?