Keep Calm and Study On - Unlock Your Success - Use #TOGETHER for 30% discount at Checkout
Testprep Training

Microsoft Excel Expert (Microsoft 365 Apps) MO-211 Practice Exam

Microsoft Excel Expert (Microsoft 365 Apps) MO-211 Practice Exam


About Microsoft Excel Expert (Microsoft 365 Apps) MO-211 Exam

The Microsoft Excel Expert (Microsoft 365 Apps) MO-211 Exam has been developed to assess the skills and knowledge of the candidate to perform tasks including managing workbook options and settings, managing and formatting data, creating advanced formulas and macros and managing advanced charts and tables. 


Knowledge Gained

The Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) MO-211 exam validates the proficiency of the candidate in creating, managing, and distributing professional spreadsheets and workbooks tailored to various specialized purposes and situations. The exam also assesses the capability of the candidate to customize Excel environments to meet project requirements and enhance productivity.


Skills Required

Candidates appearing for the MO-211 exam should -

  • Complete approximately 150 hours of instruction and hands-on experience with the product.
  • Demonstrate your proficiency at an industry expert level.
  • Prepare to enter the job market.


Course Outline

The Microsoft Excel Expert (Microsoft 365 Apps) MO-211 Exam covers the following topics - 

Module 1 - Understanding to Manage Workbook Options and settings (10–15%)

1.1 Learn Managing Workbooks

  • Explain how to copy macros between workbooks
  • Explain reference data in other workbooks
  • Explain how to enable macros in a workbook
  • Explain how to manage workbook versions

1.2 Prepare workbooks for collaboration

  • Explain how to restrict editing
  • Explain how to protect worksheets and cell ranges
  • Explain how to protect workbook structure
  • Explain how to configure formula calculation options


Module 2 - Understanding Managing and Formatting Data (30–35%)

2.1 Learn about Fill cells based on existing data

  • Explain how to fill cells by using Flash Fill
  • Explain how to fill cells by using advanced Fill Series options
  • Explain how to generate numeric data by using RANDARRAY()


2.2 Learn about Format and validate data

  • Explain how to create custom number formats
  • Explain how to configure data validation
  • Explain how to group and ungroup data
  • Explain how to calculate data by inserting subtotals and totals
  • Explain how to remove duplicate records


2.3 Apply advanced conditional formatting and filtering

  • Explain how to create custom conditional formatting rules
  • Explain how to create conditional formatting rules that use formulas
  • Explain how to manage conditional formatting rules


Domain 3 - Understanding to create advanced formulas and macros (25–30%)

3.1 Learning to perform logical operations in formulas

  • Explain how to perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), NOT(), and LET() functions


3.2 Learn about Look up data by using functions

  • Explain how to Look up data by using the XLOOKUP(), VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions


3.3 Learn to use advanced date and time functions

  • Explain how to Reference date and time by using the NOW() and TODAY() functions
  • Explain how to Calculate dates by using the WEEKDAY() and WORKDAY() functions


3.4 Learn about performing data analysis

  • Explain how to summarize data from multiple ranges by using the Consolidate feature
  • Explain how to perform what-if analysis by using Goal Seek and Scenario Manager
  • Explain how to forecast data by using the AND(), IF(), and NPER() functions
  • Explain how to calculate financial data by using the PMT() function
  • Explain how to Filter data by using FILTER()
  • Explain how to sort data by using SORTBY()


3.5 Learn about Troubleshooting formulas

  • Explain how to trace precedence and dependence
  • Explain how to monitor cells and formulas by using the Watch Window
  • Explain how to validate formulas by using error checking rules
  • Explain how to evaluate formulas


3.6 Create and modify simple macros

  • Explain how to record simple macros
  • Explain how to name simple macros
  • Explain how to edit simple macros


Domain 4 - Understanding to Manage advanced charts and tables (25–30%)

4.1 Learn about creating and modifying advanced charts

  • Explain how to create and modify dual-axis charts
  • Explain how to create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Sunburst, and Waterfall charts
  • Explain how to create and modify PivotTables
  • Explain how to create PivotTables
  • Explain how to modify field selections and options
  • Explain how to create slicers
  • Explain how to group PivotTable data
  • Explain how to add calculated fields
  • Explain how to configure value field settings


4.2 Learn about creating and modifying PivotCharts

  • Explain how to create PivotCharts
  • Explain how to manipulate options in existing PivotCharts
  • Explain how to apply styles to PivotCharts
  • Explain how to drill down into PivotChart details

Tags: Microsoft MO-211 Practice exam, Microsoft MO-211 exam questions, Microsoft MO-211 free test, Microsoft MO-211 study guide, Microsoft MO-211 learning resources, Microsoft MO-211 Online course