Перейти к содержимому
GridBelt
  • Тест по Excel
  • Упражнения
  • Программы
  • Цены
Войти
Начать бесплатный тест
  • Тест по Excel
  • Упражнения
  • Программы
  • Цены
ВойтиСоздать аккаунт
Начать бесплатный тест
GridBelt

Тренируйте навыки Excel прямо в браузере.

Тест по Excel

  • Уровень 1: Начальный
  • Уровень 2: Средний
  • Уровень 3: Продвинутый
  • Подготовка к тесту по Excel за 7 дней
  • Таблица лидеров
  • Тест по Excel на собеседовании
  • Тест по Excel от Indeed

Упражнения

  • Все упражнения
  • Программы
  • Для начинающих

Материалы

  • Формулы Excel
  • Горячие клавиши Excel

Компания

  • О проекте
  • Цены
  • Как мы проверяем

© GridBelt. Все права защищены.

  • Политика конфиденциальности
  • Условия использования
  • Политика возврата средств

Excel — товарный знак корпорации Microsoft. Indeed, TestGorilla, SHL и другие товарные знаки принадлежат их владельцам. GridBelt — независимый сайт для практики: он не связан с Microsoft, TestGorilla, SHL или Indeed, не одобрен и не спонсируется ими.

  1. Тест по 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.

Параметры формата

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.

О чём спрашивают?

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.

    Практика: 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.

    Практика: Merge and wrap
  • Tables (Associate)

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

    Практика: Sort and filter
  • Charts (Associate)

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

    Практика: 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.

    Практика: 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.

    Практика: SUMIF and SUMIFS
  • Data (Expert)

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

    Практика: Drop-down lists
  • PivotTables and advanced charts (Expert)

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

    Практика: Pivot tables

Как подготовиться?

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.

    Практика: 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.

    Практика: 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.

    Практика: 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.

    Практика: 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.

  • Подготовка за 7 дней: план уровня 3 →
Пройти бесплатный тест уровня 3

Какие ошибки стоят баллов?

  • 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.

Вопросы, которые задают кандидаты

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.

Другие форматы тестов

ФорматДлительность и объёмКак это выглядит
  • 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.

    Чего ждать от этого теста
  • 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.

    Чего ждать от этого теста
  • 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.

    Чего ждать от этого теста

Попробуйте в настоящей таблице

Бесплатно, без регистрации и без установки.

Пройти бесплатный тест уровня 3Перейти к упражнениям

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 — товарный знак группы компаний Microsoft. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria и другие товарные знаки принадлежат их владельцам. GridBelt — независимый проект: он не связан ни с одной из этих компаний, не одобрен и не спонсируется ими.