Interview question · Technical or skills round
“What Excel functions do you use most in your models?”
Financial Analyst
How to answer it
Mention XLOOKUP or INDEX-MATCH, SUMIFS, pivot tables, and scenario or sensitivity tables. Say how you keep models easy to check: inputs separate, no hard-coded numbers in formulas.