Cellwise Start free

Cellwise Hire · Financial analysis preset

Excel test for accountants

Candidates work in a monthly P&L the way an accountant does at month-end: operating profit, variance to budget, growth on last year, year-to-date figures through a month-end date in a cell, and margins that survive a month with no revenue. Then they review a colleague's workbook and fix what is broken. Every answer is checked by what it calculates, on the sheet they see and on hidden versions of it.

Create a free accountant testSee a sample task

Free for your first 3 candidates. The Financial analysis preset is preselected for you.

The test at a glance

Workbooks
Monthly P&L + Rep bonus sheet
Tasks
8 hands-on tasks at the level you pick
Levels
Basic, Intermediate or Advanced
Time
You choose; 20 to 40 minutes suits most
Grading
By result, on the visible sheet and 2 hidden versions

Good for: Staff accountants, Senior accountants, General ledger and reporting accountants, Accounting managers who review month-end files.

What accountants actually do in Excel

The ledger lives in the accounting system. The month-end pack usually does not. An accountant exports the P&L and builds the schedule that explains it: actual against budget, this month against the same month last year, year to date through the month just closed. When a line moves, they are the one asked why.

Most of their spreadsheets were started by someone else. Rolling last month's file forward and checking that every formula still covers the right rows is part of the close. So is spotting the total that stops one row short before the controller does.

What the test checks

