A simulated Excel test puts a working copy of a spreadsheet in your browser and gives you one task at a time: format this range, write a formula here, rename that sheet. SHL's Excel 365 test has 30 tasks in 35 minutes and its Essentials version 20 tasks in 25 minutes; you get one attempt per task, the result is graded on the state of the sheet, and many keyboard shortcuts do not work. This is the family that staffing agencies and large employers use for administrative and finance-support roles.
The task list reads like the SHL sub-scores: formatting, formulas, data and worksheet management, charts, printing and workbook protection. Tasks are stated as actions on named cells and sheets, so you need to recognise the feature from its description rather than from a screenshot.
Font and fill, alignment, wrap text, merge and center, borders, number and date formats, Format Painter, column width. The largest share of tasks in reseller outlines.
SUM, AVERAGE, MIN, MAX, COUNT, IF, a VLOOKUP, references across sheets, absolute references. Typed once, correctly.
Sort by two columns, apply a filter and read what remains, convert a range to a table, add a drop-down list.
Rename, move and colour sheet tabs, freeze panes, hide columns, insert and delete rows, set a print area or page orientation.
Insert a chart of a given type, change its title, switch rows and columns.
Add a built-in conditional-formatting rule, such as Top 10% or Greater Than.
Protect a sheet, set a password, add a comment, save in another format. Rare but in SHL's outline.
Two things decide the score: knowing where each command lives in the ribbon without searching, and typing formulas right the first time. Both come from doing the tasks, not reading about them.
Work the cell-mechanics exercises with the mouse only: freeze panes, merge and wrap, number and date formats, sort and filter. The grader reads the sheet state exactly as a simulation does.
Type formulas in one go. Do the SUM, AVERAGE and COUNT set, then the absolute-reference set; check each one before pressing Enter, because in the test there is no second attempt.
Practise one lookup and one IF until the argument order is automatic: a typo in a 30-second task is the task lost.
Learn the Home-tab layout of Excel for the web or desktop Excel by heart: alignment group, number group, Format as Table, Conditional Formatting, Insert menu. Simulations mirror it.
Rehearse the clock with the free Level 1 test today and Level 2 when it opens: a visible task list, forward-only navigation and one attempt per task are the same rules.
Level 2 follows this family: 20 tasks in one workbook, a 25-minute clock, task list visible, forward only, one attempt per task.
Simulations grade the sheet when you move on. Candidates lose tasks to a missing bracket or a wrong column letter they would have fixed in real Excel. Read the formula bar before Next.
Ctrl + Shift + Arrow, Ctrl + C and Ctrl + V often do nothing in the simulation. Candidates who rely on them freeze; select with the mouse or Shift + Arrow and use the ribbon buttons.
Testlify's grader lists "Correct result, but missing formula" as a failure reason, and simulations check the cell content, not just what it shows. If the task says calculate, write a formula.
Tasks name an exact cell or range. Formatting B2:B20 when the task says B2:B21, or merging A1:E1 instead of A1:F1, scores zero.
At 60–75 seconds per task, looking for Freeze Panes under Home instead of View costs the task. Know the tab for each command.
No. SHL, eSkill and Criteria run a simulated Excel interface in the browser; Testlify and Vervoe use a live sheet. The simulation looks like Excel but accepts fewer shortcuts and shows only part of the ribbon. TestDome instead asks you to complete a file in your own Excel and upload it.
Yes. Criteria says Mac users are not at a disadvantage; the simulation runs in the browser and uses the mouse for most actions. Practise the ribbon layout rather than Windows-only shortcuts.
You can usually fix it before you press Next; after that the task is closed. Prep sites describe SHL's simulation as not allowing trial and error, so check the cell before moving on.
By tasks completed correctly, with sub-scores by area and, in SHL's case, pace. Employers see a report with the breakdown; there is no published pass mark. A typical employer bar on prep sites is around 70–80%.
Our free Level 2 test reproduces the rules: 20 tasks in two business workbooks, one 25-minute clock, the task list visible, forward only, one attempt per task, with an 80% pass line and five sub-scores.
TestGorilla-style, iMocha, Adaface, Mettl, Testlify
10–30 minutes 10–30 questions
One question per screen with a clock, usually no going back. The first filter after the CV.
À quoi vous attendre lors de ce testMicrosoft Office Specialist exams MO-210 and MO-211 (Certiport)
50 minutes 23–37 tasks
Several projects in live Excel, each a workbook with 4–7 tasks. Scored 1–1000, 700 to pass.
À quoi vous attendre lors de ce testWritten by the hiring team; sometimes run live over screen share
20–60 minutes One workbook
Raw data on two or three sheets, a list of questions, your own Excel. Join, aggregate, clean, summarize, explain.
À quoi vous attendre lors de ce testGratuit, sans compte et sans rien installer.
Facts checked on November 15, 2026 against SHL's business-skills catalog and reseller specification sheets for Microsoft Excel 365 and Excel 365 Essentials, Criteria's Microsoft 365 test documentation, eSkill's Excel simulation page (February 2025), Testlify's test-case documentation and prep-site descriptions of the SHL and Kenexa formats (2025).
Excel est une marque commerciale du groupe de sociétés Microsoft. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria et les autres marques sont la propriété de leurs détenteurs respectifs. GridBelt est indépendant : il n’est affilié à aucun d’entre eux, et aucun d’entre eux ne le cautionne ni ne le sponsorise.