Excel test for administrative assistants

What the test looks like

Admin Excel tests are often one part of a wider office skills check. The usual formats:

• A timed online test. Multiple-choice questions plus tasks in a simulated spreadsheet: "total column C", "sort by date", "make the header bold". Some accept only the menu or button the test expects.
• A short file to tidy up. A contact list, a booking sheet or an order log to clean, total and format, sent back by a deadline.
• A task at the interview. A laptop and a few minutes to do something simple while someone watches how you work.

The bar is accuracy and speed on everyday tasks. Using a formula instead of a calculator, and filling it down instead of typing each row, is what shows you know Excel rather than just use it.

How to prepare

• Use formulas for every total. A number worked out on a calculator and typed in can be marked wrong, even when it's right.
• Fill down, don't retype. Write the formula once in the first row and fill it down. Practise fill-down.
• Know the difference between COUNT and COUNTA. COUNT counts numbers only; COUNTA counts anything that isn't empty. Try both.
• Learn a few shortcuts. Selecting to the end of the data, copying, pasting, undo and bold. Timed tests reward people who don't reach for the mouse for everything.
• Check the edge case. If the rule is "50 or more", test what happens at exactly 50. That's where IF formulas go wrong.
• Ask which version. If the test runs in an older Excel, XLOOKUP won't be there. VLOOKUP works everywhere.

Other Excel tests

Excel test for data analysts, Excel test for finance jobs, Excel test for accounting jobs, Basic Excel test, Advanced Excel test, Excel quiz. Or start from what Excel interview tests check, with the formats and the test providers.

FAQ

What Excel skills does an administrative assistant test cover?

Usually SUM and AVERAGE, COUNT and COUNTIF, a simple IF, fill-down, basic formatting, sorting and filtering, and often a VLOOKUP. Some tests add splitting or joining names for a mailing list. The mix depends on the employer.

Is an admin Excel test hard?

The tasks are usually basic; the difficulty is doing them accurately with a clock running, sometimes in a simulated Excel that expects one way of doing each step. Practising the basic moves until they are automatic is the best preparation.

Do I need to know VLOOKUP for an admin job?

It comes up often enough to be worth an hour. Know how to look up a value with FALSE as the last argument, and why it returns #N/A.

Will the test include Word or typing too?

It may: Excel is often one section of a wider office skills test. Ask the recruiter what the test covers.

Is this the test employers use?

No. Hands-On Excel is not connected to any employer or testing company. The tasks here practise the skills these tests are built on.

Is the admin practice test free?

Yes. The timed test, the two tasks on this page and every linked challenge are free and need no sign-up. Pro adds the task-by-task report after the test.