Microsoft MO-201 Exam Details & Actual Exam Questions

  • Exam Code/Number: MO-201
  • Exam Name/Title: Microsoft Excel Expert (Excel and Excel 2019)
  • Certification Provider: Microsoft
  • Corresponding Certification: Microsoft Office Specialist
  • Exam Questions: 25
  • Updated On: Oct,22 2026
  • Certification Level: Expert

Microsoft Excel Expert (Excel and Excel 2019) Exam Questions

View MO-201 actual exam questions, answers and explanations for free.

users 95% student found the test questions almost same

All the information you need to pass Microsoft Excel Expert (Excel and Excel 2019) MO-201 exam and free practice exam verified by EduDump exam experts.

Said the test questions were almost same
Passed the exams with the material
Found the study quides effective and helpful
(35 Up Votes)

Microsoft MO-201 Exam Overview:

Certification Vendor:Microsoft
Exam Name:Microsoft Excel Expert (Excel and Excel 2019)
Exam Number:MO-201
Exam Price:USD 100 (region-dependent)
Certificate Validity Period:No expiration
Exam Duration:50 minutes
Available Languages:Japanese, German, Chinese (Simplified), French, Korean, Spanish, Chinese (Traditional), English
Related Certifications:Microsoft Office Specialist: Expert (Office 2019)
Microsoft Office Specialist: Excel Associate (Excel and Excel 2019)
Exam Format:Hands-on Excel tasks, Computer-based, Performance-based
Real Exam Qty:25-30 performance-based tasks
Passing Score:700/1000
Sample Questions:Microsoft MO-201 Sample Questions
Exam Way:Delivered through Certiport testing centers or online proctored testing where available.
Pre Condition:No formal prerequisite. Microsoft recommends approximately 150 hours of instruction and hands-on experience with Excel. Excel Associate certification is recommended before pursuing Expert-level certification.
Official Syllabus URL:https://learn.microsoft.com/en-us/credentials/certifications/mos-excel-expert-2019/

Microsoft MO-201 Exam Syllabus Topics:

SectionWeightObjectives
Topic 1: Manage Workbook Options and Settings10-15%- Manage workbooks
  • 1. Modify workbook properties
  • 2. Prepare workbooks for collaboration
  • 3. Protect workbook structure
- Configure language and accessibility options
  • 1. Manage proofing and language settings
  • 2. Configure accessibility features
Topic 2: Manage Advanced Charts and Tables25-30%- Create advanced charts
  • 1. Manage chart elements and layouts
  • 2. Create specialized chart types
  • 3. Apply advanced chart formatting
- Create and manage PivotTables and PivotCharts
  • 1. Create PivotCharts
  • 2. Build PivotTables
  • 3. Modify PivotTable calculations
Topic 3: Create Advanced Formulas and Macros25-30%- Create and manage macros
  • 1. Manage macro security options
  • 2. Assign macros to objects
  • 3. Record macros
- Create advanced formulas
  • 1. Use logical and statistical functions
  • 2. Create nested formulas
  • 3. Use lookup and reference functions
Topic 4: Manage and Format Data30-35%- Analyze data
  • 1. Use advanced filtering and sorting
  • 2. Create custom views
  • 3. Perform what-if analysis
- Manage data
  • 1. Import and transform data
  • 2. Apply advanced conditional formatting
  • 3. Configure data validation


0
0
0
10