Prerequisites to Meet

The Microsoft MO-200 exam certifies the individuals’ ability to work with Microsoft Excel applications and tools. However, it is important to understand that not anyone can go for it. First and foremost, the candidates should have a good understanding of the basics of managing and creating workbooks and worksheets. It is also essential that they are familiar with creating cell, ranges, and tables. They should also know how to apply functions and formulas to specific columns and rows.

What is the duration of the MO-200 Exam

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

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%)

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

Manage data cells and ranges (20-25%)

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

Manage tables and table data (15-20%)

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

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

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

Manage charts (20-25%)

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

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