Excel Assessments: What Employers Test and How They Score It

An Excel assessment test checks whether you can answer practical questions from a dataset: totals, conditions, conditional sums, lookups, filters and sometimes a pivot table or case study. Scoring often looks at more than the final number. This guide explains the common formats, what each level usually covers, how answers tend to be checked, and how to prepare, for anyone with an Excel assessment coming up.

What an Excel assessment test looks like#

An Excel assessment test comes in one of a few common formats, and each one rewards slightly different preparation.

Ask the recruiter three things: which format, how long you'll have, and which version of Excel or which platform is used. Functions like XLOOKUP and FILTER need Excel 2021 or Microsoft 365.

What employers commonly test at each level#

Tests are usually pitched at the level the job needs. These groupings are a common pattern, not a standard.

Questions rarely name the function. "What did the West region sell?" means SUMIF or SUMIFS; "Who made the biggest sale?" means MAX plus a lookup. Recognising which tool fits is part of what's being tested.

How Excel assessments are often scored#

Scoring varies by employer and platform, but these checks are common:

• Is the value correct? The basic check, cell by cell.
• Is it a formula? Some graders look inside the cell. A typed 10000 may get no credit even if it's right.
• Does it update? Some tests change an input, such as the region in a criteria cell, and check that your answer follows. Formulas that point at cells pass; hardcoded values fail.
• Time. Timed tests may score how many questions you finish, so speed matters.
• Layout and clarity. In take-home tasks, a reviewer may judge whether the file is easy to follow: labelled answers, consistent formats, untouched raw data.

Whether partial answers earn credit depends on the test, so finishing more questions is usually the safer strategy.

Worked example: an intermediate test question#

Take seven orders with the region in column B, units in C and revenue in D, rows 2 to 8, and "West" typed in H1.

"What was the revenue from orders in the region in H1 with 5 or more units?"

=SUMIFS(D2:D8,B2:B8,H1,C2:C8,">=5")

SUMIFS adds D where B matches H1 and C is at least 5: 3000 + 2500 + 4500 = 10000. The sum range comes first. Change H1 to East and the answer becomes 3500, which is exactly the kind of check a grader might run. See the SUMIFS function guide.

"Did that region hit its 10,000 target?" With the answer in H2:

=IF(H2>=10000,"Target met","Below target")

returns Target met. Point at the cell holding the target if there is one, rather than typing 10000. The IF function guide covers nested and combined conditions.

What a case study assessment involves#

A case study links several questions on one dataset, the way a real analyst task would. In a real estate case, you might calculate price per square foot (=E2/D2), the average price in one area with AVERAGEIFS, the number of 3-bedroom listings there with COUNTIFS, a filtered list of good-value homes with FILTER, and the priciest listing with XLOOKUP and MAXIFS.

Case studies also test judgment. For example, the average of each listing's price per square foot is not the same as total price divided by total square feet, and you may be asked to explain why: the first weights every listing equally, the second weights big homes more.

How to prepare for an Excel assessment#

1. Find out the format, time limit and Excel version.
2. Practise the level the job needs using the table above.
3. Do a timed run on a dataset you haven't seen. The 10 Excel practice tasks to do before your test give you a ready-made set.
4. Speed up the mechanics with the shortcuts that make you look fast in a test, like Ctrl+D (Mac: ⌘D) to fill down.
5. Plan your study time honestly: see how long it takes to learn Excel for a job.

On the day, read every question first, answer the quick ones, skip anything that stalls you for more than a couple of minutes, and use spare time to check answers against the data.

Practise it#

Rehearse with realistic, unlabelled questions. The sales report interview drill covers revenue, totals by region and month, the top order and its rep, and a % of total column. The real estate case study works through averages, counts, a filtered list and the ratio question above. Try the SUMIFS question from this guide in the exercise below first.