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

The Microsoft Excel (Excel and Excel 2019) certification, also known as Microsoft Office Specialist: Excel Associate (MO-200), validates your fundamental skills and proficiency in using Microsoft Excel for various data management and analysis tasks. It caters to individuals seeking to:

Who should pursue the MO-200 Certification?

• Administrative professionals: Enhance their Excel skills for efficient data manipulation and analysis tasks.
• Students and recent graduates: Gain a valuable credential to demonstrate their Excel proficiency for entry-level positions.
• Anyone seeking to:
• Validate their basic understanding of core Excel functionalities.
• Improve their daily productivity by utilizing Excel more effectively.
• Gain a foundation for further learning in advanced Excel features.

Key Skills and Knowledge Assessed:

The MO-200 exam focuses on various fundamental areas of using Excel, including:

• Managing worksheets and workbooks: Creating, formatting, navigating, and organizing worksheets and workbooks.
• Managing data cells and ranges: Entering, editing, formatting, and manipulating data in cells and ranges.
• Creating and formatting tables: Utilizing tables for effective data organization and presentation.
• Performing calculations and formulas: Applying basic formulas and functions for calculations, data analysis, and automation.
• Creating charts and graphs: Visualizing data effectively using various chart and graph types.

Exam Details:

• Exam Provider: Microsoft
• Format: Multiple-choice questions
• Number of Questions: Varies (typically around 40-60)
• Duration: 60 minutes
• Passing Score: 700 (on a scale of 1-1000)
• Delivery: Testing center or online proctored
  

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