Practice tests

Find the test named in your invitation. Each page says what practice exists for that test and links to a free five-item sampler. If the invitation does not name one, use the last page on the list.

Kenexa Prove ItHands-on tasks in a simulated Excel window, Normal User level.
SHLNo SHL-style mock yet. Use the general employment mock and the function guides today.
Robert HalfOffice and accounting Excel tasks in a simulated Excel window.
TestGorillaNo TestGorilla-style mock yet. Use the general employment mock and the function guides today.
CriteriaNo Criteria-style mock yet. Use the general employment mock and the function guides today.
MO-200No MO-200-style mock yet. Use the lessons, function guides and the general mock today.
Interview caseNo interview-case practice yet. Use the lessons, how-to pages and the general mock today.
Not sure which testNot sure which test you have? A mixed mock that covers the common ground.

We name these tests only to describe what we help you prepare for. We are not affiliated with any of these companies, and every practice item is our own.

Excel tests by job role

Not sure which test you will get? Start from the job. Each page lists the skills commonly tested for the role, sample tasks with answers, and a one-week plan.

Excel test for accountantsConditional totals, rounding to the cent, variance flags, lookups into a chart of accounts and a couple of finance functions are the skills accountants are commonly asked to show.
Excel test for data analystsConditional counts and averages, cleaning messy text, medians and ranks, de-duplicating and joining tables are the skills data analysts are commonly asked to show.
Excel test for administrative assistantsTotals and counts, tidy lists, text cleanup, working-day dates and clear formatting are what administrative assistants are commonly asked to show in Excel.
Excel test for bookkeepersRunning balances, matching two lists, totals by date range, categorizing from a vendor list and ageing buckets are the skills bookkeepers are commonly asked to show.
Excel test for financial analystsGrowth rates, weighted averages, discounting, two-way lookups, ranking and period-end dates are the skills financial analysts are commonly asked to show.

More to read: 25 sample questions and answers, the function guides, the how-to guides and the error guides.