Exam Name: Microsoft Excel (Microsoft Office Specialist)
Exam Code: MO-200
Related Certification(s): Microsoft Office Specialist: Excel Associate (Office 2019)
Certification Provider: Microsoft
Actual Exam Duration: 90 Minutes
Number of MO-200 practice questions in our database: 35

Expected MO-200 Exam Topics, as suggested by Microsoft:

Topic 1: Managing Worksheets and Workbooks

• Importing and exporting data from external sources
• Customizing views and window arrangements
• Configuring workbook properties and file options
• Managing worksheet visibility and structure

Topic 2: Formatting Cells and Ranges

• Applying cell styles, themes, and custom formatting
• Using conditional formatting rules for data visualization
• Implementing number formats and custom date/time formatting
• Creating named ranges for efficient data reference

Topic 3: Managing Tables and Table Data

• Creating and modifying Excel tables
• Sorting and filtering table data effectively
• Applying structured references in formulas
• Using table styles to enhance data presentation

Topic 4: Performing Data Operations Using Functions and Formulas

• Utilizing logical functions like IF, AND, OR, and IFERROR
• Performing calculations using SUM, AVERAGE, MIN, MAX
• Applying lookup functions such as VLOOKUP, HLOOKUP, and XLOOKUP
• Implementing text functions like CONCATENATE, LEFT, RIGHT, MID

Topic 5: Creating Charts and Objects

• Inserting and customizing various chart types
• Formatting chart elements for clarity and impact
• Incorporating illustrations, shapes, and SmartArt
• Utilizing sparklines and trendlines to analyze data

Topic 6: Managing PivotTables and PivotCharts

• Creating and modifying PivotTables for data analysis
• Filtering and summarizing PivotTable data
• Customizing PivotCharts for visual storytelling
• Implementing calculated fields and items in PivotTables