Excel test for finance jobs

What the test looks like

There is no standard finance Excel test. What you get depends on the employer and the level of the role:

• A timed online test. Multiple-choice questions and small tasks in a spreadsheet, with a clock. Often bought from a testing company and used for many roles, not only finance.
• A case or take-home file. A data dump or a small model, a few questions, and sometimes a short written answer about what the numbers mean.
• A modelling test. For some analyst roles: build a small forecast from a page of assumptions in a set time. This page covers the Excel moves underneath it; it doesn't teach financial modelling.

The questions sound like the job: growth on last year, the cost per unit, the budget split by department, which line moved most. Whoever marks it will usually click your cells. A rate typed into twenty formulas, instead of kept in one input cell, is the classic thing they look for.

How to prepare

• Keep every input in one cell. Rates, prices and assumptions go in their own cells, and formulas point at them with $. Then a change of rate is one edit. Find the typed-in rates.
• Get the direction of a change right. Percent change is (new − old) / old, divided by the old value. Format the cell as a percent rather than multiplying by 100.
• Know when VLOOKUP should use TRUE. For bands (commission tiers, tax brackets) the table is sorted from low to high and the last argument is TRUE. For IDs it is always FALSE.
• Total by two conditions without a pivot table. SUMIFS by month and category is the backbone of most variance questions, and it updates when the data does.
• Check that the parts add up. Shares of a total should add to 100%, and monthly totals to the year. It takes a few seconds and catches a range that stops one row short.
• Practise against the clock. Do a set of tasks in a row with a timer running, then look at what slowed you down.

Other Excel tests

Excel test for data analysts, Excel test for accounting jobs, Excel test for administrative assistants, Basic Excel test, Advanced Excel test, Excel quiz. Or start from what Excel interview tests check, with the formats and the test providers.

FAQ

What Excel skills does a finance Excel test cover?

Usually percent change and percent of total, references locked with $, SUMIFS by month or category, lookups including approximate match for bands, rounding, and some date functions. Modelling roles may add a longer case. The mix depends on the employer.

Do finance Excel tests include financial modelling?

Some do, mostly for analyst roles in banking, corporate finance and FP&A. Many others are shorter tests of formulas and references. Ask the recruiter what format to expect; it is a normal question.

How do I calculate percent change in Excel?

Subtract the old value from the new one and divide by the old one: =(C2-B2)/B2. Then format the cell as a percent. A negative result is a fall.

When should VLOOKUP use TRUE instead of FALSE?

Use TRUE (approximate match) to find the band a number falls into, such as a commission tier, with the table sorted from low to high. Use FALSE for exact matches like IDs and names.

Is this the test employers use?

No. Hands-On Excel is not connected to any employer or testing company. The tasks here practise the skills these tests are built on.

Is the finance practice test free?

Yes. The timed test, the two tasks on this page and every linked challenge are free and need no sign-up. Pro adds the task-by-task report after the test.