ExamDumpster

MO-201

Excel Expert (Office 2019) practice test

425 Microsoft MO-201 and 77-427 practice questions with explanations, in study, timed and flashcard modes.

Full access

$99

  • All 425 questions across MO-201 and 77-427, with explanations
  • Study, timed and flashcard modes
  • Progress saved, resume any time
Try the free samples first
Microsoft logo
Total questions
425
Free samples
–
Versions
2
Updated
Oct 2026

Exam simulator

Practice MO-201 in the simulator.

Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.

At a glance

MO-201, by the numbers.

Official specifications published by Microsoft.

Duration
50 min
Questions
Performance-based tasks
Passing score
700 on a 0-1000 scale
Exam fee
$100
In the bank
MO-201 (270), 77-427 (155)
Open the full exam guide

Exam guide

Everything about MO-201.

MO-201 · Microsoft · v1.0

What is MO-201?

Passing MO-201 shows you can build complex Excel 2019 workbooks with advanced formulas, macros and charts. It leads to the Office 2019 Excel Expert credential in the Microsoft Office Specialist program. Analysts, finance staff and office workers who use Excel every day usually take it. MO-211 is the newer Expert exam for Excel in Microsoft 365 Apps. The exam also tests PivotTables, which group and sum large sets of data so patterns are easy to see. For example, you may write an INDEX and MATCH formula that pulls a price from another sheet. Workbook options, data formatting, formulas and macros, and advanced charts are the main areas of the practice test.

What you'll practise

  • Manage workbook options, prepare workbooks for collaboration and set language options.
  • Fill cells from existing data, and format and validate data.
  • Apply advanced conditional formatting and filtering.
  • Write formulas with logical, lookup and date and time functions.
  • Record and edit simple macros.
  • Create and modify advanced charts, PivotTables and PivotCharts.

Requirements

  • No formal prerequisites: anyone can book the exam.
  • Recommended: the MOS Excel Associate exam (MO-200) or equal experience.
  • Recommended: expert-level Excel 2019 skills built through training and regular hands-on use.

Who it's for

  • Data analysts and finance staff who build complex spreadsheets and models.
  • Office and administrative professionals who manage company data in Excel.
  • Students preparing for business careers who want a recognized Excel credential.

Exam details

Published by Microsoft, plus what is in our question bank.

Duration
50 min
Questions
Performance-based tasks
Passing score
700 on a 0-1000 scale
Level
Expert

Three ways to practise

Study mode

Work through the bank at your own pace with the answer and explanation one tap away. Flag questions, add notes, bookmark the hard ones.

Open in the simulator

Timed mode

A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.

Open in the simulator

Flashcards

Question on the front, answer on the back. Good for the last week before the exam.

Open in the simulator

MO-201 questions, answered