MOS Excel Associate (MO-210) Exam Guide: Objectives, Cost, Scoring and How to Prepare

Independent guide. If you buy through links on this page we may earn a commission at no extra cost to you. Our verdicts are based on the evidence, not on who pays. How we make money.

What the exam is

MO-210 is the Microsoft 365 Apps version of the Microsoft Office Specialist Excel exam. Passing it earns a single certification, Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps)¹. Microsoft writes the exam and Certiport (Pearson VUE) delivers it, at authorized testing centers or remotely through Certiport’s “Exams from Home”⁵. Unlike the Expert exam, MO-210 is available in 15 languages, including Spanish, French, German, Portuguese (Brazil), Japanese and Chinese¹.

MO-210 also counts as one of the three exams for the stacked “Microsoft Office Specialist: Associate (Microsoft 365 Apps)” credential, alongside Word and PowerPoint exams; that broader credential is a separate goal and is rarely required by employers⁷. The older Office 2019 version of this exam, MO-200, is still listed by Microsoft with no retirement date⁸.

Exam objectives and weightings

Functional group (Microsoft’s wording)	Weight	What it covers in practice
Manage worksheets and workbooks	25–30%	Importing data from text files and online sources; searching and navigating to named ranges; hyperlinks; page setup, row heights and column widths, headers and footers, Quick Access toolbar, views, freezing panes, workbook properties, showing formulas; print areas and print settings, saving in other formats, inspecting workbooks, comments and notes
Manage data cells and ranges	25–30%	Paste Special, Auto Fill, inserting and deleting rows, columns and cells, RANDBETWEEN and SEQUENCE; merging, alignment and indentation, Format Painter, wrap text, number formats, the Format Cells dialog, cell styles, clearing formats, grouping worksheets; defining and referencing named ranges; Sparklines and built-in conditional formatting
Manage tables and table data	10–15%	Creating Excel tables, table styles and style options, converting tables back to ranges, adding rows and columns, total rows, filtering records, sorting by multiple columns
Perform operations by using formulas and functions	15–20%	Relative, absolute and mixed references; structured references; AVERAGE, MAX, MIN, SUM; COUNT, COUNTA, COUNTBLANK; IF; SORT and UNIQUE; RIGHT, LEFT, MID; UPPER, LOWER, LEN; CONCAT and TEXTJOIN
Manage charts	15–20%	Creating charts and chart sheets, adding data series, switching rows and columns, chart elements, layouts and styles, alternative text for accessibility

Two features of this list surprise experienced users. First, the exam is not mainly about formulas: more than half the marks are for managing workbooks and formatting data. Second, the function list is short and specific, and it includes newer dynamic-array functions (SORT, UNIQUE, SEQUENCE) and text functions (CONCAT, TEXTJOIN) that people who learned Excel years ago may never have used.

Who should take it

MO-210 is aimed at people who use Excel for everyday work — administrative, operations, customer-service, HR, sales-support and entry-level analyst roles — and at students who want a recognized credential. If a job advertisement asks for “proficient in Excel” or “Excel certification”, this is the exam it most often means. If you already write lookup formulas, build PivotTables and have recorded a macro, the Expert exam is a better use of $104: it has no prerequisite and its objectives match analyst work more closely⁹.

Exam structure, scoring and retakes

• Length: “You will have 50 minutes to complete this assessment”¹.
• Format: Certiport’s “Live-in-the-Application” testing — a real copy of Excel opens and you complete tasks in project files⁵. Microsoft’s page says the exam “may have interactive components”¹.
• Scoring: reported on a 1–1,000 scale. Certiport’s scoring policy states that “the passing value is always equated to 700 on this scale”⁴; Microsoft’s scoring page says that for Office exams the required score “depends on the specific exam you’re taking”¹⁰. Treat 700 as the working target.
• Retakes: wait 24 hours after a first fail and 48 hours before each subsequent attempt; no annual limit¹¹.
• Validity: Microsoft’s certification page shows a “Renewal Frequency” of 60 months and no prose rule on expiry; we do not claim MOS certifications expire or last forever¹.
• Prerequisites: none.

