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 - 

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

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

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

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

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.