The Financial analysis preset uses two workbooks: Monthly P&L (a company's monthly profit and loss for January to October: revenue, the revenue budget, cost of sales, operating expenses and revenue in the same month last year) and Rep bonus sheet (a quarterly sales and bonus sheet a colleague built. Several of its formulas are broken: find what is wrong and fix them). Here is what that covers for accountants, with the real task names and the level each one appears at.

Profit and variance, with the right sign

Operating profit down the column, variance as actual minus budget so a positive number means revenue came in ahead, and a count of months over budget where a month exactly on budget does not count. Basic, but it is where sign mistakes start.

  • Operating profitBasic
  • Variance vs budgetBasic
  • Months over budgetBasic

Variance and growth in percent

Each month's variance as a share of budget, and growth on the same month last year. The divisor is what is being checked: the difference over budget, and this year over last year minus 1.

  • Variance % vs budgetIntermediate
  • Year-over-year growthIntermediate

Year to date through a month-end

A running year-to-date total with a locked start ($B$2:B2), the margin for the whole period as total profit over total revenue rather than an average of monthly margins, and revenue against budget through the month-end date typed in a cell, with SUMIFS and "<="&O1.

  • Year-to-date revenueIntermediate
  • Year-to-date operating marginBasic
  • Year-to-date variance %Advanced

A month with no revenue

The business closed for a refit one month. Monthly margins have to show a blank there, not #DIV/0! and not 0%, because a 0 is included in any average taken later and a blank is skipped. Advanced level.

  • Monthly operating marginAdvanced

Loan payment

A monthly payment from a loan amount, a yearly rate and a term in years: the rate divided by 12, the term times 12, and the sign handled so the payment shows as a positive number. Advanced level.

  • Loan paymentAdvanced

Reviewing a colleague's workbook

The second workbook is a quarterly sales and bonus sheet with broken formulas: a total that misses the last row, a rate cell that is not locked with $, ">" where the rule says "met or beat", SUMIF arguments in the wrong order, #DIV/0! for reps with no target, a COUNTIF that tries to compare two columns, and an average that should skip reps with no sales yet.

  • Fix the totalBasic
  • Fix the bonus columnBasic
  • Fix "Hit target?"Basic
  • Fix the East totalIntermediate
  • Fix the #DIV/0! errorsIntermediate
  • Fix the target countAdvanced
  • Fix the averageAdvanced
Every task in this test, by level
Every task in the Financial analysis preset, by level and workbook
LevelMonthly P&LRep bonus sheet
BasicOperating profit
Variance vs budget
Months over budget
Year-to-date operating margin
Fix the bonus column
Fix the total
Fix "Hit target?"
Fix the average
IntermediateVariance % vs budget
Year-over-year growth
Year-to-date revenue
Next month forecast
Fix the manager lookup
Fix the East total
Fix the #DIV/0! errors
Make the count follow K2
AdvancedMonthly operating margin
Loan payment
Three-month forecast
Year-to-date variance %
Use the rate table
Fix the top rep
Fix the target count
Fix the average

Each test uses one level: four tasks from each workbook.

Which level to choose

A real task from this test

This is one of the tasks in the Financial analysis preset at the Advanced level, on the sheet candidates see. The answers below were run through the same grader that marks real tests: on this sheet, and on two hidden versions with different data and an extra row inserted.

Sample task · Monthly P&L · Advanced

Year-to-date variance % (in O2). Compare revenue with budget for the year to date, counting only the months up to and including the month-end date in O1, as a percentage over or under budget. When O1 changes, the answer has to follow.

RowABCDEFGHIJKL
1Month endingRevenueBudgetCost of salesOperating expensesRevenue last yearOperating profitOperating marginLoan amount$50,000.00
2Jan 31, 2026$84,200.00$80,000.00$33,700.00$38,100.00$76,500.00$12,400.00Annual interest rate6%
3Feb 28, 2026$79,600.00$82,000.00$31,800.00$37,400.00$71,200.00$10,400.00Term (years)5
4Mar 31, 2026$91,300.00$88,000.00$36,500.00$39,200.00$80,100.00$15,600.00Monthly loan payment
5Apr 30, 2026$0.00$45,000.00$0.00$21,500.00$83,900.00-$21,500.00Monthly growth rate2%
6May 31, 2026$95,700.00$92,000.00$38,300.00$40,100.00$86,400.00$17,300.00Months aheadForecast revenue
7Jun 30, 2026$90,400.00$94,000.00$36,200.00$39,900.00$88,800.00$14,300.001
8Jul 31, 2026$86,900.00$90,000.00$34,800.00$39,500.00$84,700.00$12,600.002
9Aug 31, 2026$98,200.00$93,000.00$39,300.00$40,600.00$87,300.00$18,300.003
10Sep 30, 2026$102,500.00$97,000.00$41,000.00$41,800.00$92,600.00$19,700.00
11Oct 31, 2026$99,800.00$100,000.00$39,900.00$41,200.00$95,100.00$18,700.00
Answers to the sample task, what each returns on the visible sheet, and the hidden checks
Formula in O2Sheet they seeHidden checksResult
=SUMIFS(B2:B11,A2:A11,"<="&O1)/SUMIFS(C2:C11,A2:A11,"<="&O1)-1Both totals limited to "<="&O1 -8% right Right on bothSolved
=SUMIFS(B2:B11,A2:A11,"<"&O1)/SUMIFS(C2:C11,A2:A11,"<"&O1)-1"<" instead of "<=" -9% wrongNot needed: already wrongNot solved
=SUM(B2:B11)/SUM(C2:C11)-1Every month on the sheet -4% wrongNot needed: already wrongNot solved
  • =SUMIFS(B2:B11,A2:A11,"<"&O1)/SUMIFS(C2:C11,A2:A11,"<"&O1)-1 O1 holds a month-end date, and the month ending on that date is the one just closed. "<" leaves it out, so the pack shows last month's year to date under this month's heading. The number looks believable, which is why it can get through review.
  • =SUM(B2:B11)/SUM(C2:C11)-1 It ignores O1 completely. It is only right when O1 happens to be the last month in the data, and wrong for every other close.

Grading is by result, so SUMPRODUCT and FILTER versions pass too. The hidden versions use a different month-end date and different figures, so only a formula that really reads O1 passes.

Results calculated by the Cellwise formula engine. The hidden versions stay on our server, so this page shows only whether each answer passed them.

See the screen your accountant candidates work in: try a 3-minute sample test and read the report you would get. No signup.

What the report shows

When a candidate finishes, you get an overall score and every task: solved or not, the exact formula they wrote, the time spent and the number of tries, plain-English notes, and a replay of every edit with the sheet as it looked at each step. For accountants, two things are worth a look:

You can also add 8 multiple-choice knowledge questions at the same level, scored separately. Candidates never see their score.

What this test does not cover

Pricing

Free for your first 3 candidates, no card needed. Then Starter is $79 a month or $790 a year for 25 completed candidates a month, and Agency is $199 a month or $1,990 a year for unlimited candidates. Only candidates who complete a test count.

Founding price: locked for as long as you stay subscribed (first 10 customers)

Create a free accountant testCompare plans

FAQ

What Excel skills does an accountant need?

SUMIFS and SUMPRODUCT for totals by period and account, variance in amount and percent with a consistent sign, year-to-date figures through a month-end date, margins with a divide-by-zero guard, absolute references so a schedule fills down and rolls forward, exact-match lookups, finance functions such as PMT, and the habit of checking an inherited workbook before trusting it.

Which level should I choose for a staff accountant?

Basic suits junior and entry-level staff accountants. Intermediate suits most staff and senior accountants. Choose Advanced for senior accountants and managers who own the close, because the year-to-date-through-a-date, guarded margin and loan payment tasks only appear at that level.

Does it test reconciliations or journal entries?

No. It tests the Excel around them: variance, year to date, margins, a loan payment and fixing broken formulas. If reconciliations are central to the role, add a short matching task in the interview.

How is it different from the financial analyst test?

The tasks are the same Financial analysis preset. This page explains what they show about month-end reporting and review; the financial analyst page explains what they show about forecasting. Pick the level by seniority, not by page.

Is it fair to give accounting candidates an Excel test?

A short test that reflects the real work is a common part of hiring. Give every candidate the same test and time, follow local hiring law, and keep tests job-related.

Related

Looking to learn Excel yourself? Start the free Cellwise course.