Excel Assessment Practice: How to Train for Timed Tests

Knowing the formulas is half of passing an Excel assessment. The other half is doing it under time pressure, in an unfamiliar file, without help. Practise both.

The three formats you'll meet

1. Online multiple choice: "Which formula returns…?" Tests recognition.
2. Simulated Excel: tasks inside a browser-based spreadsheet, checked automatically.
3. A file to complete: an Excel workbook with instructions, reviewed by a person.

Ask the recruiter which format and Excel version to expect.

Practise the way you'll be tested

• Use a timer. Give yourself 2–3 minutes per task.
• Use unfamiliar data. Don't only practise on sheets you built.
• No looking things up. If you need to check syntax, mark the question and review it after.
• Practise reading instructions. "Share of total" vs "percent change", "count" vs "sum".

Start with our basic Excel test questions.

Time management

1. Skim all questions first (1 minute).
2. Do every easy question.
3. Come back to harder ones.
4. Leave 3 minutes to check.

One stuck question shouldn't cost you three easy ones.

A 60-second check for every answer

• Click the last filled cell. Do locked references still point at the right cell?
• Change one input. Does the result move?
• Does the size make sense? A share over 100% or a negative quantity means something's off.

When you're stuck

• Break it into helper columns, then combine.
• Use the Insert Function dialog (Shift+F3) to see argument names.
• If a lookup fails, check for spaces and number/text mismatches. See VLOOKUP not working.

What reviewers notice in file-based tests

• Formulas instead of typed numbers
• Consistent formulas down each column
• Clear labels
• No leftover errors (#N/A, #DIV/0!)

Daily practice beats cramming

Twenty minutes a day for two weeks is better than one long night. Cellio's short lessons fit that rhythm, and its feedback on wrong answers (range too short, missing $, typed number) trains exactly the checks reviewers make.

Frequently asked questions

How can I practise for an Excel assessment?

Do timed practice tests on unfamiliar data, without looking things up, and review every mistake.

What score do I need to pass an Excel test?

It depends on the employer and role. Many set their own threshold.

What if I don't know a function in the test?

Skip it, finish the others, then try breaking the task into simpler steps.

Should I practise in Excel or Google Sheets?

Practise in whichever the test uses. Formulas are mostly identical.