Career upgrade: Learn practical AI skills for better jobs and higher pay.
Level up
PracticeVideosBlogFlashcardsEspañol
All Practice Exams

100+ Free MO-211 Practice Questions

Pass your Microsoft Excel Expert (Microsoft 365 Apps) (MO-211) exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
100+ Questions
100% Free
1 / 100
Question 1
Score: 0/0

A user applies Subtotals (Data > Subtotal) to a sorted dataset grouped by Region. What must be done to the data BEFORE applying Subtotals?

A
B
C
D
to track
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 SheetFlashcards2 videos4 blogs

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

Practice QuestionsStudy GuideCheat Sheet1 video2 blogs

Azure MD-102

Practice QuestionsStudy GuideCheat SheetFlashcards1 video1 blog

Microsoft Certified: Security Operations Analyst Associate (SC-200)

Practice QuestionsStudy GuideCheat SheetFlashcards1 video1 blog

Azure MS-102

Practice QuestionsCheat Sheet2 videos3 blogs

Microsoft Power Platform Functional Consultant

Practice Questions2 blogs

More From This Family

Videos and articles for deeper review.

VideoFREE MD-102 Exam Guide 2026: Pass Microsoft Endpoint Administrator (Intune, Autopilot, Windows 11)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)VideoFREE MS-102 Exam Guide 2026: Pass Microsoft 365 Administrator (Entra, Defender XDR, Purview)ArticleFREE DP-600 Exam Guide 2026: Pass Microsoft Fabric Analytics Engineer (Direct Lake, DAX, Semantic Models)27 min readArticleFREE MD-102 Exam Guide 2026: Pass Microsoft Endpoint Administrator (Intune, Autopilot, Windows 11)24 min readArticleFREE MS-102 Exam Guide 2026: Pass Microsoft 365 Administrator (Entra, Defender XDR, Purview)24 min readArticleFREE PL-400 Power Platform Developer Exam Guide 2026: Pass First Try16 min read
2026 Statistics

Key Facts: MO-211 Exam

~35

Exam Tasks

Certiport

700/1000

Passing Score

Certiport

50 min

Exam Duration

Certiport

~$100

Exam Fee

Certiport

4

Exam Domains

MO-211 Objectives

Never

Expiration

Does not expire

The MO-211 Microsoft Excel Expert exam has approximately 35 performance-based tasks in 50 minutes with a passing score of 700/1000. Key domains: Manage Workbook Options and Settings (~20%), Manage and Format Data (~25%), Create Advanced Formulas and Macros (~25%), Manage Advanced Charts and Tables (~30%). No prerequisites, but intermediate Excel experience is strongly recommended. Certification does not expire.

Sample MO-211 Practice Questions

Try these sample questions to test your MO-211 exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ 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 functions), custom data validation, Power Query, 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.

Questions

35 scored questions

Time Limit

50 minutes

Passing Score

700/1000

Exam Fee

$100 (Certiport (Pearson VUE))

MO-211 Exam Content Outline

~20%

Manage Workbook Options and Settings

Manage workbook versions, encrypt workbooks with passwords, configure formula calculation settings (automatic vs manual), enable iterative calculations, configure workbook-level protection, manage macros, use formula references across worksheets and workbooks

~25%

Manage and Format Data

Fill cells using custom AutoFill series, apply custom number formats (accounting, date, text masks), configure data validation rules (whole number, decimal, list, date, text length, custom formulas), apply advanced conditional formatting using formulas, use Remove Duplicates and Text to Columns, import data via Power Query

~25%

Create Advanced Formulas and Macros

Use XLOOKUP, INDEX, MATCH, nested IF and IFS, IFERROR, AND, OR, NOT; apply array formulas and dynamic array functions (FILTER, SORT, UNIQUE, SEQUENCE); use advanced date functions (EDATE, EOMONTH, NETWORKDAYS, WORKDAY); record and run simple macros; assign macros to buttons

~30%

Manage Advanced Charts and Tables

Create histogram, Pareto, box-and-whisker, sunburst, treemap, and waterfall charts; create and modify PivotTables (grouping, calculated fields, slicers, timelines); create PivotCharts; apply PivotTable styles; configure PivotTable options (layout, totals, subtotals)

How to Pass the MO-211 Exam

What You Need to Know

  • Passing score: 700/1000
  • Exam length: 35 questions
  • Time limit: 50 minutes
  • Exam fee: $100

Keys to Passing

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

MO-211 Study Tips from Top Performers

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

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, PivotTables, macros, Power Query, 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, PivotTable configuration, macro recording, Power Query basics, 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.