Microsoft Office Specialist (MOS): Microsoft Excel 2016
Credential: Microsoft Office Specialist (MOS): Microsoft Excel 2016
Credentialing Agency: Microsoft Corporation
Renewal Period: Lifetime
The Microsoft Office Specialist (MOS): Microsoft Excel 2016 credential is an entry-level certification for individuals who wish to demonstrate expertise in using Microsoft Excel. To earn the Microsoft Office Specialist: Microsoft Excel 2016 certification, candidates must pass one, performance-based exam. While there are no experience requirements for this certification, candidates should understand the purpose and common usage of program functionality in order to successfully complete the tasks in each of the projects in the exam.
More information can be found on the certifying agency's website.
Microsoft Office Specialist (MOS): Microsoft Excel 2016
MINIMUM REQUIREMENTS
Attainability:
Eligibility Requirements
- Credential Prerequisite
- Experience
- Education
- Training
- Membership
- Other
- Fee
Note: This credential may have multiple options for a Service member to meet eligibility requirements. Requirements listed here are based on the minimum degree required.
Exam Requirements (View Details)
- Exam
- Written Exam
- Oral Exam
- Practical Exam
- Performance Assessment
Exam Administration (View Details)
- In-person exam
- Remote proctored on-line exam
- Third-party test vendor
RECERTIFICATION SUMMARY
Renewal Period: Lifetime
Written Exam 77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation
-
Create and manage worksheets and workbooks (30-35%)
- Create worksheets and workbooks
- Navigate in worksheets and workbooks
- Format worksheets and workbooks
- Customize options and views for worksheets and workbooks
- Configure worksheets and workbooks for distribution
-
Manage data cells and ranges (15-20%)
- Insert data in cells and ranges
- Format cells and ranges
- Summarize and organize data
-
Create tables (15-20%)
- Create and manage tables
- Manage table styles and options
- Filter and sort a table
-
Perform operations with formulas and functions (10-15%)
- Summarize data by using functions
- Perform conditional operations by using functions
- Format and modify text by using functions
-
Create charts and objects (15-20%)
- Create charts
- Format graphic elements
- Insert and format objects
Exam Preparation Resources
There are a number of resources available to help you prepare for the Microsoft Office Specialist (MOS): Microsoft Excel 2016 examination:
- Best Sources
- Related Courses
An additional resource is O'Reilly Learning Safari Books Online, a searchable digital library that provides online access to thousands of books, training videos and conference sessions. See the Educational Resources section on the Related Sites page here on COOL to learn how to get free access.
Testing Information
-
Exam Administration
Credential exams may be administered in-person at a testing site, proctored on-line remotely, or have options for both. If an exam is administered through a test vendor, the third-party test vendor box will be checked. The following test administration options apply to the Microsoft Office Specialist (MOS): Microsoft Excel 2016 credential where checked:
- In-person exam
- Remote proctored on-line exam
- Third-party test vendor
For more information on the Microsoft Corporation testing process, visit the agency website.
-
Third-Party Test Vendor Information
Testing for this credential is handled by the following vendor:
Pearson VUE
The test centers are located in the U.S. They also have some test centers on military bases.
To find out more, use the following links on the Pearson VUE website:
- Search for Testing Program
- Learn About Testing for Military Communities
- Agency/Certification Specific Testing Information
- Contact Pearson VUE
RECERTIFICATION
Microsoft Office Specialist (MOS): Microsoft Excel 2016
Renewal Period: Lifetime