Excel test for accounting jobs

What the test looks like

There is no single accounting Excel test. The formats you are likely to meet:

• A timed online test. Multiple-choice questions and small spreadsheet tasks with a clock, often from a testing company and shared across many roles.
• A practical file. A trial balance, a ledger extract or a bank statement, with questions like "total the expenses by account" or "which payments are unmatched".
• A live task. You share your screen, and someone asks you to reconcile two short lists and explain how you did it.

The data is usually exported from somewhere else, and that is the point: amounts stored as text, codes with a trailing space, an invoice that appears on one list and not the other. A total that is quietly too low is the mistake the test is built to catch.

How to prepare

• Distrust a total from an export. If SUM seems low, look for numbers stored as text (often left-aligned, sometimes with a green triangle). Practise the fix.
• Reconcile with a count, not by eye. COUNTIF each invoice against the bank list and flag the zeros. It works on ten rows and on ten thousand.
• Clean codes before you look them up. A trailing space or a number stored as text makes an exact lookup miss. TRIM and VALUE fix most of it. Find four causes of #N/A.
• Keep the tax rate in one cell. Lock it with $ so filling down doesn't move it, and a rate change is one edit.
• Round where the business rounds. If invoices are rounded line by line, round each line with ROUND(…, 2); formatting alone only changes what you see.
• Tie it back. Check your total against the control total in the file, if there is one. Say in your answer that you did.

Other Excel tests

Excel test for data analysts, Excel test for finance 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 an accounting Excel test cover?

Usually SUMIF and SUMIFS, lookups and why they return #N/A, reconciling two lists, fixing numbers stored as text, absolute references for rates, rounding, and date differences for overdue invoices. Some tests add pivot tables. The mix depends on the employer.

How do I reconcile two lists in Excel?

Count each item of one list in the other with COUNTIF, then flag the ones that return 0: =IF(COUNTIF($E$2:$E$8,A2)>0,"Paid","Missing"). XLOOKUP or MATCH with a not-found check does the same job.

Why does SUM ignore some numbers?

They are stored as text, which often happens with data pasted from a bank or accounting system. SUM skips text. Convert them with VALUE, multiply by 1, or use SUMPRODUCT(range*1).

Do accounting Excel tests include pivot tables?

Some do, as a quick way to total a ledger by account or month. It is worth knowing how to build the same totals with SUMIFS too, since a formula updates with the data.

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 accounting 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.