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.
What score do I need to pass?
Exams are scored out of 1000 points and 700 is the typical passing mark, though the exact bar can vary.
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.
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.
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.