Microsoft Excel Expert (Excel and Excel 2019) MO-201 Practice Exam
Microsoft Excel Expert (Excel and Excel 2019) MO-201 Practice Exam
Microsoft Excel Expert (Excel and Excel 2019) MO-201 Practice Exam
The Microsoft Excel Expert exam assesses candidates who demonstrate their proficiency in utilizing the key features of Excel 2019 at an advanced level. This includes the ability to create, manage, and distribute professional-grade spreadsheets tailored for diverse specialized purposes and scenarios.
Examples of expert workbook content may comprise:
Customized business templates
Financial charts with multiple axes
Amortization tables
Inventory schedules
Who should take the exam?
The exam is best for candidates who:
Accumulate approximately 150 hours of instruction and hands-on experience with the software.
Demonstrate a validated competency equivalent to an industry expert-level standard.
Be prepared to enter the job market with your attained expertise.
Exam Details
Exam Code: MO-201
Exam Name: Microsoft Office Specialist: Microsoft Excel Expert (Office 2019)
Exam Languages: English, Spanish, French, German, Japanese, Korean, Chinese (Simplified), Chinese (Traditional)
Exam Questions: 40-60 Questions
Time: 50 minutes
Passing Score: 700 or greater (On a scale 1 - 1000)
Exam Course Outline
The Exam covers the given topics -
Domain 1: Learn how to Manage workbook options and settings (15-20%)
Manage workbooks
copy macros between workbooks
reference data in other workbooks
enable macros in a workbook
manage workbook versions
Prepare workbooks for collaboration
restrict editing
protect worksheets and cell ranges
protect workbook structure
configure formula calculation options
manage comments
Use and configure language options
configure editing and display languages
use language-specific features
Domain 2: Understand about managing and formatting data (20-25%)
Fill cells based on existing data
fill cells by using Flash Fill
fill cells by using advanced Fill Series options
Format and validate data
create custom number formats
configure data validation
group and ungroup data
calculate data by inserting subtotals and totals
remove duplicate records
Apply advanced conditional formatting and filtering
create custom conditional formatting rules
create conditional formatting rules that use formulas
manage conditional formatting rules
Domain 3: Creating advanced formulas and macros (30-35%)
Perform logical operations in formulas
perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), and NOT() functions
Look up data by using functions
look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions
Use advanced date and time functions
reference date and time by using the NOW() and TODAY() functions
calculate dates by using the WEEKDAY() and WORKDAY() functions
Perform data analysis
summarize data from multiple ranges by using the Consolidate feature
perform what-if analysis by using Goal Seek and Scenario Manager
forecast data by using the AND(), IF(), and NPER() functions
calculate financial data by using the PMT() function
Troubleshoot formulas
trace precedence and dependence
monitor cells and formulas by using the Watch Window
validate formulas by using error checking rules
evaluate formulas
Create and modify simple macros
record simple macros
name simple macros
edit simple macros
Domain 4: Managing advanced charts and tables (25-30%)
Create and modify advanced charts
create and modify dual axis charts
create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts