MO-210 Excel Associate (Microsoft 365 Apps) Practice Exam
Prepare for Microsoft’s performance-based MO-210 exam across all five official skill areas — from managing workbooks and ranges to tables, formulas, and charts — with source-linked explanations, immediate feedback in Learn mode, and timed simulation in Exam mode.
Start 24-hour free trial →MO-210 exam at a glance
- Vendor
- Microsoft
- Exam code
- MO-210
- Certification
- Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps)
- Level
- Intermediate · Role: Business User
- Blueprint
- Exam MO-210 Skills Measured outline (current Microsoft 365 Apps edition)
- Format
- Performance-based, delivered live inside Excel; may include interactive/task-based components
- Duration
- 50 minutes
- Passing score
- 700 of 1000 (scaled)
- Delivery
- Proctored, scheduled through Certiport (Pearson VUE)
- Recommended experience
- ~150 hours of instruction and hands-on Excel practice
- Prerequisites
- None. Foundational familiarity with the Excel (Microsoft 365) environment is expected but not formally required.
- Cost (USD)
- Approximately $100 USD; priced by the country or region where the exam is proctored
- Validity
- MOS certifications do not expire; Microsoft periodically refreshes the underlying objectives
- Languages
- English, Arabic (Saudi Arabia), Chinese (Simplified), Chinese (Traditional), German, Greek, Spanish, French, Italian, Japanese, Polish, Dutch, Portuguese (Brazil), Russian, Vietnamese
Sources: Microsoft — Excel Associate (Microsoft 365 Apps) certification · Exam MO-210 Skills Measured outline. Verify current details with Microsoft and Certiport before scheduling.
About the MO-210 Excel Associate (Microsoft 365 Apps) certification
MO-210 is the current Microsoft Office Specialist (MOS) associate exam for Excel in the Microsoft 365 Apps environment. It replaces the retired Office 2019 MO-200 exam, and it validates that you can get real work done in the subscription version of Excel: creating and managing workbooks, working with cells and ranges, building tables, applying formulas and functions, and producing charts. Microsoft positions the credential at the intermediate level for a business-user role, and expects roughly 150 hours of hands-on experience before you sit it.
The most important thing to understand about MO-210 is how it is delivered. Unlike Microsoft’s role-based Azure exams, MO-210 is performance-based — you complete real tasks inside a live Excel instance through Certiport, rather than answering only multiple-choice questions. That means recognizing the right feature is not enough; you have to know where it lives and how to execute it. Study that is purely definitional tends to under-prepare candidates for the click-path muscle memory the exam rewards.
PowerKram’s MO-210 practice questions map to Microsoft’s five official skill areas and link each explanation to the exact Microsoft support page it derives from, so a wrong answer turns into a specific page to read rather than a vague gap. For a broader view of where Excel and data-literacy skills fit into an office-and-analysis career, see our business analyst certification guide.
MO-210 skill areas and weights
Microsoft’s published skills outline groups the exam into five areas with the weight ranges below. Managing workbooks and managing cells and ranges are the two heaviest areas — together roughly half to three-fifths of the exam — so weight your practice toward them first.
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/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.
Relative, absolute, mixed, and structured references; AVERAGE(), MAX(), MIN(), SUM(); COUNT(), COUNTA(), COUNTBLANK(); IF(); SORT() and UNIQUE(); text functions RIGHT/LEFT/MID, UPPER/LOWER/LEN, CONCAT and TEXTJOIN.
Create charts and chart sheets; add data series; switch rows/columns in source data; add and modify chart elements; apply chart layouts and styles; add alternative text for accessibility.
Create Excel tables from ranges; apply table styles; convert tables back to ranges; add/remove rows and columns; configure table style options and total rows; filter records and sort by multiple columns.
Source: Exam MO-210 — Microsoft Excel (Microsoft 365 Apps) Skills Measured outline, linked from the official certification page. Weight ranges are Microsoft’s; exact composition varies within the bands. Note: advanced dynamic-array functions such as FILTER, XLOOKUP, LET, and LAMBDA belong to the Expert exam (MO-211), not MO-210.
Who MO-210 is for
Microsoft classifies MO-210 as a business-user credential, and the audience is broad — anyone whose day involves real spreadsheets rather than code:
- Analysts, coordinators, and operations staff who live in Excel — budgets, invoices, trackers, data logs — and want a recognized credential that proves the fluency they already use daily.
- Administrative and finance-support roles where accurate, well-structured workbooks and clean formatting are part of the job description.
- Students and career-changers entering the job market who need a concrete, employer-recognized signal of Excel competence on a resume.
- Data-curious professionals using MO-210 as a stepping stone toward analysis-oriented tools — a natural on-ramp before Power BI (PL-300) or the Excel Expert exam.
If you already build advanced models with dynamic arrays, LAMBDA, Power Query, and PivotTables, MO-210 is below your level — go straight to the MO-211 Excel Expert exam. If you still work primarily in the desktop 2019 build, the MO-200 Excel 2019 Associate exam maps to that version. For the roles this credential supports — with salary ranges and progression paths — see the business analyst career path in our Career Hub.
What this MO-210 practice exam delivers
Learn mode
Get the correct answer, the reasoning, and a direct link to the exact Microsoft support page each question was derived from — immediately after each question. Best for feature-vs-feature decisions like co-authoring vs Track Changes, or structured references vs manual formulas.
Exam mode
Timed, randomized questions that build the recall speed the 50-minute performance-based exam demands. Practice matching each task to the right Excel feature under time pressure.
Source-linked explanations
Every answer cites the exact Microsoft support page (support.microsoft.com) the question was built from — so you learn from Microsoft’s own documentation of the feature, not just a memorized letter.
Score by skill area
Results break down by Microsoft’s five official areas — Worksheets & Workbooks, Cells & Ranges, Formulas & Functions, Charts, and Tables — so practice tells you exactly which area to revisit.
Sample MO-210 practice questions
Ten free questions across Microsoft’s five MO-210 skill areas, each with a full explanation and a source link to the Microsoft support page it derives from. The complete bank is available with the 24-hour trial.
A team collaborates on a budget in Excel for Microsoft 365. Multiple users need to edit the same workbook simultaneously with changes synced in real time. Which feature enables this concurrent editing?
- Protect the workbook with a password to restrict changes
- Enable Track Changes to record each person’s edits
- Co-authoring, with the workbook saved to OneDrive or SharePoint
- Email the file back and forth between team members
Show answer & explanation
Correct: C — Co-authoring. When the workbook is stored in a shared cloud location (OneDrive or SharePoint), co-authoring lets multiple people edit it at the same time with changes synced live for everyone.
Why not the others: Protecting the workbook (A) restricts changes rather than enabling shared editing. Track Changes (B) records edits sequentially but does not allow simultaneous access. Emailing the file (D) creates separate, diverging copies — the opposite of a single synced workbook.
Source: Microsoft Support — Co-authoring in Excel → Further reading: PowerKram — Business Analyst Certification Guide →Sheet1 contains calculations that reference cells in Sheet2 and Sheet3. An analyst needs to verify that all cross-sheet references are intact. Which tool visually traces these cell dependencies?
- Read through every formula manually in the formula bar, one cell at a time
- Trace Precedents and Trace Dependents from the Formulas tab
- Search each sheet name in Find & Replace to locate references
- Print all three sheets and compare the printouts side by side
Show answer & explanation
Correct: B — Trace Precedents and Trace Dependents. These formula-auditing tools draw directional arrows that map which cells feed a formula and which cells depend on it, including references that cross to other sheets.
Why not the others: Reading formulas one at a time (A) is slow and misses multi-level dependency chains. Find & Replace (C) locates text but does not map the relationships between cells. Printouts (D) show static values, not the live formula links.
Source: Microsoft Support — Trace formula relationships →A formula on a summary sheet repeatedly references the range B2:B50 on a “Sales” sheet. The analyst wants formulas to read clearly (for example, =SUM(Sales)) instead of using raw cell addresses. What should they define?
- A named range for B2:B50, then reference the name in formulas
- A macro that hard-codes the B2:B50 address into each formula
- A merged cell spanning the entire range
- An absolute reference $B$2:$B$50 typed into every formula
Show answer & explanation
Correct: A — A named range. Defining a name for B2:B50 lets you write readable, self-documenting formulas like =SUM(Sales), and the name updates everywhere it is used if you redefine its range.
Why not the others: A macro (B) adds code complexity for something Excel does natively. Merging cells (C) combines cells for display and would break the data, not reference it. An absolute reference (D) works but still shows raw addresses and must be retyped in each formula — it does not give the range a readable name.
Source: Microsoft Support — Define and use names in formulas → Further reading: PowerKram — Business Analyst Certification Guide →A data-entry clerk sometimes types dates that Excel interprets as text, which then breaks chronological sorting. Which approach best enforces consistent, valid date entry in a column?
- Format the column as Date and apply Data Validation that accepts only valid dates
- Let users type dates in any freestyle format and trust Excel to interpret them
- Format the cells as Text so entries are never changed
- Enter all dates as raw serial numbers with no date formatting
Show answer & explanation
Correct: A — Date format plus Data Validation. Pre-formatting the column as Date and restricting entry with Data Validation ensures every value is a real date, which keeps sorting and date arithmetic working correctly.
Why not the others: Freestyle entry (B) is exactly what causes the inconsistent text-vs-date problem. Text formatting (C) prevents all date calculations and sorting. Raw serial numbers (D) lose the human-readable date and are error-prone to enter.
Source: Microsoft Support — Apply data validation to cells → Further reading: PowerKram — IT Certifications Guide →An Excel Table named Sales needs a calculated column that multiplies Quantity by Unit_Price and automatically extends to new rows as they are added. Which formula approach fits best within a Table?
- Write a VBA macro that loops through rows inserting multiplication formulas
- Type a standard reference like =C2*D2 and copy it down for each new row
- Use a structured reference such as =[@Quantity]*[@Unit_Price]
- Use SUMPRODUCT to aggregate all rows into one total
Show answer & explanation
Correct: C — A structured reference. Inside an Excel Table, a structured reference like =[@Quantity]*[@Unit_Price] auto-fills the whole calculated column and extends automatically when new rows are added.
Why not the others: A VBA macro (A) is unnecessary code for a native Table feature. A standard reference like =C2*D2 (B) must be copied down manually and does not auto-extend. SUMPRODUCT (D) returns a single aggregate total, not a per-row result.
Source: Microsoft Support — Structured references in Excel tables → Further reading: PowerKram — Business Analyst Certification Guide →An analyst has a 50,000-row table and needs to remove every row where Status equals “Cancelled” in one efficient operation. Which method works best?
- Filter the table to Status = Cancelled, select the visible rows, and delete them
- Use Find & Replace to blank the Status cells
- Scroll through all 50,000 rows and delete each Cancelled row individually
- Sort by Status and hope the Cancelled rows group together for easy deletion
Show answer & explanation
Correct: A — Filter, then delete the visible rows. Filtering isolates only the Cancelled rows so you can select and delete that set in one bulk operation, leaving the rest of the table intact.
Why not the others: Find & Replace (B) only blanks the Status cells, leaving the rows in place. Row-by-row deletion (C) is impractical at 50,000 rows. Sorting (D) may group the rows but still requires manual selection and does not remove anything by itself.
Source: Microsoft Support — Filter data in a range or table →A column contains duplicate customer names. An analyst needs to produce the list of distinct names as a spilled array, without adding helper columns. Which Microsoft 365 function does this?
- VLOOKUP
- COUNTIF
- UNIQUE
- SUMIF
Show answer & explanation
Correct: C — UNIQUE. UNIQUE() returns the distinct values from a range as a dynamic spilled array, removing duplicates without helper columns. It is one of the two dynamic-array functions (with SORT) named in the MO-210 outline.
Why not the others: VLOOKUP (A) retrieves a single matching value per lookup. COUNTIF (B) counts occurrences but does not return the distinct values. SUMIF (D) totals values by condition rather than listing unique entries.
Source: Microsoft Support — UNIQUE function → Further reading: PowerKram — IT Certifications Guide →A teacher wants a list of student names sorted alphabetically by formula, so the sorted list updates automatically whenever new names are added. Which Microsoft 365 function does this?
- SORT
- RANK
- INDEX
- LARGE
Show answer & explanation
Correct: A — SORT. SORT() returns a range in sorted order as a dynamic spilled array that recalculates automatically when the source data changes or new entries are added.
Why not the others: RANK (B) assigns rank numbers but does not reorder the values. INDEX (C) retrieves a value at a given position without sorting. LARGE (D) returns the nth largest numeric value, not a sorted list of text names.
Source: Microsoft Support — SORT function →An analyst has monthly revenue by region and wants a single visual that compares regions across months. After selecting the data range, what is the correct first step to build the chart?
- On the Insert tab, choose a chart type (for example, a clustered column chart)
- Apply conditional formatting color scales to the data cells
- Convert the range to a PivotTable before any chart can be created
- Merge the header cells so the chart can read the labels
Show answer & explanation
Correct: A — Insert tab, choose a chart type. With the data selected, you create a chart from the Insert tab by picking a chart type such as a clustered column chart; Excel then plots the series and you can refine elements, layout, and style.
Why not the others: Conditional formatting (B) colors cells but does not create a chart. A PivotTable (C) is one option for summarizing data but is not required to chart a normal range. Merging header cells (D) can actually confuse the chart’s axis labels.
Source: Microsoft Support — Create a chart from start to finish →A user has a plain range of sales data with headers and wants to turn it into a structured Excel Table so they get filter buttons, banded rows, and a total row. What is the correct action?
- Select the range and use Insert > Table (or Format as Table)
- Apply a cell style named “Table” to the header row only
- Freeze the top row so the headers stay visible
- Group the rows using the Outline feature
Show answer & explanation
Correct: A — Insert > Table (or Format as Table). Converting a range to an Excel Table gives you automatic filter buttons, banded row styling, structured references, and an optional total row, and it auto-expands as you add data.
Why not the others: A cell style (B) only changes appearance, not table behavior. Freezing the top row (C) keeps headers visible but does not create a Table. Grouping with Outline (D) collapses rows for summary but is not a Table.
Source: Microsoft Support — Create and format Excel tables →Keep going: Learning & Career resources
MO-210 proves practical Excel fluency — a skill that shows up in analyst, operations, and administrative roles across every industry. Two PowerKram hubs back this exam.
Deep dive: MO-210 format, scoring, study path, and how it differs from MO-200 and MO-211
Exam format and scoring
MO-210 is a 50-minute, proctored, performance-based exam scheduled through Certiport. Rather than a pure multiple-choice test, it presents tasks completed in a live Excel environment and may include interactive components, so you are graded on doing the work, not only recognizing the right term. The exam is scored on a 1000-point scale with 700 as the passing mark. Practicing feature-to-task matching — which our sample questions model — builds the recall you need to execute quickly under the clock. Read how certification exams are structured →
How MO-210 differs from MO-200
MO-210 is the Microsoft 365 Apps successor to the retired Office 2019 MO-200 Excel Associate exam. The skill areas are broadly similar, but MO-210 reflects the subscription version of Excel — including cloud collaboration through co-authoring and a small set of dynamic-array functions (SORT and UNIQUE) that the older desktop exam did not test. If you are studying from 2019-era material, expect gaps around cloud features and the newer functions. Compare with the MO-200 Excel 2019 exam →
How MO-210 differs from MO-211 (Expert)
MO-210 (Associate) covers core, everyday Excel: workbooks, cells and ranges, tables, basic-to-intermediate formulas, and charts. The Expert exam, MO-211, adds advanced dynamic arrays (FILTER, XLOOKUP), LET and LAMBDA, advanced conditional formatting, PivotTables, Power Pivot data modeling, and Power Query. A common trap is studying FILTER or XLOOKUP for MO-210 — those are Expert-level and out of scope here. Know SORT and UNIQUE for the Associate exam; save the rest for MO-211. See the MO-211 Excel Expert exam →
Realistic study path
Microsoft suggests roughly 150 hours of hands-on experience for this level. A practical plan: work through Excel with real files — a budget, an invoice log, a small dataset — so the click paths become second nature; drill the two heaviest areas (Worksheets & Workbooks and Cells & Ranges) first, since together they can be up to 60% of the exam; then use PowerKram Learn mode to map any weak feature back to the exact Microsoft page, and finish with timed Exam mode runs to build speed for the 50-minute limit. Read the business analyst study guide →
Where this certification leads
MOS Excel Associate is a resume-level signal rather than a senior-role gate: it is most valuable to analysts, coordinators, administrators, and career-changers who need employer-recognized proof of Excel competence. It stacks naturally toward data-analysis credentials — a sensible next step is Power BI (PL-300) for reporting, or the Excel Expert exam (MO-211) for advanced modeling. For role-by-role salary ranges and progression, the Career Hub is the place to look. Career Hub — business analyst roles →
Frequently asked questions about MO-210
What are the MO-210 skill areas and weights?
Is MO-210 multiple choice or hands-on?
What is the MO-210 passing score and time limit?
Does the MO-210 certification expire?
What is the difference between MO-210 and MO-211?
Start your free 24-hour MO-210 practice trial
Full access to 800+ questions across all five Excel skill areas, both study modes, and source-linked explanations. No credit card required.
Start free trial →