What is the duration of the MO-200 Exam

• Format: Multiple choices, multiple answers
• Passing Score: 70%
• Length of Examination: 90 minutes
• Number of Questions: 40

MO-200 Exam topics

Candidates must know the EPM topics before they start of preparation because it will really help them solving the problems. Our MO-200 practice test and CAU-305 practice exams will include the following topics. These are covered in our CAU-305 exam dumps.

Manage worksheets and workbooks (10-15%)

• Customize the Quick Access toolbar
• Adjust row height and column width
• Navigate within workbooks
• Save workbooks in alternative file formats
• Import data from .txt files
• Insert and remove hyperlinks
• Modify basic workbook properties
• Import data from .csv files
• Import data into workbooks
• Search for data within a workbook
• Display and modify workbook content in different views
• Set a print area
• Configure content for collaboration
• Change window views
• Customize options and views
• Configure print settings
• Inspect workbooks for issues
• Format worksheets and workbooks
• Freeze worksheet rows and columns
• Modify page setup
• Customize headers and footers
• Display formulas
• Navigate to named cells, ranges, or workbook elements

Manage data cells and ranges (20-25%)

• Name a table
• Clear cell formatting
• Insert Sparklines
• Apply cell styles
• Define and reference named ranges
• Format cells and ranges
• Define a named range
• Insert and delete cells
• Wrap text within cells
• Manipulate data in worksheets
• Format cells by using Format Painter
• Modify cell alignment, orientation, and indentation
• Paste data by using special paste options
• Merge and unmerge cells
• Apply number formats
• Remove conditional formatting
• Apply cell formats from the Format Cells dialog box
• Summarize data visually
• Insert and delete multiple columns or rows
• Apply built-in conditional formatting
• Fill cells by using Auto Fill

Manage tables and table data (15-20%)

• Convert tables to cell ranges
• Filter and sort table data
• Modify tables
• Insert and configure total rows
• Sort data by multiple columns
• Create Excel tables from cell ranges
• Configure table style options
• Add or remove table rows and columns
• Create and format tables
• Apply table styles
• Filter records

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

• Format text by using RIGHT(), LEFT(), and MID() functions
• Reference named ranges and named tables in formulas
• Perform conditional operations by using the IF() function
• Insert references
• Format and modify text
• Format text by using the CONCAT() and TEXTJOIN() functions
• Format text by using UPPER(), LOWER(), and LEN() functions
• Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions
• Insert relative, absolute, and mixed references
• Calculate and transform datas
• Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions

Manage charts (20-25%)

• Create charts
• Create charts
• Apply chart layouts
• Modify charts
• Apply chart styles
• Create chart sheets
• Add and modify chart elements
• Add data series to charts
• Format charts
• Switch between rows and columns in source data
• Add alternative text to charts for accessibility

Details to Know

The Microsoft MO-200 exam is available in a wide range of languages, such as English, Dutch, English (Malaysia), Polish, French, Indonesian (Indonesia), German, Spanish, and Portuguese (Brazil). Besides that, it can be taken in Korean, Arabic (Saudi Arabia), Greek (Greece), Japanese, Russian, Simplified Chinese, Traditional Chinese, and Italian. You will be given 50 minutes to answer about 40-60 questions. It is safe to assume that time management will play an important role in this test and that is why it is recommended that you work on these skills. The questions are based on the multiple-choice format but you can face with other types as well. The exam costs $100. To pass it, you need to get a minimum score of 700 points on a scale of 1000.

Reference: https://www.microsoft.com/en-us/learning/exam-mo-200.aspx

Who should take the MO-200 exam

MO-200 is for people who use Excel in their daily routine and at work at organizations. Also for people who demonstrate that you have the skills needed to get the most out of Excel by earning the Microsoft Office Specialist: Excel Associate Certification. This certification demonstrates competency in the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions, and creating charts and objects.

Suitable for beginners or for anyone who has a reasonable knowledge of Microsoft Excel, this exam is aimed at you obtaining certification status from Microsoft by passing the MO-200 exam. Rather than simply provide sample questions, the exam explains how the exam is structured, the way that the questions should be approached and how to study successfully to pass. The exam also includes invaluable advice on the best way to prepare and what to expect from the testing process. A comprehensive exercise book covering each section of the Objective Domain is provided. Video solutions for all of the exercises are also included. Having completed this exam you will be confident in your skills to become a Microsoft Excel Associate in Excel 365/2019.