01
Build a break-even analysis in Excel.
Show answer
Break-even units = Fixed costs ÷ (Price − Variable cost per unit).
Add a data table to test different price and volume scenarios.
Excel Interview Questions for Business Analyst
4 Excel questions with answers for business analyst roles. Tick what you have solved to track your progress.
Sheet progressStart practicing
02
XLOOKUP vs VLOOKUP?
Show answer
XLOOKUP can look left or right, uses exact match by default, returns a custom value if nothing is found and doesn't break when columns move. VLOOKUP only looks right and needs a column number.
03
Which what-if analysis tools does Excel have?
Show answer
Goal Seek (find the input for a target output), Data Tables (see outputs for many inputs) and Scenario Manager (save best, base and worst cases).
04
How would you forecast next quarter's sales in Excel?
Show answer
Use FORECAST.ETS or a trendline on monthly history, check seasonality, compare with a simple moving average and present a range, not a single number.