Excel Test for Accountants

10 questions · 15 minutes · Receivables, tax and reconciliation

Accounting and finance-ops interviews test whether you can work an invoice list quickly: what's outstanding, who owes it, how old it is, and whether the bank matches the books. Type a formula in the highlighted cell and press Enter.

Other tests: general practice test · data analyst · finance · accountant · MIS executive · Indeed-style · Kenexa-style · SHL-style · TestGorilla-style · fix the spreadsheet

What the accountant Excel test covers

Brush up with the SUMIFS practice, the IF function practice and the ROUND guide.

Frequently asked questions

What Excel skills do accountants need for interviews?

SUMIF and SUMIFS by customer or account, VLOOKUP or XLOOKUP, IF for ageing and status, ROUND for tax, pivot tables for summaries, and comparing two lists for reconciliation.

How do I make an ageing report in Excel?

Add a bucket column with a nested IF on days overdue, for example IF(days>60,"60+",IF(days>30,"31-60","0-30")), then summarise the amounts per bucket with SUMIF or a pivot table.

How do I reconcile two columns in Excel?

Compare them row by row. A formula like SUMPRODUCT(--(B2:B100<>C2:C100)) counts mismatches, and conditional formatting can highlight them.

Is this Excel test free?

Yes. It's free with no sign-up, timed, and graded on a live sheet with model answers.