MO-210 study guide
MO-210 · Work through your exam, one topic at a time.
MO-210, listed by Microsoft as Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps), is an intermediate-level certification that verifies you can use the core features of Excel in the Microsoft 365 Apps environment. Microsoft positions it for business users who can create and manage worksheets and workbooks, create cells and ranges, create tables, apply formulas and functions, and create charts and objects - including multi-sheet workbooks and charts that present data visually. The MO-210 study guide has 5 sections and about 1,600 words.
01Manage Worksheets and Workbooks
This domain is about controlling workbook structure , not cell content. Be fluent with inserting, deleting, renaming, moving, copying and colour-coding tabs; selecting several sheets to group them; hiding and unhiding sheets; and switching among Normal, Page Layout and Page Break Preview views.
334 words, about 2 min02Manage Data Cells and Ranges
This domain rewards precision with Paste Special (Values, Formats, Transpose, Skip Blanks, Add/Subtract operations), the fill handle and Flash Fill , Text to Columns , Remove Duplicates , sort and multi-level sort, AutoFilter and Advanced Filter, Subtotal with outline grouping, and custom number formats. You also need conditional formatting (highlight rules, data bars, icon sets, formula-based rules), data validation (lists, whole numbers, dates, custom formulas, input and error messages), and named ranges with either workbook or worksheet scope.
323 words, about 2 min03Manage Tables and Table Data
An Excel table (Ctrl+T) is a named object with banded rows, a header row, filter buttons, a Total Row , and automatic calculated columns that fill every row when you type a formula. The big idea is structured references : instead of =SUM(C2:C50) you write =SUM(Sales[Amount]) , and instead of =B2 C2 you write =[@Price] [@Quantity] .
312 words, about 2 min04Perform Operations by Using Formulas and Functions
Most formula errors in exams come from references, not functions. Master relative ( A1 ), absolute ( A 1 ) and mixed ( A1 , A 1 ) references, 3D references such as =SUM(Jan:Mar!B2) , defined names, and the fill behaviour each produces.
291 words, about 1 min05Manage Charts
Chart questions test whether you can pick a type that fits the data and then control every element. Column and bar charts compare categories, line charts show trends over time, pie and doughnut charts show parts of a single whole, and XY scatter charts plot numeric pairs - the only correct choice for true x-y correlation.
340 words, about 2 min