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.
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.
Import a .txt or .csv, freeze panes, page setup and print areas, headers and footers, named ranges, display formulas, inspect a workbook before sharing.
Paste special, Auto Fill, merge and wrap, number formats, cell styles, Format Painter, sparklines, built-in conditional formatting.
Create a table from a range, add a total row, sort by multiple columns, filter.
Relative, absolute and mixed references; AVERAGE, MAX, MIN, SUM; COUNT, COUNTA, COUNTBLANK; IF; RIGHT, LEFT, MID; UPPER, LOWER, LEN; CONCAT and TEXTJOIN.
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.
Custom number formats, data validation, remove duplicates, subtotals, formula-based conditional formatting.
PivotTables with slicers, grouping and calculated fields; PivotCharts; combo, waterfall and histogram charts.
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.
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.
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.
Expert: do the logic and lookups tracks, then the dynamic-array exercises (FILTER, SORTBY, UNIQUE). Expert formulas are 25–30% of the exam.
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.
Practise reading descriptors: cover the function name in each exercise title and work from the task text alone, the way the exam phrases it.
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.
"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.
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.
At 80–90 seconds per task there is no time to debug. Mark it for review, finish the project, come back.
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.
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.
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.
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.
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.
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.
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.
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.
Was Sie in diesem Test erwartetSHL-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.
Was Sie in diesem Test erwartetWritten 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.
Was Sie in diesem Test erwartetKostenlos, ohne Konto und ohne Installation.
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 ist eine Marke der Microsoft-Unternehmensgruppe. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria und andere Marken sind Eigentum ihrer jeweiligen Inhaber. GridBelt ist unabhängig, steht mit keinem dieser Unternehmen in Verbindung und wird von keinem von ihnen unterstützt oder gesponsert.