Cellwise Start free

Cellwise Hire · Finance and accounting preset

Excel test for auditors

Candidates re-perform the numbers an auditor checks: due dates and an aging from an invoice list, balances open at a date, invoices inside a period, and the oldest unpaid item. Then they review a workbook someone else built and fix its errors. Every answer is checked by what it calculates, on the sheet they see and on hidden versions of it.

Create a free auditor testSee a sample task

Free for your first 3 candidates. The Finance and accounting preset is preselected for you.

The test at a glance

Workbooks
Invoices + 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: External audit associates and seniors, Internal auditors, Audit and assurance interns, Controls and compliance analysts who test spreadsheets.

What auditors actually do in Excel

Auditors rarely build the numbers. They recompute them. A receivables balance arrives with an aging someone else prepared; the auditor rebuilds it from the invoice list, checks what was still open at the test date, counts what was issued inside the period and asks about the oldest items still unpaid.

The other half is reading spreadsheets other people built. A total that stops one row short, a rate typed into a formula, a lookup without an exact match: the errors that matter are the ones that still return a believable number.

What the test checks

The Finance and accounting preset uses two workbooks: Invoices (invoices sent to clients, with the date issued, payment terms in days, the amount and the date it was paid (blank if not yet)) 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 auditors, with the real task names and the level each one appears at.

Re-performing an aging

Due dates from the issue date plus terms, days past due as of the date in a cell (0 for paid invoices and for invoices not yet due), and each invoice in Paid, Current, 1-30, 31-60 or 60+. The full aging appears at the Advanced level.

  • Due datesBasic
  • Days overdueIntermediate
  • Aging bucketsAdvanced

Balances at a date

Open invoices counted with a blank Paid on cell treated as unpaid, the amount past due as of a date, one client's open balance with the client in a cell, and the unpaid total more than 30 days past due.

  • Unpaid invoicesBasic
  • Amount overdueIntermediate
  • Owed by one clientIntermediate
  • Badly overdue totalAdvanced

Period cutoff

Invoices issued inside one month, which needs a start date and an end date. A single ">=" criterion also picks up the following month, the kind of cutoff error an auditor is there to catch.

  • Issued in OctoberIntermediate

Oldest items and days to pay

The invoice number of the oldest unpaid invoice (the earliest issue date among open items, not the oldest invoice overall) and the average days to pay over paid invoices only. Advanced level.

  • Oldest unpaid invoiceAdvanced
  • Average days to payAdvanced

Reviewing a workbook someone else built

The second workbook is a quarterly sales and bonus sheet with broken formulas: a total that misses the last row, an average divided by a fixed 10, a VLOOKUP without an exact match that returns the wrong manager, a threshold typed into a formula, a MATCH without its match type, and a COUNTIF that tries to compare two columns and returns 0.

  • Fix the totalBasic
  • Fix the averageBasic
  • Fix the manager lookupIntermediate
  • Make the count follow K2Intermediate
  • Fix the top repAdvanced
  • Fix the target countAdvanced
Every task in this test, by level
Every task in the Finance and accounting preset, by level and workbook
LevelInvoicesRep bonus sheet
BasicDue dates
Paid or unpaid
Total billed
Unpaid invoices
Fix the bonus column
Fix the total
Fix "Hit target?"
Fix the average
IntermediateDays overdue
Amount overdue
Owed by one client
Issued in October
Fix the manager lookup
Fix the East total
Fix the #DIV/0! errors
Make the count follow K2
AdvancedAging buckets
Badly overdue total
Oldest unpaid invoice
Average days to pay
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 Finance and accounting preset at the Intermediate 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 · Invoices · Intermediate

Issued in October (in K6). Count the invoices whose issue date falls inside October 2026, from the first of the month to the last.

RowABCDEFGHIJK
1InvoiceClientIssuedTerms (days)AmountPaid onDue dateDays overdueAs ofNov 15, 2026
2INV-1041Harbor DentalSep 8, 202630$1,250.00Oct 2, 2026Oct 8, 2026ClientHarbor Dental
3INV-1042Kline & RoweSep 15, 202645$3,400.00Oct 30, 2026
4INV-1043Bluebird CafeSep 22, 202614$480.00Oct 1, 2026Oct 6, 2026Amount overdue
5INV-1044Harbor DentalOct 1, 202630$1,250.00Oct 31, 2026Unpaid, client in K2
6INV-1045Northgate GymOct 6, 202630$2,150.00Nov 10, 2026Nov 5, 2026Invoices issued in October 2026
7INV-1046Kline & RoweOct 13, 202645$2,900.00Nov 27, 2026
8INV-1047Bluebird CafeOct 20, 202614$515.00Nov 3, 2026
9INV-1048Oak Street VetOct 27, 202630$1,780.00Nov 3, 2026Nov 26, 2026
10INV-1049Northgate GymNov 2, 202630$2,150.00Dec 2, 2026
11INV-1050Oak Street VetNov 9, 202630$960.00Dec 9, 2026
Answers to the sample task, what each returns on the visible sheet, and the hidden checks
Formula in K6Sheet they seeHidden checksResult
=COUNTIFS(C2:C11,">="&DATE(2026,10,1),C2:C11,"<"&DATE(2026,11,1))Both ends of the period 5 right Right on bothSolved
=SUMPRODUCT((MONTH(C2:C11)=10)*(YEAR(C2:C11)=2026))Month and year checked together 5 right Right on bothSolved
=COUNTIF(C2:C11,">="&DATE(2026,10,1))Only a start date 7 wrongNot needed: already wrongNot solved
=5The count typed in 5 right Wrong on new numbersNot solvedRight on the visible data only
  • =COUNTIF(C2:C11,">="&DATE(2026,10,1)) It counts every invoice from October 1 onward, so November's invoices land in October. That is a cutoff error, and the formula looks reasonable enough to survive a quick review.
  • =5 Right on the sheet the candidate sees, because it was counted by eye. The hidden version has different invoices, so it fails there.

Grading is by result, so COUNTIFS with "<="&DATE(2026,10,31) as the end passes too. The hidden version has different invoices and a different mix of months, so only a formula that applies both ends of the period 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 auditor 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 auditors, 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 auditor testCompare plans

FAQ

What Excel skills does an auditor need?

Re-performing calculations: SUMIFS and COUNTIFS with date bounds for cutoff and balances at a date, date arithmetic for due dates and days past due, nested IF or IFS for an aging, exact-match lookups to tie one list to another, and reading formulas well enough to spot a range that stops short, a typed-in number or a lookup without an exact match.

Which level should I choose for audit associates?

Basic suits interns and first-year associates. Intermediate suits most associates and internal auditors, and includes the cutoff and balance-at-a-date tasks. Choose Advanced for seniors, because the aging, oldest open item and days-to-pay tasks only appear at that level.

Does the test include audit sampling or analytics software?

No. It is plain Excel formulas on two small workbooks. If sampling matters for the role, ask the candidate to draw a random sample in the interview.

How long should an auditor Excel test take?

Each test has 8 tasks across two workbooks. We suggest 20 minutes for Basic, 30 for Intermediate and 40 for Advanced, plus about 8 minutes if you add the optional knowledge-check questions. You can set anything from 5 to 120 minutes.

Is it fair to give audit 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.