Marine Corps COOL Snapshot - Microsoft Office Specialist (MOS): Microsoft Excel 2016

Microsoft Office Specialist (MOS): Microsoft Excel 2016

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

The following Marine Corps Enlisted MOSs provide training and/or experience that contributes to attaining this credential:

Enlisted Occupation	Occupation Type	Related As	COOL$
0111 Administrative Specialist	MOS	Most	COOL Bucks
0161 Postal Clerk	MOS	Some	COOL Bucks
0211 Counterintelligence/Human Intelligence (CI/HUMINT) Specialist	MOS	Some	COOL Bucks
0231 Intelligence Specialist	MOS	Some	COOL Bucks
0241 Imagery Analysis Specialist	MOS	Some	COOL Bucks
0261 Geospatial Intelligence Specialist	MOS	Some	COOL Bucks
0393 Light Armored Reconnaissance (LAR) Operations Chief	MOS	Some	COOL Bucks
0399 Operations Chief	MOS	Some	COOL Bucks
0844 Field Artillery Fire Control Marine	MOS	Other
0861 Fire Support Marine	MOS	Other
1711 Offensive Cyberspace Operator	MOS	Some	COOL Bucks
1721 Defensive Cyberspace Operator	MOS	Some	COOL Bucks
1799 Cyberspace Chief	MOS	Some	COOL Bucks
2621 Communications Intelligence / Electronic Warfare Operator	MOS	Some	COOL Bucks
2629 Signals Intelligence/ Electronic Warfare/Cyberspace Operations Technician	MOS	Other
2631 Electronic Intelligence (ELINT) Analyst	MOS	Other
2641 Cryptologic Language Analyst	MOS	Other
2651 Intelligence Surveillance Reconnaissance (ISR) Systems Engineer	MOS	Other
4421 Legal Services Specialist	MOS	Most	COOL Bucks
4512 Combat Graphics Specialist	MOS	Some	COOL Bucks
4571 Combat Videographer	MOS	Some	COOL Bucks
55XX Musician	MOS	Some	COOL Bucks
6042 Individual Material Readiness List (IMRL) Asset Manager	MOS	Some	COOL Bucks
6046 Aviation Maintenance Data Specialist	MOS	Some	COOL Bucks
7041 Aviation Operations Specialist	MOS	Some	COOL Bucks
7251 Air Traffic Controller-Trainee	MOS	Some	COOL Bucks
7257 Air Traffic Controller	MOS	Some	COOL Bucks
7291 Senior Air Traffic Controller	MOS	Some	COOL Bucks
Leader	MOS	Some	COOL Bucks
Marine Security Guard	Collateral Duty/Out of Billet MOS	Some	COOL Bucks

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

Continuing Education
Exam
Continuing Education OR Exam
Fee
Other

AGENCY CONTACT INFORMATION

Microsoft Corporation

One Microsoft Way
Redmond, WA 98052-6399

Phone: (800) 636-7544

Contact Page

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

General References
- Measureup.com Microsoft practice tests

Related Courses
- Microsoft Virtual Academy

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:

RECERTIFICATION

Microsoft Office Specialist (MOS): Microsoft Excel 2016

Renewal Period: Lifetime

The Microsoft Office Specialist (MOS): Microsoft Excel 2016 credential has the following recertification information:

This certification has no recertification requirements and cannot be renewed. Once Microsoft determines that a certification no longer reflects the latest technology or is no longer relevant in the marketplace, it will be retired and will eventually transition to a Legacy status for certification holders. For the most current certification status, refer to the Retired certifications page.

Note: Marine Corps COOL will only pay recertification fees for the current year, no arrears will be paid. Voucher requests for recertification fees must be submitted with proof of the current status of the certification (for example, a screen shot of your credentialing agency dashboard or a copy of a current fee receipt).