Hands-On Excel Excel interview tests Accounting Test
Accounting Excel test
10 tasks, 25 minutes. Each one is a small table and a question, like the ones on the Excel test for accounting jobs page, on data you haven't seen.
- No hints and no checking while the clock runs. Move between tasks freely.
- Any formula that gets the right answer counts. Typed-in numbers don't.
- When time runs out, your answers are handed in as they are.
- Your score is free. The full report, with what went wrong on each task and the lesson that teaches it, comes with Pro.
The tasks: SUMIF, COUNTIF with wildcards, Criteria in a cell, Date difference, aging bands, References instead of typed numbers, Numbers stored as text, Fixing #N/A, XLOOKUP or VLOOKUP + IFNA, IFERROR, ROUND, EOMONTH, NETWORKDAYS.
Task 1 of 10: Partial matches with * and ?
This month's ledger lines are below. Revenue accounts are the ones whose code starts with 4. In F2, add up the amounts on revenue accounts. In F3, count the lines whose memo mentions a refund anywhere.
In a condition, * stands for any run of characters and ? for exactly one. "4*" means "starts with 4", "*refund*" means "refund anywhere". Without a * the cell has to match the whole text. Capitals don't matter.
01 Partial matches with * and ? SUMIF, COUNTIF with wildcards Core
Click a cell while typing to insert it, drag to select a range, F4 adds $, Esc cancels.
Tap a cell while writing a formula to insert it, or slide across cells for a range. The strip above the keyboard has = ( ) : , $.