One of the most important things that you need to know about the Microsoft MO-200 exam is that it consists of many topics that you need to learn. They are the following:
- Perform Operations with the Use of Formulas & Functions: This objective makes up 20-25% of the whole content. It covers the insertion of references, calculation and transformation of data, as well as formatting and modification of text;
- Manage Data Cells & Ranges: The next area constitutes 20-25% of the entire content. The information covered here include the manipulation of data in worksheets, formatting of cells and ranges, reference of named ranges, and summarization of data visually;
- Manage Tables & Table Data: As for this section, it makes up 15-20% of the exam content. It will evaluate your skills in creating, formatting, and modifying tables as well as filtering and sorting the table data;
- Manage Worksheets & Workbooks: The first domain makes up 10-15% of the exam content. The subdomains include the details of the import of data into workbooks, navigation within workbooks, formatting of worksheets and workbooks, customization of options and views, as well as configuration of the content for collaboration;
- Manage Charts: The last subject area makes up the remaining 20-25% of the exam questions. To successfully deal with it, you need to learn all about the ways of creating charts, modifying them, and formatting.
Reference: https://www.microsoft.com/en-us/learning/exam-mo-200.aspx
Certification Path
MO-200 is a fundamental exam and requires no pre-requisite.
Skills measured
- Perform operations by using formulas and functions (20-25%)
- Manage data cells and ranges (20-25%)
- Manage worksheets and workbooks (10-15%)
- Manage charts (20-25%)
- Manage tables and table data (15-20%)
We're so confident of our products that we provide no hassle product exchange.


By Agnes

