100+ Free MOS Excel Expert (MO-211) Practice Questions

Pass your Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately

Not publicly published Pass Rate

100+ Questions

100% Free

1 / 100

Question 1

Score: 0/0

You want to save an Excel workbook so colleagues can open it as a starting point but cannot accidentally overwrite the original. Which file format should you use?

.xlsx

.xltx

.xlsb

.csv

to track

2026 Statistics

Key Facts: MOS Excel Expert (MO-211) Exam

~35

Performance-Based Tasks

Microsoft Learn MO-211 page

50 min

Time Limit

Microsoft Learn MO-211 page

700/1000

Passing Score

Microsoft MOS scoring standard

US$100

Exam Fee (US list)

Certiport / Microsoft Learn

No expiration

Certification Validity

Microsoft MOS program FAQ

Microsoft 365 Apps

Tested Excel Build

Microsoft Learn MO-211 page

MO-211 is a 50-minute, performance-based Excel Expert exam delivered through Certiport on Microsoft 365 Apps. Microsoft Learn lists approximately 35 tasks, a US$100 fee, and a 700/1000 passing score. MOS certifications do not expire, but the underlying exam objectives are refreshed when Microsoft updates Excel for Microsoft 365.

Sample MOS Excel Expert (MO-211) Practice Questions

Try these sample questions to test your MOS Excel Expert (MO-211) exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1You want to save an Excel workbook so colleagues can open it as a starting point but cannot accidentally overwrite the original. Which file format should you use?

A..xlsx

B..xltx

C..xlsb

D..csv

Explanation: The .xltx extension is the Excel Template format. When a user double-clicks an .xltx file, Excel opens a new workbook based on the template, leaving the original file untouched.

2Which file format must you use for a template that contains recorded macros?

A..xltx

B..xltm

C..xlsx

D..xlsm

Explanation: An .xltm file is a macro-enabled Excel template. It behaves like a template (opens a new copy) but allows VBA macros, which the .xltx format strips out.

3A linked formula in your workbook reads =[Budget.xlsx]Sheet1!$B$5. The source workbook has been moved to C:\Finance\2026\. What happens when you reopen your workbook?

A.Excel automatically searches the entire C: drive for Budget.xlsx

B.Excel prompts you to update links and may show #REF! until you supply the new path

C.Excel ignores the link and shows 0

D.Excel converts the linked formula to a static value

Explanation: When the source workbook is missing or moved, Excel cannot resolve the link automatically. It shows a security/update-links prompt and you must use Edit Links to point to the new file location, otherwise cells display the last cached value or #REF!.

4An accountant wants Excel to recalculate formulas only when she presses F9, not after every cell edit. Which calculation setting should she choose?

A.Automatic

B.Automatic except for data tables

C.Manual

D.Iterative calculation

Explanation: Manual calculation mode (File > Options > Formulas, or Formulas > Calculation Options > Manual) suspends recalculation until F9 (recalc all open workbooks) or Shift+F9 (recalc active sheet) is pressed.

5Where do you enable iterative calculation so a circular reference can resolve to a stable value?

A.Formulas > Trace Precedents

B.File > Options > Formulas > Enable iterative calculation

C.Data > What-If Analysis > Goal Seek

D.Review > Workbook Statistics

Explanation: Iterative calculation is toggled in File > Options > Formulas. You set the maximum number of iterations and the maximum change between iterations; Excel then loops until the change is below the threshold or it hits the iteration limit.

6Before sharing a confidential workbook, which feature scans for hidden rows, comments, personal info, and embedded documents?

A.Inspect Document

B.Check Compatibility

C.Check Accessibility

D.Mark as Final

Explanation: File > Info > Check for Issues > Inspect Document opens the Document Inspector, which scans for and optionally removes hidden content such as comments, document properties, hidden rows/columns/sheets, and embedded objects.

7A shared workbook is opened by another user and Excel reports it is corrupted. Which feature attempts to recover formulas and values?

