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

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

The MO-200 exam helps in demonstrating the correct application of the principal features of Excel and can complete tasks independently. The exam covers the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

Knowledge Required 

An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry associate level and is ready to enter into the job market. 

Course Outline

The MO-200: Microsoft Excel (Excel and Excel 2019) (MO-200) Exam covers the latest exam updates and topics - 

Domain 1 - Manage worksheets and workbooks (10-15%)

1.1 Import data into workbooks

• Import data from .txt files
• Import data from .csv files

1.2 Navigate within workbooks

• Search for data within a workbook
• Navigate to named cells, ranges, or workbook elements
• Insert and remove hyperlinks

1.3 Format worksheets and workbooks

• Modify page setup
• Adjust row height and column width
• Customize headers and footers

1.4 Customize options and views

• Customize the Quick Access toolbar
• Display and modify workbook content in different views
• Freeze worksheet rows and columns
• Change window views
• Modify basic workbook properties
• Display formulas

1.5 Configure content for collaboration

• Set a print area
• Save workbooks in alternative file formats
• Configure print settings
• Inspect workbooks for issues

Domain 2 - Manage data cells and ranges (20-25%)

2.1 Manipulate data in worksheets

• Paste data by using special paste options
• Fill cells by using Auto Fill
• Insert and delete multiple columns or rows
• Insert and delete cells

2.2 Format cells and ranges

• Merge and unmerge cells
• Modify cell alignment, orientation, and indentation
• Format cells by using Format Painter
• Wrap text within cells
• Apply number formats
• Apply cell formats from the Format Cells dialog box
• Apply cell styles
• Clear cell formatting

2.3 Define and reference named ranges

• Define a named range
• Name a table

2.4 Summarize data visually

• Insert Sparklines
• Apply built-in conditional formatting
• Remove conditional formatting

Domain 3 - Manage tables and table data (15-20%)

3.1 Create and format tables

• Create Excel tables from cell ranges
• Apply table styles
• Convert tables to cell ranges

3.2 Modify tables

• Add or remove table rows and columns
• Configure table style options
• Insert and configure total rows

3.3 Filter and sort table data

• Filter records
• Sort data by multiple columns

Domain 4 - Perform operations by using formulas and functions (20-25%)

4.1 Insert references

• Insert relative, absolute, and mixed references
• Reference named ranges and named tables in formulas

4.2 Calculate and transform data

• Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions
• Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
• Perform conditional operations by using the IF() function

4.3 Format and modify text

• Format text by using RIGHT(), LEFT(), and MID() functions
• Format text by using UPPER(), LOWER(), and LEN() functions
• Format text by using the CONCAT() and TEXTJOIN() functions

Domain 5 - Manage charts (20-25%)

5.1 Create charts

• Create charts
• Create chart sheets

5.2 Modify charts

• Add data series to charts
• Switch between rows and columns in source data
• Add and modify chart elements

5.3 Format charts

• Apply chart layouts
• Apply chart styles
• Add alternative text to charts for accessibility

Exam Pattern

• Exam Name: Microsoft Excel (Excel and Excel 2019)
• Exam Code: MO-200
• Number of Questions: 40-60
• Length of Time:  50 Minutes
• Registration Fee: $100.00
• Passing score: 700 (on a scale of 1-1000)
• Exam Language English
  

What do we offer?

• Full-Length Mock Test with unique questions in each test set
• Practice objective questions with section-wise scores
• An in-depth and exhaustive explanation for every question
• Reliable exam reports evaluating strengths and weaknesses
• Latest Questions with an updated version
• Tips & Tricks to crack the test
• Unlimited access

What are our Practice Exams?

• Practice exams have been designed by professionals and domain experts that simulate real time exam scenario.
• Practice exam questions have been created on the basis of content outlined in the official documentation.
• Each set in the practice exam contains unique questions built with the intent to provide real-time experience to the candidates as well as gain more confidence during exam preparation.
• Practice exams help to self-evaluate against the exam content and work towards building strength to clear the exam.
• You can also create your own practice exam based on your choice and preference 

100% Assured Test Pass Guarantee

We have built the TestPrepTraining Practice exams with 200% Unconditional and assured Test Pass Guarantee! 

If you are not able to clear the exam, you can ask for a 200% refund.