PracticeVideosBlogFlashcardsEspañol
All Practice Exams

Free Practice Questions for MO-211

Exam-style questions and explanations by OpenExamPrep.

✓ No registration✓ No credit card
415+ Questions
100% Free

Loading practice questions...

Same family resources

Explore More Microsoft Certifications

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

Microsoft Power BI Data Analyst

Practice QuestionsStudy GuideCheat SheetFlashcards4 videos4 blogs

Microsoft 365 Administrator Expert (MS-102)

Practice QuestionsStudy GuideCheat SheetFlashcards3 videos3 blogs

Microsoft 365 Endpoint Administrator (MD-102)

Practice QuestionsStudy GuideCheat SheetFlashcards2 videos2 blogs

Microsoft Certified: Information Security Administrator Associate (SC-401)

Practice QuestionsStudy Guide2 videos2 blogs

Microsoft Power Platform Functional Consultant

Practice QuestionsStudy Guide2 videos2 blogs

Microsoft Certified: Security, Compliance, and Identity Fundamentals (SC-900)

Practice QuestionsStudy GuideCheat SheetFlashcards2 videos2 blogs

More From This Family

Videos and articles for deeper review.

VideoFREE DP-600 Exam Guide 2026: Pass Microsoft Fabric Analytics Engineer (Direct Lake, DAX, Semantic Models)VideoFREE MD-102 Exam Guide 2026: Pass Microsoft Endpoint Administrator (Intune, Autopilot, Windows 11)VideoFREE MS-102 Exam Guide 2026: Pass Microsoft 365 Administrator (Entra, Defender XDR, Purview)VideoIs PL-300 Worth It in 2026? Power BI Salary & Career RealityArticlePL-200 Exam Guide 2026: Skills, Retirement, and Renewal12 min readArticlePL-400 Exam Guide 2026: Skills, Format, and Renewal12 min readArticlePL-900 Exam Guide 2026: Current Outline and Free Prep19 min readArticleMS-900 Retired 2026: FREE Guide + AB-900 Pivot17 min read
Exam Review

Key Facts: MO-211 Exam

5-8

Exam Projects

Certiport

700/1000

Passing Score

Certiport

50 min

Exam Duration

Certiport

~$100

Exam Fee

Certiport

4

Exam Domains

MO-211 Skills Outline

Never

Expiration

Does not expire

The MO-211 Microsoft Excel Expert exam is a 50-minute live-in-the-application test in which candidates complete 5 to 8 projects of 1 to 7 tasks each, with the passing standard equated to 700 on Certiport's 1-1000 scale. Official domains: Manage workbook options and settings (10-15%), Manage and format data (30-35%), Create advanced formulas and macros (25-30%), Manage advanced charts and tables (25-30%). No prerequisites, but intermediate Excel experience is strongly recommended. Certification does not expire.

Sample MO-211 Practice Questions

Try these sample questions to review concepts for the MO-211 exam. Each question includes a detailed explanation. Start the interactive quiz above for the full 415+ question experience with AI tutoring.

