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

Manage data cells and ranges (20-25%)

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

Manage tables and table data (15-20%)

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

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

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

Manage charts (20-25%)

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

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.

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

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.