Cost and registration

Microsoft’s exam page gives no price (“based on the country or region in which the exam is proctored”)¹. The Certiport Store, the official US retail channel, lists a Microsoft Office Specialist exam voucher at $104.00, a voucher with one retake at $120.00, CertPREP practice tests for one title at $40.00, and a voucher-with-retake-plus-practice-tests bundle at $156.00⁶. Vouchers work for any current MOS exam. Testing centers set their own fees; schools that are Certiport testing centers may offer exams to their own students — ask before buying a voucher. Register through a Certiport account and book either a seat at a Certiport Authorized Testing Center or an Exams from Home session⁵.

How to prepare

1. Download the skills outline and score yourself against it. Every objective is listed². Mark each one “fluent”, “slow” or “unknown”. Common unknowns: importing from text and online sources, SEQUENCE and RANDBETWEEN, structured references, SORT and UNIQUE, TEXTJOIN, chart sheets and alternative text on charts.
2. Use Microsoft’s free exam-prep package. Microsoft publishes a downloadable “Microsoft Excel (Microsoft 365 Apps) exam prep study guide” course for MO-210 with lessons, activities and assessments¹². There is no Microsoft Learn learning path for this exam¹.
3. Practise in Excel, not on video. The exam is hands-on and timed. For each objective, do the task from memory in a blank workbook; then do it again using a different route (ribbon, right-click, keyboard).
4. Take official practice tests in timed mode. Certiport’s CertPREP practice tests (powered by GMetrix) have a Training Mode with feedback and a Testing Mode that mirrors the exam’s timing¹³. Book the exam when you pass practice tests comfortably above 700 on consecutive attempts.
5. Buy the retake option if in doubt. The $120 voucher with retake costs $16 more and saves $88 if you need a second attempt⁶.

Practice tests and courses

The official CertPREP practice tests are the closest thing to the exam ($40 for the Excel title)⁶. For instruction, Microsoft’s free study-guide package covers the objectives directly. Beginner courses on Coursera (Macquarie University’s Excel Skills for Business: Essentials) or a GoSkills subscription teach the same skills well, but they are organised around skills rather than the MO-210 objective list, so keep the outline beside you; see the Excel courses hub. Note that Microsoft’s own Microsoft Excel Professional Certificate on Coursera does not mention the MOS exams on its page¹⁴.

How difficult is it?

Common mistakes

• Over-preparing formulas and under-preparing workbook management. The two largest groups (worksheets and workbooks; cells and ranges) carry 50–60% of the marks between them.
• Ignoring the named functions. The outline names exactly which functions are tested²; make sure SORT, UNIQUE, SEQUENCE, CONCAT and TEXTJOIN are as familiar as SUM.
• Not practising in the current Excel. The exam uses the Microsoft 365 Apps version; menus and functions differ from Excel 2016 or 2019.
• Running out of time. Move on from a task you cannot finish; the exam scores the tasks you complete.
• Skipping the from-home rules. Read Certiport’s Exams from Home candidate guide before exam day if you test remotely⁵.

Booking, cost and the free alternatives

Registration, current Certiport voucher prices and the choice between a testing centre and remote proctoring work the same way for every MOS exam; the whole process is set out step by step in how to get Excel certified. If you are hoping to avoid the fee, free Excel certification covers what is genuinely free and what only looks it.

Related certifications

MOS Excel Expert (MO-211) is the advanced exam: no prerequisite, English only, and objectives that cover advanced formulas and macros, data management, PivotTables and advanced charts — see the MO-211 guide. MO-200 is the Office 2019 version of this exam, still listed by Microsoft⁸. For the full picture, including course certificates and financial-modeling credentials, start at Excel certifications compared.

Frequently asked questions

Sources

Update log