Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation

Successful candidates for the Microsoft Office Specialist Excel 2016 certification exam have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They know and demonstrate the correct application of the principle features of Excel 2016. Candidates create and edit a workbook with multiple sheets, and they 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.

Microsoft Office Specialist (MOS) 2016 certification exams introduce a new performance-based format for improved testing of a candidate’s knowledge, skills, and abilities using the MOS 2016 programs:

  • MOS 2016 exam task instructions generally do not include the command name, as in previous versions. For example, function names are avoided and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects.
  • The MOS 2016 exam format incorporates multiple projects.

Part of the requirements for: Microsoft Office Specialist: Microsoft Excel 2016

Related exams: none

Important: See details

Go to Certification Dashboard

Schedule exam

  • 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation

    Languages: English, Chinese (Simplified), Chinese (Traditional), German, Spanish, French, Italian, Japanese, Korean, Norwegian, Dutch, Polish, Portuguese (Brazil), Romanian, Russian, Thai, Turkish

    Retirement date: none

    Successful candidates for the Microsoft Office Specialist Excel 2016 certification exam have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They know and demonstrate the correct application of the principle features of Excel 2016. Candidates create and edit a workbook with multiple sheets, and they 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.

    Price based on the country in which the exam is proctored.

    for Excel 2016: Core Data Analysis, Manipulation, and Presentation

    All objectives of the exam are covered in depth so you'll be ready for any question on the exam.

Skills measured

  • Create and manage worksheets and workbooks (30-35%)
  • Manage data cells and ranges (15-20%)
  • Create tables (15-20%)
  • Perform operations with formulas and functions (10-15%)
  • Create charts and objects (15-20%)

Download exam skills outline

Two ways to prepare

Learning paths to gain the skills needed to become certified

    Learning paths are not yet available for this exam

There may be certifications and prerequisites related to "Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation"

Exam resources

Training and certification guide

Explore all certifications in a concise training and certifications guide.

Certification dashboard

Review and manage your scheduled appointments, certificates, and transcripts.

Request accommodations

Learn more about requesting an accommodation for your exam.

Exam policies and FAQs

Review the exam policies and frequently asked questions.

* Pricing does not reflect any promotional offers or reduced pricing for Microsoft Imagine Academy program members, Microsoft Certified Trainers, and Microsoft Partner Network program members. Pricing is subject to change without notice. Pricing does not include applicable taxes. Please confirm exact pricing with the exam provider before registering to take an exam.

** Complete this exam before the retirement date to ensure it is applied toward your certification. After the retirement date, please refer to the related certification for exam requirements.