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
- Receivables: total outstanding, the balance for one customer with SUMIFS, and the share collected.
- Ageing: counting invoices over 60 days and putting an invoice into 0-30, 31-60 or 60+ buckets with nested IF.
- Tax: a GST-inclusive price rounded to the nearest rupee with ROUND.
- Lookups and reconciliation: VLOOKUP an invoice amount and count bank lines that don't match the books.
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.