SOFTWAREVAARDIGHEDEN

Excel-test voor werving

See how candidates read worksheet examples and apply intermediate Excel knowledge under a short time limit.

10 minuten
15 vragen
Intermediate
Multiple choice
Questions in Engels
Desktop only

Use this test free See the question formats

Het korte antwoord

This Excel skills test checks intermediate Microsoft Excel work: formulas with lookup, conditional, text and date functions, working with data through sorting, filtering, tables and pivot tables, and formatting. Candidates answer 15 single-choice questions about worksheet pictures in 10 minutes on a computer. It suits administration, operations, sales support, finance support, reporting and junior analyst roles.

Wat het meet

Working knowledge of Excel formulas, data tools and formatting, read from worksheet pictures.

Formulas

Covers reading lookup, conditional, text and date functions and determining what a formula returns.

Data

Covers choosing how to sort, filter, use tables and summarize information with pivot tables.

Formatting

Covers conditional formatting, number formats and charts used to make worksheet information clear.

Question formats

Multiple choice

The candidate: Reads a short situation, table or statement and picks the right answer, or every right answer.

You see: Whether the candidate knows the material well enough to apply it, not just recognize it.

15 questions in 10 minutes, served one at a time.

Roles this test fits

Roles that work in spreadsheets: administration, operations, sales support, finance support, reporting and junior analyst roles.

What the Excel skills test shows that a resume does not

Formulas they can read, not just list
A resume says "advanced Excel". The test shows whether a candidate can look at a worksheet and predict what a lookup, conditional, text or date formula returns.
How they work with data
Questions on sorting, filtering, tables and pivot tables show whether someone picks the approach that gives a correct, repeatable answer from a real table.
Formatting that helps people read a sheet
Conditional formatting, number formats and charts decide whether a report is read correctly. The Formatting result shows how well a candidate handles them.
Evidence you can compare
Every candidate answers the same kind of questions in the same 10 minutes, so you compare like with like instead of comparing how confidently two resumes describe Excel.

What you get for each candidate

Example report (fictional data)Microsoft Excel - gemiddeld niveau

79%Percentile 64. Benchmark: HireValid candidates, n = 2.285

Formulas90%

Data63%

Formatting84%

Integrity ScoreHoge betrouwbaarheid

Stayed on the test tab throughout
No pasted answers
Answered at a steady pace

Scores, profiles and integrity signals are evidence for you to review alongside an interview, never an automatic decision.

Use this test free

How the Excel skills test resists AI help

Each candidate gets a different set of questions drawn from large pools, and the order of questions and answer options is shuffled. Questions arrive one at a time from the server, candidates cannot go back to an earlier question, and the answer keys never reach the browser. Timing runs on the server, so a reload returns the same question with the time left.

Question text cannot be copied, and a blocked copy is recorded. Signals such as time away from the tab, pastes and very fast answers are summarized in an Integrity Score with a timeline for the employer to review. The score describes what was observed; it never decides anything about the candidate.

Hoe we fraude met AI tegengaan · Integrity signals

Use the score with a work sample and a structured interview

Read the result as one piece of evidence, never on its own. Look at the three sub-skill results as well as the total: a reporting role leans on Formulas and Data, while a role that builds dashboards for managers also needs Formatting.

The best work sample for an intermediate Excel role is a small, messy dataset with a clear question. Give 100 rows of sales with a few missing values and duplicates, and ask for revenue by week and a short note on how the gaps were handled. It mirrors the work and shows whether the candidate checks their data or just produces a number. Then ask every candidate the same questions in a structured interview.

Interview questions to ask after the Excel skills test

What checks do you make before you share a surprising result from a spreadsheet?
Listen for reconciling totals against the source, looking for duplicates and missing values, and re-reading the formulas behind the number.
How do you make sure a lookup formula returns the right row?
Strong answers mention asking for an exact match, checking the lookup column for duplicates and handling the case where no match is found.
You need totals by region from a large table that is updated every week. How would you set that up?
Listen for a table or pivot table that can be refreshed, rather than totals typed in by hand, and for a check that new rows are included.
Tell me about a report you formatted so that someone else could read it quickly. What choices did you make?
Listen for number formats that match the data, conditional formatting used sparingly to point at what matters, and a chart chosen for the question being asked.

Understand scoring and benchmarks

Who should use this Excel skills test?

Use this Excel skills test for roles that turn raw data into answers in spreadsheets: administrators keeping trackers, operations coordinators reconciling orders, sales support staff preparing pipeline reports, finance support staff summarizing spend, and junior analysts building weekly reports. A junior data analyst or an office administrator are typical examples.

It is pitched at intermediate, everyday use. The questions cover formulas (lookup, conditional, text and date functions), working with data (sorting, filtering, tables and pivot tables) and formatting (conditional formatting, number formats and charts). Each question shows the worksheet it asks about, so nothing depends on remembering where a button sits on a particular screen, and functions work as they do in current versions of Excel with US settings.

If the role needs deeper modeling or analysis, the test library also holds more advanced Excel tests. If the job rarely touches a spreadsheet, leave the Excel test out and test the skill the job does depend on.

It is an intermediate Excel test: candidates who know only basic entry and formatting will find the lookup, conditional and pivot table questions demanding, which is the point.

