Free · About 10 minutes · No download
Free Excel practice test
Nine real spreadsheet tasks, one for each core skill. You write the actual formula in a live grid — then see a score for every skill, and exactly which one to work on next.
Nine real spreadsheet tasks, one for each core skill. You write the actual formula in a live grid — then see a score for every skill, and exactly which one to work on next.
One task in each of the skill areas employers actually use.
Cell references, relative vs. absolute ($A$1), order of operations.
SUM, ROUND, COUNT/COUNTA, COUNTIF(S), AVERAGEIF.
IF, nested IF, IFS, AND/OR/NOT, IFERROR.
SUMIF, SUMIFS, SUMPRODUCT.
VLOOKUP, XLOOKUP, INDEX/MATCH, HLOOKUP.
LEFT/RIGHT/MID, TRIM, SUBSTITUTE, TEXT, concatenation.
RANK, percentages, weighted averages.
IF inside a lookup, IFERROR around VLOOKUP, nested formulas.
Most "Excel tests" ask you to pick the right answer from a list. Here your formula is evaluated against the spreadsheet — typing the answer as a plain number doesn't count. It's the closest thing to doing the work for real.
Yes. You create a free account so your results are saved — no card needed.
About ten minutes: nine tasks, one in each skill area.
It shows you which skill areas are weakest so you can practise those first — lookups and SUMIFS come up in most interview tests.