MO-200
Microsoft Office Specialist: Excel Associate (Office 2019)
More study resources
Cheat sheet
Keep the key ideas within reach.
ExploreKey terms
Get comfortable with the vocabulary.
ExploreStudy plan
Give each week a clear focus.
ExploreCommon mistakes
Understand the traps and how to avoid them.
ExploreCase studies
Put your knowledge to work in context.
ExploreExam-day guide
Prepare for the day ahead.
ExploreAbout this exam
The Microsoft Office Specialist: Excel Associate (Office 2019) credential, exam code MO-200, certifies that you can use Excel 2019 at a working professional level: creating and formatting workbooks, managing cells and ranges, building and filtering tables, writing formulas with core functions, and creating and formatting charts. It suits office administrators, analysts, students, and career changers who need verifiable proof of spreadsheet skill rather than a certificate of attendance. The exam is delivered in a live Excel application, so you are assessed on doing tasks, not on recalling trivia; the five published skill domains weight formulas and functions most heavily, followed by data ranges and charts. Preparation works best in the application itself: work through each domain in a practice workbook, learn the ribbon paths for common commands, and rehearse functions such as SUM, AVERAGE, IF, VLOOKUP, COUNTIF, and date and text functions until you can type them without help. Because the exam is scored on completed actions, practise finishing tasks quickly and checking results. This page is independent study material and is not affiliated with or endorsed by Microsoft; the official body publishes current exam logistics, so confirm details on its site before booking.
What you'll study
About MO-200 preparation
What is the exam format?
It is a proctored, computer-delivered exam taken in a live Microsoft Excel 2019 session. Tasks ask you to perform actions in the application, such as formatting a range, creating a table, or entering a formula, and some items may ask you to select an answer. You are graded on the state of the workbook you produce, so exact command paths matter.
How long is the exam and how many questions are there?
The official certification body sets the current question count and time limit and publishes them with the exam details. Those figures can change between delivery versions, so check the official site rather than relying on secondhand numbers. Plan to work briskly, since task-based items reward efficiency.
What score do I need to pass?
The passing score is set by the official certification body and is published on its site along with the current exam objectives. It is not a simple percentage of items answered, because tasks carry different weights. Confirm the current threshold officially before you book.
How difficult is MO-200?
Most candidates with regular Excel exposure find it manageable, but it is not trivial. The difficulty comes from breadth and precision: you must know ribbon locations, table features, chart formatting, and function syntax without hesitation. Candidates who only use Excel casually usually need focused practice on formulas and charts.
Can I retake the exam if I fail?
Retake rules, waiting periods, and any fees are set by the official certification body and can differ by region and delivery provider. Check the official site or your test provider for the current policy before scheduling a second attempt, and use the score report to target weak domains.
In what order should I study the domains?
Start with worksheets and workbooks, then cells and ranges, because everything else depends on those basics. Move to tables, then spend the largest block of time on formulas and functions, which carries the most weight. Finish with charts, practising chart type selection, axis and legend formatting, and adding data series.
Which functions should I be able to write from memory?
Be fluent with SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTIF, SUMIF, IF, AND, OR, VLOOKUP, HLOOKUP, and text and date functions such as CONCATENATE or TEXTJOIN, LEFT, RIGHT, MID, and TODAY. Also know relative versus absolute references, because copying formulas correctly is a common scoring point.
Why do candidates lose points on tasks they know how to do?
The usual causes are using a mouse-driven workaround instead of the command the task expects, formatting whole columns instead of the specified range, forgetting to convert a range to a table, and leaving a chart untitled or with the wrong series. Read each instruction fully and verify the result before moving on.
Do I need to buy practice tests?
No purchase is required. Build your own practice workbooks covering each domain, and use the official objectives list to check coverage. Free official documentation and function references are enough for study material; paid practice tests can help with timing but are optional and are not affiliated with this page.