Microsoft Excel Expert - Microsoft 365 Apps MO-211 Certified Exam Dumps

MO-211 Exam Dumps

Microsoft Excel Expert - Microsoft 365 Apps MO-211 real exam questions and online practice test engine by FreeCram. Try MO-211 exam questions for free. You can also download a free demo of the MO-211 exam PDF version.

Microsoft's MO-211 actual exam materials brought to you by FreeCram group of Microsoft certification experts.
View all MO-211 actual exam questions & answers and explanations for free.

If you like our product, you can request full access to all the latest Microsoft Excel Expert - Microsoft 365 Apps MO-211 exam premium questions.

Certification Provider: Microsoft
Exam Code / Number: MO-211
Exam Name: Microsoft Excel Expert - Microsoft 365 Apps
Exam Questions: 168
Last Updated: Jul 11, 2026
Corresponding Certification: Microsoft 365 Certified Expert

Go To MO-211 Questions

(16 Up Votes)

Microsoft MO-211 Exam Syllabus Topics:

SectionWeightObjectives
Create advanced formulas and macros25–30%- Perform logical operations in formulas
  • 1. Use conditional aggregation: SUMIF, AVERAGEIF, COUNTIF, SUMIFS, AVERAGEIFS, COUNTIFS
  • 2. Use nested functions: IF, IFS, SWITCH
- Look up data by using formulas
  • 1. Use VLOOKUP, HLOOKUP, XLOOKUP
  • 2. Use INDEX and MATCH functions
- Create and modify named ranges
  • 1. Use named ranges in formulas
  • 2. Define, edit, and delete named ranges
- Create and modify simple macros
  • 1. Edit macros in Visual Basic for Applications
  • 2. Record and run macros
Manage workbook options and settings10–15%- Prepare workbooks for collaboration
  • 1. Restrict editing
  • 2. Configure formula calculation options
  • 3. Protect worksheets and cell ranges
  • 4. Protect workbook structure
- Manage workbooks
  • 1. Reference data in other workbooks
  • 2. Copy macros between workbooks
  • 3. Enable macros in a workbook
  • 4. Manage workbook versions
Manage advanced charts and tables25–30%- Create and modify PivotTables
  • 1. Configure PivotTable fields and layouts
  • 2. Group and ungroup PivotTable data
  • 3. Apply filters and slicers
- Create and modify advanced charts
  • 1. Use trendlines and error bars
  • 2. Create dual-axis charts
  • 3. Create and modify PivotCharts
- Create and manage tables
  • 1. Apply table styles and formatting
  • 2. Use structured references in formulas
  • 3. Convert ranges to tables
Manage and format data30–35%- Fill cells based on existing data
  • 1. Fill cells by using Flash Fill
  • 2. Fill cells by using advanced Fill Series options
  • 3. Generate numeric data by using RANDARRAY()
- Apply advanced conditional formatting and filtering
  • 1. Manage conditional formatting rules
  • 2. Create custom conditional formatting rules
  • 3. Create conditional formatting rules that use formulas
  • 4. Apply advanced filtering options
- Format and validate data
  • 1. Remove duplicate records
  • 2. Calculate data by inserting subtotals and totals
  • 3. Configure data validation
  • 4. Group and ungroup data
  • 5. Create custom number formats


0
0
0
10