Aller au contenu
GridBelt
  • Test Excel
  • Exercices
  • Programmes
  • Tarifs
Se connecter
Commencer le test gratuit
  • Test Excel
  • Exercices
  • Programmes
  • Tarifs
Se connecterCréer un compte
Commencer le test gratuit
GridBelt

Entraînez-vous sur Excel dans votre navigateur.

Test Excel

  • Niveau 1 : Débutant
  • Niveau 2 : Intermédiaire
  • Niveau 3 : Expert
  • Test Excel en 7 jours
  • Classement
  • Test Excel en entretien d’embauche
  • Évaluation Excel d’Indeed

Exercices

  • Tous les exercices
  • Programmes
  • Pour débutants

Guides

  • Formules Excel
  • Raccourcis Excel

Entreprise

  • À propos
  • Tarifs
  • Comment nous corrigeons

© GridBelt. Tous droits réservés.

  • Politique de confidentialité
  • Conditions d’utilisation
  • Politique de remboursement

Excel est une marque commerciale de Microsoft Corporation. Indeed, TestGorilla, SHL et les autres marques sont la propriété de leurs détenteurs respectifs. GridBelt est un site d’entraînement indépendant ; il n’est affilié ni à Microsoft, ni à TestGorilla, ni à SHL, ni à Indeed, et n’est ni cautionné ni sponsorisé par ces sociétés.

  1. Test Excel

What to Expect on the MOS Excel Exam (MO-210, MO-211): 50 Minutes, 700 to Pass

The Microsoft Office Specialist exams are the one Excel test with a published format: 50 minutes in live Excel, 33–37 tasks on the Associate exam (MO-210, or MO-200 for Office 2019) and 23–27 on the Expert exam (MO-211, or MO-201), grouped into projects that share a workbook, scored on a 1–1000 scale with 700 to pass. The result appears on screen as soon as you finish. The certificate is recognized by many employers and schools; it is rarely required for a job.

Le format en bref

Tasks
Associate (MO-200, MO-210): 33–37 tasks. Expert (MO-201, MO-211): 23–27 tasks. Tasks are grouped into projects, each a workbook with several tasks; third-party guides describe 5–7 projects, which Certiport does not publish.
Time
50 minutes of exam time (60 minutes of seat time). About 80–90 seconds per task on the Associate exam, 110–130 on Expert. No breaks.
Environment
"Live in the application": you work in the real Excel, proctored, at a test center or online. No Microsoft Learn access during the exam.
Navigation
Move freely between tasks inside a project and mark tasks for review; tasks in one project build on the same workbook.
Scoring
A scaled score from 1 to 1000; 700 or more passes. The scale is not percent correct, so 700 is not 70% of the tasks. The score and pass or fail show immediately.
Weights (MO-211 Expert)
Manage workbook options and settings 10–15%; manage and format data 30–35%; create advanced formulas and macros 25–30%; manage advanced charts and tables 25–30%.
Weights (MO-200 Associate)
Manage worksheets and workbooks 10–15%; manage data cells and ranges 20–25%; manage tables and table data 15–20%; perform operations with formulas and functions 20–25%; manage charts 20–25%.
Retakes and cost
Wait 24 hours after a first fail, 48 hours after each later fail, no annual cap. US test centers list vouchers at about $104 without a retake and $120 with one, plus a proctoring fee; prices vary by country.

Qu’est-ce qui est demandé ?

The objective domains are published by Microsoft. Tasks describe the outcome, not the function: the exam avoids function names, so "display the text in column A in capital letters" is an UPPER task and "return the price for the product code in B2" is a lookup task.

  • Worksheets and workbooks (Associate)

    Import a .txt or .csv, freeze panes, page setup and print areas, headers and footers, named ranges, display formulas, inspect a workbook before sharing.

    S’entraîner : Freeze the header row of a long export
  • Cells and ranges (Associate)

    Paste special, Auto Fill, merge and wrap, number formats, cell styles, Format Painter, sparklines, built-in conditional formatting.

    S’entraîner : Merge and wrap
  • Tables (Associate)

    Create a table from a range, add a total row, sort by multiple columns, filter.

    S’entraîner : Sort and filter
  • Charts (Associate)

    Create and modify charts, switch rows and columns, add alt text.

    S’entraîner : Charts
  • Formulas (Associate)

    Relative, absolute and mixed references; AVERAGE, MAX, MIN, SUM; COUNT, COUNTA, COUNTBLANK; IF; RIGHT, LEFT, MID; UPPER, LOWER, LEN; CONCAT and TEXTJOIN.

    S’entraîner : SUM, AVERAGE and COUNT
  • Advanced formulas (Expert)

    Nested IF, IFS, SWITCH; SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, MINIFS; VLOOKUP, HLOOKUP, MATCH, INDEX and XLOOKUP; LET, FILTER and SORTBY; TODAY, WEEKDAY, WORKDAY; PMT, NPER; Goal Seek; simple macros.

    S’entraîner : SUMIF and SUMIFS
  • Data (Expert)

    Custom number formats, data validation, remove duplicates, subtotals, formula-based conditional formatting.

    S’entraîner : Drop-down lists
  • PivotTables and advanced charts (Expert)

    PivotTables with slicers, grouping and calculated fields; PivotCharts; combo, waterfall and histogram charts.

    S’entraîner : Pivot tables