1Which Excel function returns a dynamic array of unique values from a range, automatically spilling results into adjacent cells?
A.=DISTINCT
B.=UNIQUE
C.=REMOVEDUPS
D.=FILTER
Explanation: =UNIQUE(array,[by_col],[exactly_once]) returns a dynamic array of distinct values from a range or array, spilling results automatically. =FILTER returns rows meeting a condition, =DISTINCT does not exist, and =REMOVEDUPS does not exist as a worksheet function.
2A formula =FILTER(A2:C50,B2:B50>1000) returns the error #CALC!. What is the most likely cause?
A.The range A2:C50 contains merged cells
B.No rows in B2:B50 satisfy the condition B>1000
C.The FILTER function is not available in this version of Excel
D.The spill range contains existing data blocking the results
Explanation: =FILTER returns #CALC! when no rows meet the specified condition and no if_empty argument is provided. Providing a third argument such as =FILTER(A2:C50,B2:B50>1000,"No results") prevents the error. A blocked spill range returns #SPILL!, not #CALC!.
3Which formula generates a sequential list of integers from 1 to 10 that spills automatically into cells below the formula cell?
A.=SEQUENCE(10)
B.=ROW(A1:A10)
C.=SERIES(1,10)
D.=ARRAY(1,10)
Explanation: =SEQUENCE(rows,[cols],[start],[step]) generates a dynamic array of sequential numbers. =SEQUENCE(10) creates a single column of 10 integers starting at 1. =ROW returns row numbers but does not spill as a dynamic array in the same way, =SERIES and =ARRAY are not valid Excel worksheet functions.
4A user writes =LET(x,FILTER(A2:A100,B2:B100="East"),SUM(x)). What does this formula accomplish?
A.It defines a named range called x for the entire workbook
B.It filters column A for East rows, stores the result in a local variable x, then sums it
C.It creates a permanent named formula saved in the Name Manager
D.It returns an error because LET cannot wrap FILTER
Explanation: =LET(name,value,...,calculation) assigns local variable names within a formula. Here x holds the filtered array from column A where B equals East, and SUM(x) totals it. The variable x is local to the formula and is not stored in the Name Manager.
5Which formula correctly defines a LAMBDA function named DoubleIt that accepts one argument and returns twice its value, stored via the Name Manager?
A.=LAMBDA(x, x*2)
B.=LAMBDA(DoubleIt, x, x*2)
C.=DEFINE(DoubleIt, x, x*2)
D.=FUNCTION(x, x*2)
Explanation: A LAMBDA is created with =LAMBDA(parameter1,...,calculation). When saved in the Name Manager under a name such as DoubleIt, the formula stored as the Refers To value is =LAMBDA(x,x*2). The function name itself is the Name Manager entry name, not an argument to LAMBDA. =DEFINE and =FUNCTION do not exist.
6=MAP(A2:A10, LAMBDA(val, val^2)) — what does this formula return?
A.The sum of squares of A2:A10
B.A dynamic array where each element is the square of the corresponding value in A2:A10
C.The maximum squared value in A2:A10
D.An error because MAP requires two arrays
Explanation: =MAP(array1,[array2,...],lambda) applies a LAMBDA to each element of one or more arrays and returns an array of the same size. Here each value in A2:A10 is squared, producing a 9-element spilled array. It does not aggregate; aggregation requires REDUCE or wrapping in SUM.
7What does =REDUCE(0, A2:A10, LAMBDA(acc, val, acc+val)) calculate?
A.The running total in a spilled array
B.The single cumulative sum of A2:A10, equivalent to SUM(A2:A10)
C.The product of all values in A2:A10
D.An error because REDUCE needs a text initial value
Explanation: =REDUCE(initial_value, array, lambda) applies the lambda iteratively, accumulating a single result. Starting at 0 and adding each element produces the total sum of A2:A10, equivalent to SUM. It returns one value, not a spilled array. Changing acc+val to acc*val would give the product.
8A formula =SORT(A2:C20,3,-1) is entered. What does the -1 argument control?
A.Sort by column 3 in descending order
B.Sort by row 3 in descending order
C.Sort 3 levels deep
D.Sort the third array in a multi-array input
Explanation: =SORT(array,[sort_index],[sort_order],[by_col]) — the third argument sort_order accepts 1 for ascending and -1 for descending. The second argument 3 specifies the sort key column. Combined, this sorts the range by column 3 in descending order, spilling the sorted array.
9Which formula uses INDIRECT to sum a named range whose name is stored as text in cell A1?
A.=SUM(INDIRECT(A1))
B.=SUM(NAME(A1))
C.=SUM(REF(A1))
D.=INDIRECT(SUM(A1))
Explanation: =INDIRECT(ref_text) converts a text string into a live cell or range reference. If A1 contains "SalesData", =SUM(INDIRECT(A1)) resolves to =SUM(SalesData). =NAME and =REF are not valid functions, and =INDIRECT(SUM(A1)) attempts to convert a numeric sum into a reference, which is invalid.
10=OFFSET(B2,3,1,4,2) — which range does this formula reference?
A.E6:F9
B.C5:D8
C.B5:C8
D.C6:D9
Explanation: =OFFSET(reference, rows, cols, [height], [width]) starts at B2, moves 3 rows down (row 5) and 1 column right (column C), then spans 4 rows tall and 2 columns wide, yielding C5:D8. Row 2+3=5, col B+1=C, height 4 → rows 5-8, width 2 → cols C-D.

About the MO-211 Exam

The MO-211 exam validates expert-level skills in Microsoft Excel for Microsoft 365 Apps. It tests advanced capabilities including complex formula construction (XLOOKUP, INDEX/MATCH, nested logical and conditional-aggregate functions), custom number formats and data validation, advanced conditional formatting, data analysis with Consolidate, Goal Seek, Scenario Manager, PMT and NPER, macro recording, advanced PivotTables and PivotCharts, and advanced chart types such as histograms and waterfall charts. This is the highest-level MOS Excel certification available.

Exam sponsor: Certiport (Pearson VUE). The requirements and fees below concern the certification or admission exam, separate from our free practice resources.

Assessment

A 50-minute live-in-the-application (LITA) exam delivered by Certiport. Candidates complete 5 to 8 projects, each containing 1 to 7 tasks, working inside a real Microsoft 365 Excel session; the engine scores the final workbook state rather than the steps taken.

Time Limit

50 minutes

Passing Score

700 out of 1000

Exam / Certification Fees

$100

Exam sponsor website

Fees, eligibility, and exam policies can change. Confirm them with the exam sponsor before applying or paying.

Our practice resources: topics covered

We aim to reflect publicly available exam outlines and topic information in our study resources. Coverage, format, and difficulty may differ from the actual exam, and we cannot guarantee that every detail is accurate or current. Confirm exam requirements, fees, and policies with the official exam sponsor.

10-15%

Manage workbook options and settings

Copy macros between workbooks, reference data in other workbooks with external and 3-D references, enable macros and configure Trust Center settings, manage workbook versions and AutoRecover drafts, restrict editing, protect worksheets and cell ranges, protect workbook structure, and configure formula calculation options including iterative calculation

