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.
O que esperar deste testeSHL-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.
O que esperar deste testeWritten 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.
O que esperar deste testeGrátis, sem conta e sem instalar nada.
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 é uma marca comercial do grupo de empresas Microsoft. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria e outras marcas pertencem aos seus respectivos proprietários. O GridBelt é independente e não tem afiliação com nenhum deles, nem é endossado ou patrocinado por eles.