Spreadsheet Practice

Financial analyst Excel test: what's on it and how to prepare

Finance interviews often include a timed Excel task: pull numbers from a table, summarize by segment, and build a small model that still works when the inputs change. Here is what to practice, a sample task, and a 14-day plan.

What employers usually test

SkillFunctionsPractice
Lookups across tablesXLOOKUP, INDEX/MATCHLesson 13 Pro
Totals by segmentSUMIFSLesson 8 Free
Locked references in models$ signsLesson 3 Free
Growth and margins% changeLesson 4 Free
Weighted averagesSUMPRODUCTLesson 35 Pro
Time value of moneyPMT, NPV, IRRLesson 41 Pro
Clean outputsROUNDLesson 33 Pro

Take the financial analyst timed test

Five tasks in a live grid, easiest first. Graded instantly, with a lesson for every gap.

  • 5 tasks in a live grid, easiest first. Graded the moment you submit
  • About 10 minutes. Skip anything you don't know
  • Your level and the exact lessons for your gaps, right away. No signup
  • Aced it? Keep going with a bonus round of harder, interview-style tasks

Try a sample task

From lesson 41, NPV & IRR. Graded instantly.

Net present value

In E4, calculate the project's NPV at the discount rate in E2. Year 0 is an upfront investment.

Your 14-day prep plan

About 30 minutes a day. Free lessons first; Pro lessons are marked.

Questions

Is the test done in Excel or in a browser?

It varies by employer. Some send a workbook to complete; others use an online simulator. Practice both: build formulas from scratch, and read formulas someone else wrote.

What do graders look at besides the answer?

How you got there: one formula filled down instead of typed numbers, locked references, and inputs kept in their own cells so the model can be changed.

How long should I prepare?

About 30 minutes a day for two weeks covers the plan below, including two timed practice runs.

Prep for other roles

Updated Checked by running: every exercise answer on this page was graded by our formula engine on .