Common lookup and summary errors to probe in the interview

Intermediate spreadsheets fail in quieter ways than basic ones. The formulas run, the numbers look plausible, and the error only surfaces when someone checks. These are the traps worth asking about in the work sample and the interview.

Approximate matches by accident. A lookup left on approximate match can return a wrong row from unsorted data instead of an error.
Duplicates in the lookup column. A lookup returns the first match only, so a duplicated product code quietly hides the second record.
Mismatched ranges in conditional totals. The ranges being tested and the range being added must cover the same rows, or the total is wrong without any warning.
Stale pivot tables. A pivot table built last week does not include this week's rows until it is refreshed.
Numbers that only look right. A number format that hides decimals, or dates read the wrong way round, can make a correct sheet read wrongly.

Candidates who know these traps check their own work before sharing it, which is the habit an intermediate spreadsheet role needs most.

An Excel skills test or a course on the resume?

Many candidates list an Excel course or exam on their resume. That shows effort and some baseline knowledge at one point in time. A short Excel assessment test shows what someone can do today, with everyday worksheet questions, under the same conditions as every other candidate.

For screening, the test is fairer and more current. Many capable people learned Excel on the job and never sat an exam, and spreadsheet skills fade without use. Asking everyone to take the same test gives you comparable evidence whatever route each person took.

Treat a course on the resume as a pleasant extra rather than a requirement, unless the role genuinely needs one. Then use the test result, a short work sample and a structured interview together, so no single document or number carries the decision.

Give candidates a short chance to try the worksheet format

Candidates can use the 4-question practice set, which takes 4 minutes, before the assessment. It lets them get used to reading worksheet pictures and choosing an answer before the timed questions start, and practice answers do not count toward the score. Mention the practice set when you invite candidates, alongside the 10-minute assessment and the requirement to use a computer.

Fairness and accommodations

Worksheets use everyday business data with no money symbols, dates written so they cannot be misread, and functions as they work in current versions of Excel with US settings. Each question shows the worksheet it asks about, so nothing depends on remembering a particular screen, and the test asks for a computer so the worksheets are large enough to read.

You can give any candidate extra time as an accommodation. Results are evidence for a person to review, never an automatic decision.

Provisional: reliability is reported once 200 candidates have completed it.

Lees hoe we met eerlijkheid omgaan

Test details

Worksheet questions on everyday Microsoft Excel work at an intermediate level: formulas (lookup, conditional, text and date functions), working with data (sorting, filtering, tables and pivot tables), and formatting (conditional formatting, number formats and charts). Each question shows a worksheet and asks what a formula returns, what an action does, or which approach is right.

Questions are in English.
No aids are needed.
Each question is answered once, in order, with no going back.
4 practice questions, 4 minutes, before the timed test.
Taken on a desktop or laptop computer.

Microsoft Excel is a trademark of its owner. HireValid is not affiliated with or endorsed by it.

Veelgestelde vragen

What is on the Microsoft Excel Intermediate test?+

Fifteen single-choice questions in 10 minutes, in three areas: formulas (lookup, conditional, text and date functions), data (sorting, filtering, tables and pivot tables) and formatting (conditional formatting, number formats and charts). Each question shows a worksheet and asks what a formula returns, what an action does, or which approach is right.

Do candidates need Excel installed to take the Excel skills test?+

No. Each question shows a picture of the worksheet it asks about, and candidates choose an answer on screen, so nothing needs to be installed. If you add a hands-on work sample later, candidates will need spreadsheet software for that step.

Can candidates take the Excel Intermediate test on a phone?+

No. The test asks for a computer, so the worksheets are large enough to read. Say so in the invitation, and offer another arrangement to any candidate who does not have access to a desktop or laptop, so nobody is disadvantaged by their device.

Which version of Excel does the Excel skills test assume?+

Functions work as they do in current versions of Excel with US settings. Worksheets use everyday business data with no money symbols and dates written so they cannot be misread, and each question shows the worksheet it asks about, so nothing depends on remembering a particular screen.

Is the Excel Intermediate test enough for a junior data analyst role?+

It covers the spreadsheet side of the job: formulas, data tools and formatting. Many analyst roles also pull data from a database, so consider adding a SQL test from the library, and use a short work sample with a real dataset to see how the candidate checks their numbers.

Can candidates go back to an earlier question on the Excel skills test?+

No. Questions are served one at a time and candidates cannot return to an earlier one, so each answer is final when it is given. Tell candidates this in the invitation so the format does not surprise anyone.

What practice is available before the Microsoft Excel Intermediate test?+

Candidates can try 4 practice questions in 4 minutes before starting the 15-question assessment. The practice set introduces the format: a worksheet picture, one question at a time, and a single answer to choose. Practice answers do not count toward the score, so candidates can settle in before the timed questions start.

What does the Microsoft Excel Intermediate test show about pivot table skills?+

The test uses worksheet pictures to assess whether candidates can work with tables and pivot tables as part of spreadsheet data tasks. It also checks formulas such as lookup and conditional functions, plus formatting choices including number formats, conditional formatting and charts. Review those results as evidence to discuss alongside a work sample and interview.