30-35%

Manage and format data

Fill cells using Flash Fill and advanced Fill Series options (linear, growth, date, trend), generate numeric data with RANDARRAY(), create custom number formats, configure data validation rules and custom validation formulas, group and ungroup data into outlines, insert subtotals and totals, remove duplicate records, and create and manage custom and formula-driven conditional formatting rules

25-30%

Create advanced formulas and macros

Nest IF, IFS, SWITCH, SUMIF(S), AVERAGEIF(S), COUNTIF(S), MAXIFS, MINIFS, AND, OR, NOT and LET; look up data with XLOOKUP, VLOOKUP, HLOOKUP, MATCH and INDEX; use NOW, TODAY, WEEKDAY and WORKDAY; analyse data with the Consolidate feature, Goal Seek, Scenario Manager, NPER, PMT, FILTER and SORTBY; troubleshoot formulas with precedent and dependent tracing, the Watch Window, error checking rules and Evaluate Formula; and record, name and edit simple macros

25-30%

Manage advanced charts and tables

Create and modify dual-axis charts and Box & Whisker, Combo, Funnel, Histogram, Sunburst and Waterfall charts; create PivotTables, modify field selections and options, create slicers, group PivotTable data, add calculated fields and configure value field settings; and create PivotCharts, manipulate their options, apply styles and drill down into chart details

Preparing for the MO-211 Exam

What You Need to Know

  • Passing score: 700 out of 1000
  • Assessment: A 50-minute live-in-the-application (LITA) exam delivered by Certiport. Candidates complete 5 to 8 projects, each containing 1 to 7 tasks, working inside a real Microsoft 365 Excel session; the engine scores the final workbook state rather than the steps taken.
  • Time limit: 50 minutes
  • Exam / certification fees: $100 Official sources

Using Our Practice Resources

  • Work through all 415 available questions
  • Review every answer and explanation
  • Track weak areas and revisit them
  • Use our AI tutor for tough concepts

MO-211: Suggested Study Strategy

1Master XLOOKUP before the exam — it replaces VLOOKUP in many scenarios and supports reverse lookups and wildcards
2Practice nested functions: =IF(AND(A1>0, B1<100), XLOOKUP(...), IFERROR(...)) — the exam tests complex nesting
3Know how to create and modify PivotTables: grouping dates (by month/quarter/year), adding calculated fields, and inserting slicers
4Practice recording and running macros via the Developer tab — know how to assign a macro to a Form button
5Understand dynamic array functions: FILTER, SORT, UNIQUE, SEQUENCE — these spill results automatically
6Practice custom number formats: #,##0.00 (comma thousand separator), "$"#,##0 (currency), and date masks like YYYY-MM-DD
7Know how to configure data validation with custom formulas (e.g., =A1>TODAY())
8Practice creating histogram and waterfall charts — these are commonly tested advanced chart types
9Do not skip objective 3.4: practise Data > Consolidate by category, Goal Seek, Scenario Manager, and the PMT and NPER functions — they are explicitly named in the official skills outline

Frequently Asked Questions

What is the MO-211 exam?

The MO-211 exam (Microsoft Excel Expert - Microsoft 365 Apps) is the advanced-level MOS Excel certification. It tests expert Excel skills through live performance-based tasks including advanced formulas, data validation, conditional formatting, what-if analysis, macros, PivotTables, and specialized chart types. It is administered by Certiport at authorized testing centers.

What advanced functions are tested on MO-211?

MO-211 tests XLOOKUP, INDEX, MATCH, nested IF/IFS, IFERROR, AND, OR, NOT, EDATE, EOMONTH, NETWORKDAYS, WORKDAY, and dynamic array functions like FILTER, SORT, UNIQUE, and SEQUENCE. You must know syntax, argument order, nesting patterns, and when each function is appropriate.

Do I need MO-210 before taking MO-211?

No — MO-210 (Excel Associate) is not a formal prerequisite for MO-211 (Excel Expert). However, MO-211 assumes you already have strong command of the associate-level skills. Candidates without prior Excel proficiency are strongly advised to pass MO-210 or gain equivalent experience before attempting MO-211.

How hard is the MO-211 exam?

MO-211 is the most difficult MOS Excel exam. It requires fluency with advanced formulas, data validation, conditional formatting, what-if analysis, PivotTable configuration, macro recording, and specialized chart types - all within 50 minutes in a live application. Most candidates need 25-40 hours of dedicated practice beyond everyday Excel use.

What are PivotTables tested on MO-211?

MO-211 PivotTable tasks include: creating PivotTables from data ranges, grouping fields (dates, numbers), adding calculated fields, inserting slicers and timelines, applying PivotTable styles, configuring grand totals and subtotals, changing value field settings (count, average, sum), and creating PivotCharts linked to PivotTables.

Does the MO-211 certification expire?

No — the MO-211 (MOS Excel Expert) certification does not expire. It is a permanent credential. Microsoft and Certiport may update the exam objectives as Excel evolves, but your existing certification remains valid indefinitely.