The Microsoft Office Specialist (MOS) Program provides industry-leading assessments of skills and knowledge through our new project-based testing. These exams include multiple, small projects within Microsoft Office. Students and professionals will be tested on one project at a time. These small projects will test their skills as they would in the real world and validate their understanding of the Microsoft Office program functionality. This guarantees that every certified user has demonstrated the ability to operate the full features and gives students a commanding competitive edge in today’s academic and professional environments.
1.1. Word Associate (Microsoft 365 Apps): Exam MO-110
As a candidate for this exam, you’re competent in the correct application of the principal features of Word by creating and editing documents for a variety of purposes and situations.
This exam measures your ability to create and maintain:
- Professional-looking reports
- Multicolumn newsletters
- Resumes
- Business correspondence
1.2. Excel Associate (Microsoft 365 Apps): Exam MO-210
As a candidate for this certification, you have a fundamental understanding of the Excel (Microsoft 365 Apps) environment. You demonstrate your ability to apply the main features of the program, such as:
- Creating and managing worksheets and workbooks.
- Creating cells and ranges.
- Creating tables.
- Applying formulas and functions.
- Creating charts and objects.
This certification also measures your ability to:
- Create and edit a workbook with multiple sheets.
- Use a graphic element to represent data visually.
Workbook examples include:
- Professional-looking budgets
- Financial statements
- Team performance charts
- Sales invoices
- Data-entry logs
1.3. PowerPoint Associate (Microsoft 365 Apps): Exam MO-310
As a candidate for this certification, you have fundamental understanding of the PowerPoint (Microsoft 365 Apps) environment. You demonstrate your ability to apply the main features of the program, such as:
- Creating and managing presentations.
- Inserting and formatting shapes and slides.
- Creating slide content.
- Applying transitions and animations.
- Managing multiple presentations.
Presentation examples include:
- Professional-grade sales presentations
- Employee training
- Instructional materials
- Kiosk slideshows
1.4. Word Expert (Microsoft 365 Apps): Exam MO-111
As a candidate for this certification, you demonstrate your ability to proficiently use the advanced features of Word (Microsoft 365 Apps), such as:
- Creating and managing professional documents for a variety of specialized purposes and situations.
- Customizing Word environments to meet project needs and enhance productivity.
Examples of expert level documents include:
- Business plans
- Research papers
- Books
- Specialized brochures
- Mass mailings
1.5. Excel Expert (Microsoft 365 Apps): Exam MO-211
As a candidate for this certification, you demonstrate your ability to proficiently use the advanced features of Excel (Microsoft 365 Apps), such as:
- Creating, managing, and distributing professional spreadsheets and workbooks for a variety of specialized purposes and situations.
- Customizing Excel environments to meet project needs and enhance productivity.
Expert workbook examples include:
- Custom business templates
- Multiple-axis financial charts
- Amortization tables
- Inventory schedules
1.6. Word Associate (Office 2019): Exam MO-100
This exam measures competency in the correct application of the principal features of Word by creating and editing documents for a variety of purposes and situations. The exam covers the ability to create and maintain professional-looking reports, multicolumn newsletters, résumés, and business correspondence.
1.7. Excel Associate (Office 2019): Exam MO-200
This exam measures competency in the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions, and creating charts and objects. The exam covers the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data entry logs.
1.8. PowerPoint Associate (Office 2019): Exam MO-300
This exam measures competency to create, edit, and enhance presentations and slideshows, including the ability to create and manage presentations, insert and format shapes and slides, create slide content, apply transitions and animations, and manage multiple presentations. Presentation examples include professional-grade sales presentations, employee training, instructional materials, and kiosk slideshows.
1.9. Outlook Associate (Office 2019): Exam MO-400
As a candidate for Exam MO-400, you demonstrate your ability to apply the main features of Outlook 2019, such as:
- Customizing the Outlook UI format message content.
- Creating or inserting graphic elements.
- Sending and responding to emails and meeting requests.
- Creating calendars.
- Coordinating building resources.
- Assigning meeting action items.
1.10. Word Expert (Office 2019): Exam MO-101
This exam measures competency in creating and managing professional documents for a variety of specialized purposes and situations. The exam covers the ability to customize Word environments to meet project needs and to enhance productivity. Examples of expert-level documents include a business plan, a research paper, a book, a specialized brochure, and a mass mailing.
1.11. Excel Expert (Office 2019): Exam MO-201
This exam measures competency in creating, managing, and distributing professional spreadsheets for a variety of specialized purposes and situations. The exam covers the ability to customize Excel environments to meet project needs and to enhance productivity. Expert workbook examples include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules.
1.12. Access Expert (Office 2019): Exam MO-500
This exam measures competency in database design principles. The exam covers the ability to create and maintain Access Database objects including tables, relationships, data entry forms, multilevel reports, and multi-table queries.
