# Excel Expert MO-211 practice exams

> 5 timed MO-211 practice tests with 290 questions and a 70% pass mark. See your score in Manage and format data and every other domain.

Page: https://devopscodelab.com/exams/microsoft-mo-211/

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 4 exam domains.

## Exam at a glance

| Setting | Value |
| --- | --- |
| 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 (18 multiple-answer questions) |
| Level | Expert |
| Category | Productivity & Microsoft 365 |

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

## Domains and weights

| Domain | Weight | Questions in our bank |
| --- | --- | --- |
| Manage workbook options and settings | 13% | 38 |
| Manage and format data | 32% | 93 |
| Create advanced formulas and macros | 28% | 81 |
| Manage advanced charts and tables | 27% | 78 |

## Price and access

- MO-211 practice exams: $14.99 for 12 months of access.
- Free mini exam: 15 questions with explanations (free account): https://devopscodelab.com/app/exams/microsoft-mo-211/mini/
- All-Access subscription includes every exam: https://devopscodelab.com/pricing/
- 10 free questions with answers: https://devopscodelab.com/exams/microsoft-mo-211/free-practice-questions/

## Sample questions

### Question 1 of 3

You recorded a macro named FormatHeaders in Report.xlsm and now need the same macro inside Budget.xlsm so that it travels with that file. Both workbooks are open. What is the most direct way to copy it?

- A. In the Visual Basic Editor, drag the module that contains FormatHeaders from the Report.xlsm project onto the Budget.xlsm project in Project Explorer
- B. Copy the worksheet that ran the macro from Report.xlsm into Budget.xlsm by right-clicking its tab and using Move or Copy with Create a copy selected
- C. In the Macros dialog box, select FormatHeaders, choose Options, and change the Macros in list to Budget.xlsm
- D. Save Report.xlsm as an Excel Macro-Enabled Template and then create Budget.xlsm again from that template

**Answer:** A

**Explanation:** Macros live in VBA modules, so dragging the module between projects in the Visual Basic Editor's Project Explorer copies the code into the other workbook. The Macros dialog's Options button only sets a shortcut key and description; it cannot relocate code. Rebuilding Budget.xlsm from a template would discard its existing content. Copying a worksheet copies only that sheet's own code module, not a standard module where recorded macros are stored.

### Question 2 of 3

You need to display cell values as positive numbers with a thousands separator, negative numbers in parentheses, zeros as a dash, and any text with the prefix Note: in front. How many sections must your custom format contain?

- A. One section with conditions written in square brackets for each case
- B. Four sections separated by semicolons: positive, negative, zero, and text
- C. Two sections separated by commas, the first for all numbers and the second for any text entries
- D. Three sections separated by semicolons: positive, negative, and text

**Answer:** B

**Explanation:** Custom number formats support up to four sections separated by semicolons, applied in the order positive, negative, zero and text, so all four requirements need four sections. Three sections apply to positive, negative and zero, leaving no text section. Commas act as thousands separators or scaling characters, not section separators. Conditional brackets allow only a limited number of conditions and cannot handle text formatting.

### Question 3 of 3

Cells in column E contain values such as 0.25 and -0.1. They must display as 25% Increase in green for positive values, 10% Decrease in red for negative values, and the word Flat for zero. Which custom number format meets the requirement?

- A. [Green]0% "Increase";"Flat";[Red]0% "Decrease"
- B. [Red]0% "Decrease";[Green]0% "Increase";"Flat"
- C. [Green]0% "Increase";[Red]-0% "Decrease";0% "Flat"
- D. [Green]0% "Increase";[Red]0% "Decrease";"Flat"

**Answer:** D

**Explanation:** Custom formats use the section order positive;negative;zero, and the negative section shows the absolute value unless a minus sign is added, so 0% Decrease displays 10% Decrease. Adding a minus sign to the negative section shows -10% Decrease, and 0% Flat shows 0% before the word. Swapping the first two sections labels positive numbers as decreases. Putting Flat in the second section applies it to negative numbers.


## 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 and format data and Create advanced formulas and macros, 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-211 practice exams

**Are these real MO-211 exam questions?**

No. We write every question ourselves and map it to the published MO-211 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.

DevOpsCode Lab is not affiliated with Microsoft. MO-211 and related names are trademarks of their owners. We write every question ourselves; these are not real exam questions.
