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.

Know someone with an interview coming up? Send it to them.