100+ Free MOS Excel Expert (Office 2019) Practice Questions
Pass your Microsoft Office Specialist: Excel Expert (Office 2019) — MO-201 exam on the first try — instant access, no signup required.
Which file extension should you use to save an Excel 2019 workbook so it can serve as a starting point for new workbooks but cannot be overwritten by saving?
Key Facts: MOS Excel Expert (Office 2019) Exam
50 min
Time Limit
Microsoft Learn MO-201 page
700/1000
Passing Score
Microsoft Learn MOS scoring
$100
Exam Fee (Certiport list price)
Certiport
35-40%
Largest Domain (Formulas & Macros)
MO-201 skills outline
Excel 2019
Live Application
Performance-based delivery
No expiration
Version-based MOS Validity
Microsoft Learn
MO-201 is a 50-minute, task-based performance exam scored on Microsoft's 0-1000 scaled system with a 700 passing benchmark and a US$100 list fee through Certiport. The four official skill domains are Manage workbook options and settings (10-15%), Manage and format data (20-25%), Create advanced formulas and macros (35-40%), and Manage advanced charts and tables (25-30%), so formula and macro depth should drive the majority of your study time.
Sample MOS Excel Expert (Office 2019) Practice Questions
Try these sample questions to test your MOS Excel Expert (Office 2019) exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.
1Which file extension should you use to save an Excel 2019 workbook so it can serve as a starting point for new workbooks but cannot be overwritten by saving?
2In Excel 2019, where do you set workbook calculation to manual so that formulas only recalculate when you press F9?
3You want to prevent users from inserting, deleting, or renaming sheets in a shared workbook while still allowing data entry. Which command should you use?
4A workbook references data in another workbook. The source workbook is closed. How will Excel display the linked values when the destination workbook is opened?
5Which feature scans a workbook for hidden properties such as comments, document properties, headers/footers, and hidden rows before sharing?
6You need to sum the value in cell B2 of every worksheet from January through December. Which 3D reference correctly does this?
7Iterative calculation in Excel 2019 is most useful when:
8Which workbook view lets you set page breaks visually by dragging blue lines between rows or columns?
9Which command in Excel 2019 adds a read-only recommendation that can be cleared by any user with one click?
10You are sharing an Excel 2019 workbook with a colleague who runs Excel 2010. Which tool warns you about features in your file that Excel 2010 does not support?
About the MOS Excel Expert (Office 2019) Exam
The Microsoft Office Specialist: Excel Expert (Office 2019) certification, exam code MO-201, validates that you can apply advanced Excel 2019 features to manage workbook options, transform and validate data, build complex formulas and macros, and create advanced PivotTables, PivotCharts, and analytical visualizations. The exam is delivered in a live Excel 2019 sandbox where you complete realistic task projects rather than answering multiple-choice questions, so platform fluency matters as much as conceptual recall.
Assessment
Performance-based, task-driven exam delivered in a live Excel 2019 environment; Microsoft does not publish an exact item count, candidates typically see roughly 26-35 task projects
Time Limit
50 minutes
Passing Score
700 of 1000 (Microsoft scaled score)
Exam Fee
US$100 (Certiport list price; resellers and academic vouchers may differ) (Microsoft (delivered by Certiport, a Pearson VUE business))
MOS Excel Expert (Office 2019) Exam Content Outline
Manage workbook options and settings
Manage workbooks (templates .xltx, prepare for collaboration via Inspect Document, mark as final, manage versions, manage links and external workbook references), navigate workbook views, and configure calculation options including manual versus automatic and iterative calculation.
Manage and format data
Fill cells based on existing data, apply advanced conditional formatting and filtering (rules, formula-based CF, custom number formats, Advanced Filter with criteria range), apply data validation (criteria, custom formulas, error alerts, input messages, circle invalid data), and group and summarize data.
Create advanced formulas and macros
Perform logical operations (IF, IFS, SWITCH, AND, OR, NOT, IFERROR, IFNA), look up data (VLOOKUP, HLOOKUP, INDEX/MATCH), use advanced date and time, financial, statistical, and text functions, define named ranges and named formulas, and record, edit, and run simple macros (.xlsm) including basic form controls.
Manage advanced charts and tables
Create and modify advanced charts (Combo, Box & Whisker, Histogram, Pareto, Sunburst, Treemap, Waterfall, Funnel, sparklines, trendlines), create and manage PivotTables (calculated fields, slicers, timelines, grouping, Show Values As, defer layout update), and create and manage PivotCharts.
How to Pass the MOS Excel Expert (Office 2019) Exam
What You Need to Know
- Passing score: 700 of 1000 (Microsoft scaled score)
- Assessment: Performance-based, task-driven exam delivered in a live Excel 2019 environment; Microsoft does not publish an exact item count, candidates typically see roughly 26-35 task projects
- Time limit: 50 minutes
- Exam fee: US$100 (Certiport list price; resellers and academic vouchers may differ)
Keys to Passing
- Complete 500+ practice questions
- Score 80%+ consistently before scheduling
- Focus on highest-weighted sections
- Use our AI tutor for tough concepts
MOS Excel Expert (Office 2019) Study Tips from Top Performers
Frequently Asked Questions
How many questions are on the MO-201 Microsoft Office Specialist: Excel Expert (Office 2019) exam?
Microsoft and Certiport do not publish a fixed scored question count. The exam is performance-based and delivered in a live Excel 2019 environment, where candidates typically see a series of task projects (roughly 26-35) to complete inside actual workbooks within the 50-minute time limit.
What is the passing score for MO-201?
Microsoft Office Specialist exams are scored on a scaled 0 to 1000 system with 700 as the passing benchmark, per Microsoft Learn. The score is not a simple percentage of correct answers because tasks are weighted by difficulty and domain weight.
How much does the exam cost?
Certiport's standard list price for an MOS exam voucher is US$100. Schools, academic institutions, and bulk resellers often offer lower prices, and retake vouchers may be sold separately. Confirm current pricing on the Certiport website before purchasing.
Which domains carry the most weight?
Create advanced formulas and macros is the largest skill area at 35-40%, followed by Manage advanced charts and tables at 25-30%. Manage and format data is 20-25% and Manage workbook options and settings is 10-15%, so formula, lookup, and macro mastery should anchor your prep plan.
Where do I take the exam and is online proctoring available?
MOS exams are delivered through Certiport, a Pearson VUE business. You can sit MO-201 at a Certiport authorized testing center or take it online with Certiport's Compass for Online Testing remote proctoring service, where supported.
Does this certification ever expire?
Microsoft Office Specialist certifications based on a specific Office version (such as Office 2019) do not expire. They remain valid indefinitely, though candidates often pursue the newer Office 365 / 2021 or current version exams to demonstrate currency on more recent features.
Is MO-201 the right exam if I use Microsoft 365?
MO-201 is built around Excel 2019 features. Microsoft also publishes a current MOS Excel Expert exam aligned to Microsoft 365 Apps. If you use Microsoft 365 daily and want the latest objectives (including newer dynamic-array functions), check the current Excel Expert exam page on Microsoft Learn instead of MO-201.