A.File > Open > Open and Repair

B.File > Recent > Recover Unsaved Workbooks

C.Review > Protect Workbook

D.Data > Refresh All

Explanation: From File > Open, browse to the file, click the arrow next to the Open button, and choose Open and Repair. Excel attempts to recover formulas and values; if full repair fails, Extract Data extracts what it can.

8Which property field in File > Info lets you tag a workbook with searchable terms like 'Q1', 'forecast', and 'audited'?

A.Title

B.Subject

C.Tags

D.Status

Explanation: The Tags property (also called Keywords in some Office versions) accepts comma-separated terms that Windows Search and SharePoint metadata indexes for discovery.

9You apply a custom theme containing fonts, colors, and effects. Where is the theme saved so other workbooks can reuse it?

A.Inside the workbook only

B.As a .thmx file in the Document Themes folder

C.In the Excel registry hive

D.As a .xltx template only

Explanation: Saving a custom theme via Page Layout > Themes > Save Current Theme writes a .thmx file (default location: AppData\Roaming\Microsoft\Templates\Document Themes). Any Office app can then apply it.

10You want cell B2 to accept only dates between 1/1/2026 and 12/31/2026 inclusive. Which Data Validation setup is correct?

A.Allow: Whole number, Between 1/1/2026 and 12/31/2026

B.Allow: Date, Between 1/1/2026 and 12/31/2026

C.Allow: List, Source = 1/1/2026:12/31/2026

D.Allow: Custom, Formula = TODAY()

Explanation: On the Data Validation Settings tab, choose Allow: Date, Data: between, Start date: 1/1/2026, End date: 12/31/2026. Excel stores dates as serial numbers and the Date option enforces the range.

About the MOS Excel Expert (MO-211) Exam

MO-211 is the current Microsoft Office Specialist: Excel Expert exam built on Microsoft 365 Apps. The exam is delivered live inside Excel by Certiport, so candidates complete real Excel tasks rather than answering multiple-choice questions. Skill areas span advanced workbook management, advanced data and conditional formatting, advanced formulas (including dynamic arrays, LET, LAMBDA, XLOOKUP, and the LAMBDA helpers), advanced charts (Box & Whisker, Histogram, Sunburst, Treemap, Waterfall, Funnel, Map, Combo), PivotTables, Power Pivot data modeling, and Power Query data shaping.

Assessment

Approximately 35 task-based, performance-based items completed in a live Excel environment; tasks may include multiple sub-actions

Time Limit

50 minutes

Passing Score

700 out of 1000 (per Microsoft Learn standard MOS scoring)

Exam Fee

US$100 (US list price; varies by country and Certiport authorized testing center) (Microsoft)

MOS Excel Expert (MO-211) Exam Content Outline

10-15%

Manage workbook options and settings

Templates (.xltx, .xltm), external links, calculation options, iterative settings, document inspection, properties, themes, repair, and protection.

20-25%

Manage and format data

Data validation (lists, custom formulas, dependent dropdowns), advanced conditional formatting (formula-based, icon sets, color scales, manage rules), custom number formats, and advanced filtering.

30-35%

Create advanced formulas and macros

Dynamic arrays (FILTER, SORT, UNIQUE, SEQUENCE, RANDARRAY), LET, LAMBDA, LAMBDA helpers (MAP, REDUCE, SCAN, BYROW, BYCOL), XLOOKUP, XMATCH, text functions, advanced date/time, financial functions, IFS/SWITCH/IFNA, and macro recording in M365.

25-30%

Manage advanced charts and tables

PivotTables (calculated fields, slicers, timelines, value field settings, GETPIVOTDATA), PivotCharts, advanced chart types (Box & Whisker, Histogram, Pareto, Sunburst, Treemap, Waterfall, Funnel, Map, Combo, sparklines, trendlines), Power Pivot data model, DAX measures, KPIs, and Power Query.

How to Pass the MOS Excel Expert (MO-211) Exam

What You Need to Know

Passing score: 700 out of 1000 (per Microsoft Learn standard MOS scoring)
Assessment: Approximately 35 task-based, performance-based items completed in a live Excel environment; tasks may include multiple sub-actions
Time limit: 50 minutes
Exam fee: US$100 (US list price; varies by country and Certiport authorized testing center)

Keys to Passing

Complete 500+ practice questions
Score 80%+ consistently before scheduling
Focus on highest-weighted sections
Use our AI tutor for tough concepts

MOS Excel Expert (MO-211) Study Tips from Top Performers

1Practice in actual Excel for Microsoft 365, not in older versions or Excel Online; the MO-211 environment matches the desktop M365 build with full ribbon, dynamic arrays, and Power Query.

2Memorize the dynamic array spill behavior: the # spilled range operator, the @ implicit intersection operator, and the most common cause of #SPILL! (cells in the spill range are not empty).

3Drill XLOOKUP arguments in this order until automatic: lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]. Know binary search modes 2 and -2 for sorted data.

4Build at least one workbook with a Power Pivot data model containing two tables, a relationship on a key column, and a DAX measure displayed in a PivotTable so the workflow becomes mechanical.

5Practice creating each advanced chart type at least once: Box & Whisker, Histogram, Pareto, Sunburst, Treemap, Waterfall, Funnel, Filled Map, Combo, and sparklines. The exam expects you to pick the right chart for the scenario.

6Get fluent with conditional formatting rules using formulas (=$D2="Overdue" applied to entire rows), icon sets with custom Number thresholds, and Manage Rules > Stop If True for layered rules.

7Time yourself: 50 minutes for ~35 tasks averages roughly 85 seconds per task. If a task stalls more than two minutes, mark it (mentally) and move on - you can return if time allows.

Frequently Asked Questions

How many questions are on the MOS Excel Expert MO-211 exam?

Microsoft Learn describes MO-211 as a performance-based exam consisting of approximately 35 tasks completed inside a live Excel environment. Each task may include several sub-actions you must complete using the actual application, which is why the exam length is measured in tasks rather than multiple-choice questions.

How long is the exam and how is it scored?

MO-211 is timed at 50 minutes. Microsoft scores MOS exams on a scale of 0 to 1,000 with a passing score of 700. Tasks are auto-graded based on the state of the workbook when you finish, so partial credit may apply when only some sub-steps are correct.

What does MO-211 cost and where do I take it?

The standard US list price is US$100 per attempt, though authorized Certiport testing centers, schools, and bundles can change the final price. The exam is delivered exclusively through Certiport, either at a physical Certiport Authorized Testing Center or via Certiport's online proctored option where available.

Does the MOS Excel Expert certification expire?

No. Microsoft Office Specialist certifications, including MOS Excel Expert MO-211, do not expire. Microsoft does periodically refresh the underlying exam objectives or retire older versions (for example, the legacy Office 2019 Excel Expert exams have been retired in favor of the current Microsoft 365 Apps version), but the certification you already hold remains valid.

What is the difference between MOS Associate Excel and MOS Expert MO-211?

The associate-level Excel exam (MO-210) covers core skills like managing workbooks, cells, ranges, tables, formulas, and basic charts. MO-211 (Expert) builds on those skills and adds advanced workbook management, advanced conditional formatting, advanced formulas including dynamic arrays and LAMBDA, advanced PivotTables, the data model in Power Pivot, and Power Query workflows.

Which Excel features matter most for MO-211 in 2026?

On Microsoft 365 Apps, expect heavy emphasis on dynamic array functions (FILTER, SORT, UNIQUE, SEQUENCE, RANDARRAY), LET, LAMBDA and the helper functions, XLOOKUP and XMATCH with binary search, advanced PivotTables and PivotCharts, the modern advanced charts (Box & Whisker, Histogram, Pareto, Sunburst, Treemap, Waterfall, Funnel, Map, Combo), Power Pivot relationships and DAX measures, and Power Query Get & Transform tasks.