New MOS Exam Objectives

Word (Microsoft 365 Apps): Exam MO-110

Compare to Microsoft Word (Microsoft 365 apps and Office 2019) Exam MOS-100

New Objectives List: Exam MO-110

Objectives Removed:

• Create and modify bibliography citation sources (moved to the Word Expert Exam)
• Insert citations for bibliographies (moved to the Word Expert Exam)
• Insert Bibliographies ((moved to the Word Expert Exam)

Objectives Added:

• Insert Icons - Video: Insert icons (microsoft.com)

Excel (Microsoft 365 Apps): Exam MO-210

Compare to Microsoft Excel (Microsoft 365 apps and Office 2019) Exam MOS-200

New Objectives List: Exam MO-210

Objectives Removed:

• Name a table

Objectives Added:

• Import data from online sources - Import data from the web - Microsoft Support
• Manage comments and notes - Insert comments and notes in Excel (microsoft.com)
• Generate numeric data by using RANDBETWEEN() - RANDBETWEEN function (microsoft.com)
• Generate numeric data by using SEQUENCE() - SEQUENCE function (microsoft.com)
• Format multiple worksheets by grouping - Group worksheets (microsoft.com)
• Use structured references in formulas- Using structured references with Excel tables - Microsoft Support
• Sort data by using the SORT() function - SORT function (microsoft.com)
• Get unique values by using the UNIQUE() function- UNIQUE function (microsoft.com)

PowerPoint (Microsoft 365 Apps): Exam MO-310

Compare to Microsoft PowerPoint (Microsoft 365 apps and Office 2019) Exam MOS-300

New Objectives List: Exam MO-310

Objectives Removed:

• Print in color, grayscale, or black and white
• Mark presentations as final
• Set transition effect duration
• Configure transition start and finish options

Objectives Added:

• Restrict editing - Restrict changes to PowerPoint presentations - Microsoft Support

Word Expert (Microsoft 365 Apps): Exam MO-111

Compare to Microsoft Word Expert (Microsoft 365 apps and Office 2019) Exam MOS-101

New Objectives List: Exam MO-111

Objectives Removed:

• None

Objectives Added:

• Create and modify bibliography citation sources (Previously found in Exam MO-100)‍
• Insert citations for bibliographies (Previously found in Exam MO-100)‍
• Insert Bibliographies - Create a bibliography, citations, and references (microsoft.com)

Excel Expert (Microsoft 365 Apps): ExamMO-211

Compare to Microsoft Excel Expert (Microsoft 365 apps and Office 2019) Exam MOS-201

New Objectives List: Exam MO-211

Objectives Removed:

• Manage comments (moved to Exam MO 210)
• Configure editing and display languages
• Use language-specific features
• Format data

Objectives Added:

• Generate numeric data by using RANDARRAY() - RANDARRAY function (microsoft.com)
• Perform logical operations by using nested functions including the LET() function - LET function (microsoft.com)
• Look up data by using the XLOOKUP() - XLOOKUP function (microsoft.com)
• Filter data by using FILTER() - FILTER function (microsoft.com)
• Sort data by using SORTBY() - SORTBY function (microsoft.com)
• Configure value field settings - Set default values for fields or controls (microsoft.com)