Spreadsheet Practice

Accounting Excel test: skills to practice and a 14-day plan

Accounting roles test whether you can summarize, reconcile and clean data quickly without breaking formulas. Expect SUMIFS-style summaries, lookups with missing values, and month-end date logic.

What employers usually test

SkillFunctionsPractice
Conditional totalsSUMIF, SUMIFSLesson 7 Free
Lookups with gapsVLOOKUP, IFERRORLesson 15 Pro
Month-end datesEOMONTH, EDATELesson 24 Pro
Cleaning imported dataTRIM, SUBSTITUTELesson 20 Pro
Rounding moneyROUNDLesson 33 Pro
Locked references$ signsLesson 3 Free

Take the accountant timed test

Five tasks in a live grid, easiest first. Graded instantly, with a lesson for every gap.

  • 5 tasks in a live grid, easiest first. Graded the moment you submit
  • About 10 minutes. Skip anything you don't know
  • Your level and the exact lessons for your gaps, right away. No signup
  • Aced it? Keep going with a bonus round of harder, interview-style tasks

Try a sample task

From lesson 15, Tiered lookups & IFERROR. Graded instantly.

Unknown SKUs

In C2, look up the unit price for each SKU from E2:F5. If the SKU isn't in the price list, show Check SKU. Fill down to C6.

Your 14-day prep plan

About 30 minutes a day. Free lessons first; Pro lessons are marked.

Questions

Which functions come up most?

Conditional totals (SUMIF and SUMIFS), lookups, and rounding. Expect at least one task where a lookup value is missing and you have to handle the error.

Will I need pivot tables?

Many accounting tests include one. The formula skills here make pivots easier to check, because you can reproduce any pivot total with SUMIFS.

How long should I prepare?

Two weeks at about 30 minutes a day is enough for most screening tests.

Prep for other roles

Updated Checked by running: every exercise answer on this page was graded by our formula engine on .