MO-210

Excel Associate MO-210 practice exams

290 questions in 5 timed practice tests. Each test has about 60 questions and a 60-minute limit. The pass mark is 70%. Results are split across the 5 exam domains.

Exam at a glance

MO-210 practice exam settings
Practice tests 5
Questions in total 290
Questions per test About 60
Time limit per test 60 minutes
Pass mark 70%
Question types Single answer and multiple answer (26 multiple-answer questions)
Level Associate
Category Productivity & Microsoft 365

These are the settings of our practice tests. Check the official Microsoft exam page for the current exam format before you book.

Domains and weights

MO-210 exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Manage worksheets and workbooks 13% 37
Manage data cells and ranges 23% 67
Manage tables and table data 18% 52
Perform operations by using formulas and functions 23% 67
Manage charts 23% 67

Sample questions

Question 1 of 3

A colleague emails you a comma-delimited file named orders.csv. You must bring its contents into a new worksheet in your open workbook so that you can preview the columns and adjust data types before loading. Which command should you use?

  1. A Home > Paste > Paste Special > Text
  2. B Insert > Object > Create from File
  3. C Data > Get Data group > From Text/CSV (correct answer)
  4. D File > Open > Browse, then open the file directly
Why: From Text/CSV (Data tab, Get & Transform Data group) opens a preview where you can check the delimiter and data types and then Load or Transform the data into the current workbook. Insert Object embeds the file as an icon or object rather than importing rows. Paste Special > Text needs the data already on the Clipboard and offers no data-type preview. Opening the file through File > Open creates a separate workbook rather than importing into the open one.

Question 2 of 3

A workbook contains hundreds of rows. You need to locate every cell that contains the text "Overdue" and see a list of their addresses at once. What should you do?

  1. A Press Ctrl+G, type Overdue in the Reference box, and press Enter
  2. B Apply a Text Filter to the active column for Overdue
  3. C Press Ctrl+F, type Overdue, and select Find All (correct answer)
  4. D Use Home > Find & Select > Go To Special > Constants
Why: Find All in the Find and Replace dialog lists every matching cell with its sheet, cell address and value, and you can select them from the list. The Go To Reference box expects a cell address or name, not a text value. A filter works on one column of a range and hides rows rather than listing addresses. Go To Special > Constants selects all typed values, not only cells containing Overdue.

Question 3 of 3

You need every order value above 1,000 in C2:C200 to show with a light red fill automatically. Which feature should you use?

  1. A Cell Styles > Bad
  2. B Data Validation with a decimal minimum of 1,000
  3. C Conditional Formatting > Highlight Cells Rules > Greater Than (correct answer)
  4. D Sort C2:C200 largest to smallest, then apply a light red fill with Format Cells
Why: Highlight Cells Rules > Greater Than applies a format only to cells that meet the condition and updates as values change. A manually applied fill after sorting is static and does not update when values change. The Bad cell style is static formatting. Data Validation restricts entries but does not format them.

What your score report looks like

Example attempt, MO-210 practice test 3

76%

Passed
Pass mark 70%

Score by exam domain
DomainWeightYour score%
Manage worksheets and workbooks 13%
88
Manage data cells and ranges 23%
81
Manage tables and table data 18%
76
Perform operations by using formulas and functions 23%
58
Manage charts 23%
84

Study next: Perform operations by using formulas and functions. It is below the pass mark and carries 23% of the exam.

Domains and pass mark from our MO-210 practice tests. Scores are an example attempt.

Study plans

Two weeks

  1. Day 1: take practice test 1 in exam mode to get a baseline.
  2. Days 2 to 5: domain mode on Manage data cells and ranges and Perform operations by using formulas and functions, the two most heavily weighted domains.
  3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
  4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
  5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

Four weeks

  1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
  2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
  3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
  4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

Questions about the MO-210 practice exams

Are these real MO-210 exam questions?
No. We write every question ourselves and map it to the published MO-210 exam objectives. We do not use leaked or recalled questions.
Do the time limit and pass mark match the official exam?
They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
Can I try it before I pay?
Yes. The free mini exam has 15 questions with full explanations and needs no account.
How long do I keep access?
A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
What happens after I finish a test?
You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with Microsoft. MO-210 and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
AB-100AB-100 Agentic AI Business Solutions Architect Microsoft Professional 250 100 $14.99
AB-730AI Business Professional AB-730 Microsoft Professional 250 100 $14.99
AZ-305Azure Solutions Architect AZ-305 Microsoft Professional 250 100 $14.99
SC-100Cybersecurity Architect SC-100 Microsoft Professional 250 120 $14.99
AZ-140Azure Virtual Desktop AZ-140 Microsoft Specialty 251 100 $14.99
DP-420Microsoft DP-420 Microsoft Specialty 250 100 $14.99