Comment se préparer ?

The exam rewards breadth and exactness: every domain appears, and a task passes only when the result matches, including names, ranges and formats. Prepare by domain weight, in Excel itself.

  1. 1

    Print the objective domain for your exam (MO-210 or MO-211) and tick each line only after doing it in Excel once. Microsoft's outlines are the whole syllabus.

  2. 2

    Associate: work the basics track end to end, then the text and date functions. The Associate exam stops at IF, COUNT functions, text functions and CONCAT or TEXTJOIN.

    S’entraîner : SUM, AVERAGE and COUNT
  3. 3

    Expert: do the logic and lookups tracks, then the dynamic-array exercises (FILTER, SORTBY, UNIQUE). Expert formulas are 25–30% of the exam.

    S’entraîner : INDEX and MATCH
  4. 4

    Expert: advanced charts and tables are another 25–30%. Work the PivotTable and chart exercises for the decisions (which field goes where, grouping by months, Show Values As, a secondary axis), then build the same PivotTables and charts in Excel itself: the practice grid has neither.

    S’entraîner : Pivot tables
  5. 5

    Practise reading descriptors: cover the function name in each exercise title and work from the task text alone, the way the exam phrases it.

    S’entraîner : IF function
  6. 6

    Rehearse full 50-minute runs. Certiport's own practice tests (CertPREP, powered by GMetrix) have a testing mode with the real timing; our Level 3 test reproduces the project structure and the 1–1000 display.

Level 3 follows this family: five projects of five tasks, a 50-minute clock, free navigation inside a project, a 1–1000 score with 700 to pass. Microsoft's scaling is proprietary; ours is a linear estimate.

  • Préparez-vous en 7 jours : le plan de niveau 3 →
Passer le test gratuit de niveau 3

Quelles erreurs coûtent des points ?

  • Not recognising the task behind the descriptor

    "Combine the first and last names with a space" is CONCAT or TEXTJOIN; "show only the rows for the East region" is a filter. Candidates who know functions by name alone hesitate on every task.

  • Breaking an earlier task

    Tasks in a project share one workbook. Deleting a column or sorting a table for task 4 can undo task 2. Skim all the tasks in a project before changing anything.

  • Spending the clock on one task

    At 80–90 seconds per task there is no time to debug. Mark it for review, finish the project, come back.

  • Near misses on names and ranges

    A chart titled "Sales 2026" when the task said "2026 Sales", a named range off by one row, a sheet renamed with a trailing space: all graded as wrong.

  • Treating 700 as 70%

    The score is scaled. Candidates who stop at "about two-thirds done" expecting a pass are often short. Attempt every task; partial credit depends on the exam engine and is not published.

Les questions des candidats

MO-200 or MO-210? MO-201 or MO-211?

MO-200 and MO-201 cover Excel 2019; MO-210 and MO-211 cover Excel in Microsoft 365 Apps. Both pairs are 50 minutes with the same task counts; the Microsoft 365 Expert outline adds XLOOKUP, LET, FILTER, SORTBY and RANDARRAY. Neither Office 2019 exam has a published retirement date.

What is the passing score?

700 on a scale of 1 to 1000. Microsoft scales the raw score, so 700 is not a fixed percentage of tasks. Pass or fail shows on screen immediately after the exam.

How soon can I retake it?

24 hours after a first failed attempt, then 48 hours between later attempts, with no annual limit. A voucher with retake covers a second attempt at the same exam if the first fails.

Do employers require MOS?

Rarely. Job listings prefer Office experience or credentials far more often than they require a specific certificate, and no reliable statistic shows how many require MOS. It is recognized, especially for administrative and finance-support roles and in education; treat it as evidence, not a gate.

How can I practise the format for free?

Microsoft's objective-domain PDFs are free, and the exercises on this site grade the same outcomes the exam checks: cell values, formulas, formats and sheet state. Our free Level 3 test reproduces the project structure and the timing: five projects of five tasks in 50 minutes, free navigation inside a project, a linear 1–1000 estimate with 700 to pass. Certiport's official practice tests are paid.

Les autres formats de test

FormatDurée et volumeDéroulement
  • Timed multiple-choice screening

    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 test
  • Simulated spreadsheet test

    SHL-type, eSkill, Criteria Interactive, Testlify, Vervoe

    25–35 minutes 20–30 tasks

    A mock Excel window with a task under it. One attempt per task, graded on the end result, some shortcuts switched off.

    À quoi vous attendre lors de ce test
  • Employer workbook test

    Written 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 test

Essayez dans un vrai tableur

Gratuit, sans compte et sans rien installer.

Passer le test gratuit de niveau 3Voir les exercices pratiques

Facts checked on November 15, 2026 against Microsoft Learn (exam duration and experience, scoring, retake policy, the MO-200, MO-201, MO-210 and MO-211 pages, updated July 31, 2026), the MO-200, MO-201 and MO-211 skills-outline PDFs, Certiport's exam-length page and US test-center price lists. The number of projects per exam is not published by Microsoft or Certiport.

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.