Microsoft Excel (Excel and Excel 2019) (MO-200) Exam

The MO-200 exam assesses your fundamental and intermediate skills in using Microsoft Excel and Excel 2019. It covers various functionalities, including:

• Creating and formatting worksheets and workbooks.
• Entering and editing data in cells.
• Using formulas and functions for calculations and data analysis.
• Creating charts and graphs to visualize data.
• Formatting and managing data tables and ranges.
• Applying conditional formatting to highlight patterns and trends.
• Collaborating with others in Excel workbooks.
  

• Individuals seeking to validate their basic to intermediate Excel skills.
• Professionals interested in demonstrating their competency in using Excel for data entry, analysis, and visualization.
• Office administrators, data analysts, and business professionals who heavily rely on Excel for their work.
• Anyone wanting to learn the fundamentals of Excel and gain a foundation for further exploration.
  

There are no formal prerequisites for taking the MO-200 exam. However, basic computer literacy and familiarity with Windows operating systems are recommended.

• Excel Basics: Creating and navigating workbooks, formatting worksheets, entering and editing data.
• Formulas and Functions: Using basic to intermediate formulas and functions for calculations, logical operations, and data manipulation.
• Data Analysis and Visualization: Creating and formatting charts and graphs, conditional formatting, data tables.
• Formatting and Managing Data: Working with cell formatting, data validation, sorting and filtering data, creating tables.
• Collaboration: Sharing and collaborating on workbooks, managing revisions and access control.
  

The MO-200 exam is a computer-based test with multiple-choice and scenario-based questions. You have 1 hour to complete the exam.

The passing score is 700

• Microsoft official learning resources: Online courses, documentation, and practice tests available on Microsoft Learn: https://support.microsoft.com/en-au/office/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb
• Books and study guides: Offered by various publishers and online platforms.
• Online tutorials and videos: Numerous free and paid resources available online.
• Practice exams and simulations: Offered by various sources to test your knowledge and exam readiness.
  

• Validates your foundational and intermediate skills in using Microsoft Excel.
• Enhances your career prospects in various fields that rely on data analysis and visualization.
• Demonstrates your proficiency in a widely used productivity tool and strengthens your resume.
• Increases your value to potential employers seeking individuals comfortable with Excel functionalities.
  

You can register for the MO-200 exam through the Pearson VUE website, an authorized testing provider: https://home.pearsonvue.com/.