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. 17 sample questions are free.
Full access
$99
- All 425 questions across MO-201 and 77-427, with explanations
- Study, timed and flashcard modes
- Progress saved, resume any time
- Total questions
- 425
- Free samples
- 17
- 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)

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.
What does MO-201 cover?
The practice test's questions, grouped by exam topic. Open a topic to see what it covers.
4 topics · 57 subtopics · 270 questions
How do I earn this certification?
Passing MO-201 earns the Microsoft Office Specialist: Excel Expert (Office 2019) in the Microsoft Office Specialist track.
How to study for this exam?
Use the MO-201 practice test alongside the official material and the study plan below.
What's changed on this exam?
Status and coverage changes that affect what you should study.
- Current status
- ACTIVE
- Last content update
- Feb 18, 2025
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 simulatorTimed mode
A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.
Open in the simulatorFlashcards
Question on the front, answer on the back. Good for the last week before the exam.
Open in the simulator