Microsoft Excel Associate (Microsoft 365 Apps)
Prove you can build and manage real Excel workbooks. MO-210 is the industry-recognized entry point to Excel certification.
Add the free MO-210 practice exam to your cart. No purchase needed.
Exam at a glance
About the exam
Exam MO-210 leads to the Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) certification. It demonstrates competency in the fundamentals of creating and managing worksheets and workbooks, working with cells and ranges, building tables, applying formulas and functions, and creating charts and objects.
You work with the kinds of documents Excel is used for every day: professional budgets, financial statements, team-performance charts, sales invoices, and data-entry logs. That means creating and editing multi-sheet workbooks and using graphic elements to represent data visually.
The exam is performance-based. Task instructions generally avoid naming the exact command or function, so you are tested on knowing which Excel feature to reach for to get a result, not on memorizing menu labels.
Who it is for
- Students and job-seekers who want a recognized credential for core Excel skills
- Administrative, finance, operations, and analyst roles that use Excel daily
- Anyone with roughly 150 hours of Excel instruction and hands-on practice
- Candidates who plan to continue on to the Excel Expert (MO-211) certification
Skills measured
The exam is organized into these objective domains. Percentages show the approximate share of the exam each area represents.
- Import data from text files
- Import data from online sources
- Search for data within a workbook
- Navigate to named cells, ranges, or workbook elements
- Insert and remove hyperlinks
- Modify page setup
- Adjust row height and column width
- Customize headers and footers
- Manage the Quick Access toolbar
- Display and modify worksheets in different views
- Freeze worksheet rows and columns
- Change window views
- Modify built-in workbook properties
- Display formulas
- Set a print area
- Save and export workbooks in alternative file formats
- Configure print settings
- Inspect workbooks and correct issues
- Manage comments and notes
- Paste data by using special paste options
- Fill cells by using Auto Fill
- Insert and delete multiple columns or rows
- Insert and delete cells
- Generate numeric data by using RANDBETWEEN() and SEQUENCE()
- Merge and unmerge cells
- Modify cell alignment, orientation, and indentation
- Format cells by using Format Painter
- Wrap text within cells
- Apply number formats
- Apply cell formats from the Format Cells dialog box
- Apply cell styles
- Clear cell formatting
- Format multiple worksheets by grouping
- Define a named range
- Reference a named range
- Insert Sparklines
- Apply built-in conditional formatting
- Remove conditional formatting
- Create Excel tables from cell ranges
- Apply table styles
- Convert tables to cell ranges
- Add or remove table rows and columns
- Configure table style options
- Insert and configure total rows
- Filter records
- Sort data by multiple columns
- Insert relative, absolute, and mixed references
- Use structured references in formulas
- Perform calculations by using AVERAGE(), MAX(), MIN(), and SUM()
- Count cells by using COUNT(), COUNTA(), and COUNTBLANK()
- Perform conditional operations by using IF()
- Sort data by using SORT()
- Get unique values by using UNIQUE()
- Format text by using RIGHT(), LEFT(), and MID()
- Format text by using UPPER(), LOWER(), and LEN()
- Format text by using CONCAT() and TEXTJOIN()
- Create charts
- Create chart sheets
- Add data series to charts
- Switch between rows and columns in source data
- Add and modify chart elements
- Apply chart layouts
- Apply chart styles
- Add alternative text to charts for accessibility
How to prepare
- 1Practice by doing. The exam grades completed tasks in real Excel, so rehearse in the app rather than with flashcards.
- 2Learn features by purpose. Because a task might say summarize the trend in a single cell instead of naming Sparklines, connect each result to the tool that produces it.
- 3Mind the clock. 50 minutes across several projects works out to roughly a minute per task, so know where each command lives.
- 4Get fluent with named ranges, structured references, and the newer dynamic functions such as SORT and UNIQUE.
- 5Take a full, timed practice exam first to find your weakest domains, then drill those before test day.
Frequently asked questions
How long is the MO-210 exam?
50 minutes, delivered as several performance-based projects inside a live Excel environment.
How do I know when I am ready to book?
Take practice exams until your readiness score is exam-ready across three different versions — one good attempt measures that version, not the exam. The full MO-210 study plan→
What score do I need to pass?
Exams are scored out of 1000 points and you need 700 to pass. How MO-210 scoring actually works→
Is it multiple choice?
No. You complete real tasks in Excel and are graded on the result, not on picking an answer from a list.
Do I have to memorize function names?
Task instructions usually describe the outcome and avoid naming the exact command, so understanding what each feature does matters more than memorizing labels.
What is the difference between MO-210 and MO-211?
MO-210 (Associate) covers core, everyday Excel skills. MO-211 (Expert) covers advanced formulas, macros, data analysis, PivotTables, and advanced charts. Compare the objective domains and weighting→
How hard is the MO-210 exam?
Broad rather than deep. Nothing on it is conceptually difficult, but it covers the whole surface of everyday Excel in 50 minutes, and formulas are only 15 to 20 percent of the marks. Where confident Excel users lose points→
Is the certification actually worth having?
It depends on your situation. It is worth most when a school requires it, or early in a career when you have no work history that demonstrates the same thing, and least once you have a track record. An honest look, including who should skip it→
How should I prepare?
Plan for around 150 hours of hands-on practice and rehearse with full, timed practice exams that mirror the real objective domains.
How much does it actually cost to get certified?
A Certiport exam voucher runs $104-$120, plus whatever you spend on practice. Our own practice exams start free. The full cost breakdown→
What are the actual steps to get certified?
Prepare, buy a voucher from Certiport, schedule your exam, sit the 50-minute test, and get your result immediately. The full step-by-step process→
What is exam day actually like?
A proctored, 50-minute, live-in-the-application exam with no built-in breaks and no reference lookup. What to expect, in detail→
What does the Worksheets and Workbooks domain actually cover?
Importing data, navigating, page setup and views, and preparing a workbook for distribution — the heaviest domain on the exam at 25-30%. The full domain breakdown→
What does Managing Data Cells and Ranges cover?
Manipulating and formatting cell data, named ranges, and visual summaries like sparklines and conditional formatting — another 25-30% of the exam. The full domain breakdown→
What does the Tables domain cover?
Creating, modifying, filtering and sorting Excel tables — the lightest MO-210 domain at 10-15%. The full domain breakdown→
Which functions does MO-210 actually test?
SUM, AVERAGE, MAX, MIN, the COUNT family, IF, SORT, UNIQUE, and text functions like LEFT/RIGHT/MID — 15-20% of the exam. Every function, explained→
What does the Charts domain cover?
Creating, modifying and formatting charts, including accessibility alt text — 15-20% of the exam. The full domain breakdown→
What is the best study sequence for MO-210?
Prioritize by weighting, not by what feels familiar — the heaviest domains are workbook and range management, not formulas. The full study sequence→
How does MO-210 differ from the older MO-200 exam?
MO-200 (Office 2019) is not retired, just hidden from Microsoft's own catalog. MO-210 adds dynamic-array functions and reweights the domains substantially. What actually changed→
What are the most common ways people lose points on MO-210?
Specific, avoidable habits — hard-typing values instead of using formulas, skipping tasks instead of partially completing them, and more. The full list of tactical mistakes→
Where can I look up a term I do not recognize?
The glossary covers every term MO-210 and MO-211 actually test — structured references, dynamic arrays, named ranges, and more — each linked to the guide that explains it in exam context. Browse the glossary→
Can I try a real exam before I buy anything?
Yes — your first practice exam is free. Create an account and you get a full exam, untimed, graded by the same engine as our paid MO-210 and MO-211 exams. Start a free exam→
Does Excel certification actually affect your salary?
There's real data on what MOS-certified people report earning, but no credible study isolating the certification's own effect on pay — the honest breakdown, not a recycled marketing stat. The real numbers, and why to be skeptical of the rest→
How do I add my MOS certification to LinkedIn and my résumé?
Claim your Credly badge, then add it to LinkedIn — note LinkedIn's Add to Profile button no longer autofills your details, so have them ready. The full claim, LinkedIn, and résumé walkthrough→
Ready to practice for MO-210?
Take a full, timed Microsoft Excel Associate practice exam and get detailed, per-task feedback. Your first exam is on us.
No purchase needed. Add the free exam to your cart on the practice exams page.