How we grade your Excel test and exercises

Exercises are graded in your browser the moment you press Check, and test tasks on our server by the same rules when you finish the test, so a test score can only come from the work in your sheet. The grader reads the result in your answer cells first, then the formula behind it. This page lists exactly what earns full, half and zero credit, and what the feedback says in each case.

Credit at a glance

  • The right value, produced by a formula

    Correct1

  • The right value, typed in by hand where the task requires a formula

    Partly right0.5

  • The right value, but not with the function the task names

    Partly right0.5

  • The right value, with the answer hard-coded inside the formula

    Partly right0.5

  • A formula that works for this data but breaks when an input cell changes

    Partly right0.5

  • A range with half or more of its cells correct

    Partly right0.5

  • A range with fewer than half of its cells correct

    Not yet0

  • A wrong value or an empty answer cell, with nothing else right

    Not yet0

Do I have to use a specific function?

No, unless the task says so. By default we compare the value in your answer cells with the expected value; the text of your formula is not graded. SUMIFS, SUMPRODUCT, a helper column or INDEX with MATCH all count when the result is right. Only when a task explicitly says “use XLOOKUP” or “use SUMIFS”, to train you for a vendor’s test, does the function matter. Then the right value with another function earns half credit and a note naming the function the task asked for.

What if I type the right number instead of a formula?

You earn half credit for that cell, and the feedback says so. Hiring simulations score it the same way, because a typed number stops being right the moment the data changes.

Partly right

Correct result, but missing formula: B8 has the right value, but it is typed in as a number. This task requires a formula — try SUM.

What counts as a hidden constant?

A formula that contains the expected answer as a literal, such as =1900 or =B2+1850, is a typed number in disguise. The grader scans the formula text for the expected value and caps the cell at half credit, with a note to compute it from the data instead.

Partly right

B8 hard-codes 1,850 in the formula. Compute it from the data so the result updates when the numbers change.

Why does the grader change my input cells?

For tasks marked as sensitive to it, the grader copies your workbook, changes an input such as a rate or a criteria cell, recalculates, and checks that your answer follows. Your own sheet is never touched. A formula that was right only by coincidence, usually a relative reference that should have been locked with $, is capped at half credit and told which cell broke it.

Partly right

D5 works for this data but breaks when B1 changes: it shows 1,240 instead of 1,364 — lock the reference with $, widen the range or check the comparison at the boundary (> or >=).

How exact does the value have to be?

Numbers must match within a small absolute tolerance, 0.000001 by default; percentage tasks allow 0.0001 and date tasks allow none. Text is compared after trimming spaces and, unless a task says otherwise, without regard to case, so “west” and “West ” both match. TRUE and FALSE also match their numeric equivalents.

How is partial credit calculated for ranges?

When the answer is a column or a block of cells, the grader counts how many are right. All of them earn full credit, half or more earn half credit, fewer than half earn nothing. The feedback names the first wrong cell with its value and the expected one, so you know where to look.

Partly right

D2:D49: 44 of 48 cells correct. First wrong cell: D31 (980 vs 1,078).

How are multiple-choice questions scored?

One point for the right option, zero otherwise. On select-all-that-apply questions the point requires exactly the right set of options, the way the discontinued Indeed assessment scored them. Explanations of each option are part of Pro.

How are formatting and sheet tasks graded?

Number formats are compared after normalising the format code, so $#,##0.00 and the currency preset match. Frozen rows, merged cells, filters, sorting, conditional formatting and data validation are read from the state of the sheet, not from a screenshot or a recording of your keystrokes.

Not yet

Row 1 is not frozen (found 0 frozen rows). Use View → Freeze → Freeze first row.

What does the feedback look like?

Every line names a cell, the value it shows, the value it should show and, when the grader can tell, the cause: a range that stops too early, a column index that returns the wrong field, a criteria cell that does not match the data, a reference that moved when you filled down, or text that only looks like a number. The grader is never silent: an empty answer cell gets a line too.

Empty

B8 is still empty. Click it and enter a formula that starts with =.

Questions about scores

Do hints or showing the solution change my score?

Your score, the share of checks you got right, is never affected. Points are: each hint costs 5 of an exercise’s points, and an attempt after “Show solution” earns none. The next exercise starts fresh.

Is the test graded the same way as the exercises?

Yes. The same grader with the same credit rules and tolerances grades both: exercises in your browser, the test on our server once you finish. In the test you see your score and which tasks you missed right away; the full explanation of each miss is part of Pro.

What score do I need to pass the Excel test?

Beginner results fall into five bands: Expert from 93 percent, Highly proficient from 80, Proficient from 65, Familiar from 50, and Needs practice below that. The Intermediate test shows an 80 percent pass line, the convention of most hiring simulations. The Expert test is reported on a 1 to 1000 scale with 700 to pass, a linear estimate of the MOS scale. These are our cutoffs; vendors never publish theirs.

Can the grader be wrong?

Expected cell values are computed from the dataset itself, never typed in by hand, and every exercise is replayed in the spreadsheet engine before it is published; the keys of multiple-choice questions are written by hand. If a result still looks wrong, the worked solution for every exercise is one click away, so you can compare it with your own formula.

Try it in a real spreadsheet

Free, no account and nothing to install.