How do you pass MO-210 on your first attempt?
Weight your preparation the way the exam weights its marks, rehearse the specific mechanics that trip people up under time pressure — F4 reference cycling, SUMIF-style argument order, Ctrl+T tables, custom number-format codes — and take at least one full, timed practice exam before booking so you find your actual gaps instead of guessing at them.
Checked against Microsoft’s own published pages on September 16, 2026.
The numbers
Study in the order the exam actually weights, not the order that feels like 'real Excel'
Worksheets and Workbooks (25-30%) and Data Cells and Ranges (25-30%) together are more than half of MO-210. Formulas and Functions is only 15-20%. Most candidates study in the opposite order — formulas first, because that is what feels like the substance of Excel — and end up over-prepared on a fifth of the exam while the two heaviest domains go untouched.
Start with the domain you are least familiar with, not the one you like most. For most people that is Worksheets and Workbooks: page setup, the Document Inspector, workbook properties, and the Quick Access toolbar are all things a daily Excel user has likely never deliberately practiced.
Drill the specific mechanics that cost points under time pressure
F4 cycles a selected cell reference through relative (A1), absolute ($A$1), mixed with the row locked (A$1), and mixed with the column locked ($A1), in that exact order — practice this until it is automatic, because hunting for the right reference type mid-formula wastes real seconds repeatedly across the exam.
Know SUMIF's and COUNTIF's argument order (range, criteria, [sum_range] for SUMIF) cold, since a swapped argument produces a formula that looks plausible and returns a wrong or zero result with no obvious error. Get comfortable creating a table with Ctrl+T and using its structured references (Table1[Column]) rather than plain cell ranges. And learn custom number-format placeholder syntax — # for an optional digit, 0 for a required digit, and the semicolon-separated sections for positive;negative;zero;text — since a task can ask for a specific custom format that a built-in preset does not cover.
Rehearse against a real clock before you book the real exam
Take a full, timed practice exam and read the per-task breakdown rather than just the total score — the breakdown tells you which domains actually cost you points, as opposed to which ones felt unfamiliar while studying. Fifty minutes under real conditions surfaces gaps that untimed review does not.
Because partial credit is awarded per check rather than per task, go through every task once before returning to polish anything — an unattempted task is the only kind that reliably scores zero, so breadth on the first pass beats depth on any single task.
What costs people points
Formulas and functions are only 15-20% of MO-210. Spending most of your prep time there means the two heaviest domains — worksheet/workbook management and data/ranges — get the least attention, which is backwards.
Knowing the material and executing it under time pressure are different skills. A practice exam is the only way to rehearse the second one, and it is also how you find domain-specific gaps instead of guessing at them.
A single number tells you whether you would have passed, not what to fix. A breakdown that shows which specific tasks cost points turns one practice run into a targeted study list for the next one.
Related questions
How long should I study for MO-210?
Microsoft's own recommendation is about 150 hours of instruction and hands-on experience. Treat that as a description of breadth across the objective domain rather than a literal countdown — deliberate coverage of your weak domains matters more than total hours logged.
What is the single most useful thing to rehearse before exam day?
A full, timed practice exam with a per-task breakdown. It is the only way to find out which specific domains cost you points under real time pressure, rather than which ones simply feel unfamiliar.
Should I memorize keyboard shortcuts?
A handful are worth automating — F4 for reference cycling and Ctrl+T for tables specifically — because they come up constantly and hunting for the ribbon equivalent under time pressure costs real seconds, repeatedly.
Is it better to finish every task partially or perfect a few tasks completely?
Partially finishing every task, generally. Partial credit is awarded per check within a task, so an attempted task almost always beats an untouched one — go through everything once before going back to polish anything.
Sources
Read on September 16, 2026. Where this page says something is not published, that means we looked and did not find it — check for yourself.
Keep reading
Find out what you would actually score
Take a full, timed MO-210 practice exam, upload the workbook you built, and get a score out of 1000 with a per-task breakdown of where the points went. Your first one is free.
No credit card needed.