MO-200 study guide
MO-200 · Work through your exam, one topic at a time.
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 MO-200 study guide has 5 sections and about 1,848 words.
01Manage worksheets and workbooks
The Manage worksheets and workbooks domain tests whether you can bring external data in, navigate a workbook, control how sheets and windows display, prepare print output, and protect or distribute a file. The exam favors exact command paths and the effect of each option, not just the feature name.
385 words, about 2 min02Manage data cells and ranges
The Manage data cells and ranges domain covers cell-level editing and formatting: paste options, fill series, text splitting, row/column sizing, number formats, conditional formatting, named ranges, and sparklines. Questions often test what an operation changes and what it leaves untouched.
377 words, about 2 min03Manage tables and table data
The Manage tables and table data domain tests whether you can convert a range into a structured table, use table names and structured references, and sort or filter data without damaging records. It also checks the difference between table features and ordinary range features.
368 words, about 2 min04Perform operations by using formulas and functions
The Perform operations by using formulas and functions domain covers references and the function set the exam expects: logical, lookup, conditional aggregation, text, date, rounding, and error handling. You need to know argument order and what each function counts or returns.
326 words, about 2 min05Manage charts
The Manage charts domain covers creating charts from ranges, tables, named ranges, and PivotTables; choosing chart types; editing source data; adding chart elements; and formatting series and axes. Questions often test the connection between chart and source data.
392 words, about 2 min