MO-210: Excel Associate (Microsoft 365 Apps) Practice Exam
Get ready for the performance-based MOS Excel exam with task-style questions across all five objective domains — worksheets and workbooks, cells and ranges, tables, formulas and functions, and charts. Immediate feedback in Learn mode; full timed simulation in Exam mode.
764 practice questions — under 7¢ each across the full bank.
Backed by our satisfaction guarantee. Instant access — no software to install.
PowerKram’s value promise vs. typical competing MO-210 practice sets. On sale now.
MO-210 exam at a glance
- Credential
- Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps)
- Exam code
- MO-210
- Issued by
- Microsoft (MOS program); delivered through Certiport
- Level
- Intermediate · Role: Business User
- Domains
- 5 objective domains (no published percentage weights)
- Format
- Performance-based, delivered live inside Excel; may include interactive/task-based components
- Duration
- 50 minutes
- Delivery
- Proctored, scheduled through Certiport (Pearson VUE)
- Recommended experience
- ~150 hours of instruction and hands-on Excel practice
- Prerequisites
- None; foundational familiarity with Excel (Microsoft 365) is expected
- Retake
- 24 hours after a first failed attempt
- Renewal
- Certification does not expire (60-month listing; MOS credentials are lifetime)
Source: Microsoft Learn — MOS: Excel Associate (Microsoft 365 Apps) and the Exam MO-210 skills outline. Microsoft lists the five domains without percentage weights; format and scoring are set by Microsoft/Certiport and can change. Passing scores are set by Certiport and not published as a fixed cut score by Microsoft.
About the MO-210 Excel Associate (Microsoft 365 Apps) certification
MO-210 leads to the Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) credential — the associate-level MOS certification for Excel in the subscription version of Office. It validates that you can get real work done in Excel: creating and managing workbooks, working with cells and ranges, building tables, applying formulas and functions, and creating charts to present data clearly.
It replaces the retired Office 2019 MO-200 exam and is the first step on the Excel MOS path; the next step up is the Expert-level MO-211. Because the exam is performance-based, task instructions generally avoid naming the exact command or function — you’re tested on knowing which Excel feature to reach for to get a result, not on memorizing menu labels.
MO-210 objective domains
Microsoft’s skills outline lists five objective domains. Unlike Microsoft’s role-based exams, the MOS outline does not publish a percentage weight for each domain — the exam is performance-based and built from live-task projects, so aim to be competent across all five rather than studying to a weighting.
Import data from text files and online sources; navigate and search workbooks; named navigation and hyperlinks; page setup, views, freezing panes, and workbook properties; prepare workbooks for collaboration and distribution (print area, export formats, Document Inspector, comments).
Paste Special and Auto Fill; insert and delete cells, rows, and columns; RANDBETWEEN() and SEQUENCE(); cell formatting, alignment, number formats, and styles; define and reference named ranges; visual summaries with Sparklines and conditional formatting.
Create Excel tables from cell ranges; apply table styles; convert tables back to ranges; add and remove rows and columns; configure total rows; sort and filter table data, including multi-level and custom filters.
Reference cells with relative, absolute, and mixed references; calculate with SUM, AVERAGE, MAX, MIN, COUNT, COUNTA; conditional logic with IF, SUMIF, AVERAGEIF, COUNTIF; format and modify text with RIGHT, LEFT, MID, UPPER, LOWER, LEN, CONCAT, TEXTJOIN.
Create charts from data ranges; add and modify chart elements (titles, data labels, legends, axes); apply chart layouts and styles; move charts to a chart sheet; add alternative text to charts for accessibility.
Domain wording per Microsoft’s Exam MO-210 skills outline (Microsoft 365 Apps edition). Microsoft lists these five domains under “Assessed on this exam” without percentage weights.
Who MO-210 is for
- Students and job-seekers who want a recognized credential for core Excel skills.
- Business users, analysts, and administrators who build budgets, financial statements, invoices, and data logs in Excel every day.
- Anyone starting the Excel MOS path who plans to progress to the Expert-level MO-211 later.
- Career-changers proving practical, job-ready spreadsheet proficiency to employers.
What this MO-210 practice exam delivers
Full domain coverage
Questions mapped to all five objective domains — workbooks, cells and ranges, tables, formulas and functions, and charts.
Learn mode
Answer, get immediate feedback, and read an explanation that connects each result to the Excel feature that produces it.
Exam mode
Full timed simulation that mirrors the real 50-minute, task-focused format so you can rehearse working against the clock.
Domain-level scoring
See performance by domain to find and drill your weakest areas before test day.
Feature-by-purpose focus
Because MOS avoids naming commands, our items teach you which tool produces a result — the way the real exam asks.
Instant access, no software
Runs in the browser on desktop and mobile. Unlimited retakes across your full year of access.
The full PowerKram exam engine
Every practice question runs in our purpose-built study engine — not a static PDF or a one-shot quiz. That’s what gets you to a passing score.
- Study by objectives / domains
- Detailed score breakdown
- Exam and Learn mode
- Complete coverage of resources
- High quality, verified accurate
- Not just a public dump
Sample MO-210 practice questions
Five representative items across the five objective domains. Answers and explanations are inside each disclosure.
You want the top row of a large worksheet to stay visible as you scroll down through hundreds of rows of data.
Which feature accomplishes this?
- Freeze Panes (Freeze Top Row)
- Split the window into four panes
- Hide the remaining rows
- Convert the range to a table
Show answer & explanation
You need to copy a range and paste only the resulting values, dropping the underlying formulas.
Which action does this?
- A normal Paste (Ctrl+V)
- Paste Special → Values
- Paste Special → Formats
- Drag the fill handle
Show answer & explanation
You have an Excel table and want a row at the bottom that shows the sum of a numeric column, updating automatically as rows are added.
What should you enable?
- A manually typed SUM below the table
- Conditional formatting
- The table’s Total Row
- A Sparkline
Show answer & explanation
You want to count how many cells in the range B2:B100 contain a value greater than 50.
Which function should you use?
- SUMIF
- COUNTA
- AVERAGEIF
- COUNTIF
Show answer & explanation
A colleague using a screen reader needs to understand a chart you created.
What should you add to make the chart accessible?
- Alternative text (alt text) describing the chart
- A drop shadow on the chart area
- A brighter color scheme
- A larger chart title font
Show answer & explanation
Keep going: Learning & Career resources
Frequently asked questions about MO-210
What are the MO-210 objective domains?
Microsoft’s skills outline lists five: Manage worksheets and workbooks; Manage data cells and ranges; Manage tables and table data; Perform operations by using formulas and functions; and Manage charts. Microsoft does not publish a percentage weight for each domain, so aim to be competent across all five.
How long is the exam and how is it delivered?
MO-210 runs 50 minutes and is performance-based — delivered live inside Excel through Certiport, where you complete real tasks and may encounter interactive components rather than only multiple-choice questions. Task instructions usually avoid naming the exact command, so you’re tested on knowing which feature to use.
Is there a passing score?
MOS exams are scored on a 1,000-point scale by Certiport, and 700 is the commonly cited MOS passing standard. Microsoft’s certification page does not publish a fixed cut score, so confirm the current requirement with Certiport when you schedule.
Are there prerequisites, and how much preparation is recommended?
There are no formal prerequisites, though foundational familiarity with Excel in Microsoft 365 is expected. Microsoft recommends roughly 150 hours of instruction and hands-on practice with the product before sitting the exam.
How does MO-210 relate to MO-200 and MO-211?
MO-210 is the current Microsoft 365 Apps Associate exam for Excel; it replaces the retired Office 2019 MO-200. The next step up is MO-211, the Excel Expert (Microsoft 365 Apps) exam, which requires the Associate certification first.
How long do I have access to this practice exam, and is it a subscription?
Full access is a one-time purchase with a full year of access — not a subscription. There is no auto-renewal and nothing to cancel. You get unlimited retakes across both study modes for the duration, and our current buy-one-get-one-free offer lets you add a second practice exam at checkout at no extra cost.
Prepare now, pay over time with Affirm & Klarna
Split the cost of full exam access into scheduled payments at checkout with Affirm or Klarna — start preparing right away without paying it all up front. Choose your plan when you check out.
Get full MO-210 exam access
All five objective domains, both study modes, feature-by-purpose explanations, domain-level scoring, and unlimited retakes for a full year.
Buy one exam, get a second free — and it’s backed by our satisfaction guarantee.