• Home
  • Microsoft
  • 77-727 (Excel 2016: Core Data Analysis, Manipulation, and Presentation)

Pass Your Microsoft 77-727 Exam Without Effort

100% Authentic Exam Questions, Answers Validated by IT Professionals

Regular Updates, Fast Download!

77-727 Premium Bundle


Microsoft 77-727 Premium Bundle

Premium File 35 Questions & Answers

Last Update: Nov 13, 2021

Training Course 85 Lectures

Study Guide 200 Pages

77-727 Bundle gives you unlimited access to "77-727" files. But you still need a .vce exam simulator. Download VCE exam simulator
Microsoft 77-727 Premium Bundle
Microsoft 77-727 Premium Bundle

Premium File 35 Questions & Answers

Last Update: Nov 13, 2021

Training Course 85 Lectures

Study Guide 200 Pages


77-727 Bundle gives you unlimited access to "77-727" files. However, this does not replace the need for a .vce exam simulator. To download your .vce exam simulator click here

Free 77-727 Exam Questions in VCE Format

File Size Downloads
3.62 MB

Add Comment

77-727 Exam Facts

The 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation certification test is developed to check the competence of the individuals in working with Microsoft Excel 2016. This exam measures the skills of the applicants in creating and managing workbooks and worksheets. Furthermore, it focuses on creating tables, objects, and charts. In addition, the test covers managing data cells and ranges as well as performing operations with functions and formulas. The professionals who ace Microsoft 77-727 will get the associated certificate, and namely Microsoft Office Specialist: Microsoft Excel 2016.


Those individuals who plan to nail the Microsoft 77-727 exam need to possess a comprehension of the Excel environment. Moreover, they should be acquainted with the principal features of Excel 2016. Besides that, the individuals need to have expertise in creating and editing workbooks with multiple sheets and using graphic elements to represent data visually.

Exam Overview

This qualifying test includes about 40-60 questions, which should be handled within 50 minutes. The applicants can take Microsoft 77-727 in German, Italian, French, Dutch, Spanish, English, Portuguese (Brazil), Japanese, Korean, Thai, Chinese (Traditional and Simplified), Arabic (Saudi Arabia), Russian, Turkish, Polish, Romanian, and Bulgarian (Bulgaria). The price for registration is $100. The exam comes with several domains. Here are their main objectives:

Creating and Managing Workbooks and Worksheets: The first topic assesses the proficiency of the individuals in:

  • Creating workbooks and worksheets: It is about creating workbooks, adding worksheets to an existing workbook, copying and moving a worksheet, and importing data from a delimited text file.
  • Navigating in workbooks and worksheets: It is centered on searching for data within workbooks and navigating to a named cell, range, or workbook element as well as inserting and removing hyperlinks.
  • Formatting workbooks and worksheets: It includes changing workbook themes, changing worksheet tab color, changing worksheet order, renaming a worksheet, modifying page setup, inserting and deleting columns or rows, adjusting row height and column width, and inserting headers and footers.
  • Customizing options and views for workbooks and worksheets: It concentrates on hiding or unhiding worksheets, hiding or unhiding columns and rows, changing magnification by utilizing zoom tools, customizing the Quick Access Toolbar, displaying formulas, changing window views, changing workbook views, and modifying document properties.
  • Setting workbooks and worksheets for distribution: It gives attention to setting a print area, saving workbooks in alternative file formats, setting print scaling, printing all or part of a workbook, displaying repeating row and column titles on multipage worksheets, inspecting workbooks for compatibility issues, inspecting workbooks for hidden properties or personal information, and inspecting workbooks for accessibility issues.

Managing Data Cells and Ranges: This module measures the competence of the professionals in:

  • Inserting data in cells and ranges: It covers replacing, cutting, copying, and pasting data as well as pasting data by utilizing special paste options, inserting and deleting cells, and filling cells by utilizing Auto Fill.
  • Formatting cells and ranges: It takes a look at modifying cell alignment and indentation, merging cells, wrapping text within cells, applying cell styles, applying cell formats, applying number formats, and formatting cells by utilizing Format Painter.
  • Summarizing and organizing data: It focuses on applying conditional formatting, outlining data, inserting subtotals, and inserting sparklines.

Creating Tables: The next subject area evaluates the expertise of the applicants in:

  • Creating and managing tables: It includes creating an Excel table from a cell range, converting a table to a cell range, and adding and removing table rows and columns.
  • Managing table options and styles: It is about inserting total rows, setting table style options, and applying styles to tables.
  • Filtering and sorting a table: It gives attention to sorting data by multiple columns, changing the sort order, filtering records, and removing duplicate records.

Performing Operations with Functions and Formulas: As for this section, the specialists need to show their skills in:

  • Summarizing data by utilizing functions: The test takers should possess competence in inserting references, performing calculations by utilizing the MIN and MAX functions, AVERAGE function, COUNT function, and SUM function.
  • Performing conditional operations by utilizing functions: The individuals need to be conversant with performing statistical operations by utilizing the COUNTIF function and performing logical operations by utilizing the AVERAGEIF function, IF function, and SUMIF function.
  • Formatting and modifying text by utilizing functions: The professionals should have expertise in formatting text by utilizing CONCATENATE, UPPER, LOWER, PROPER, RIGHT, LEFT, and MID functions.

Creating Objects and Charts: The last domain focuses on:

  • Creating charts: It covers creating new charts, adding additional data series, analyzing data by utilizing Quick Analysis, and switching between rows and columns in source data.
  • Formatting graphic elements: It is centered on adding and modifying chart elements, applying chart styles and layouts, resizing charts, and moving charts to a chart sheet.
  • Inserting and formatting objects: It takes a look at inserting images, inserting text boxes and shapes, modifying object properties, and adding alternative text to objects for accessibility.

Preparation Options

The applicants who plan to sit for the Microsoft 77-727 test may consider some preparation tools. There are several resources that can be used for this exam. These may be guidebooks, practice tests, or exam dumps. For instance, there is MOS 2016 Study Guide for Microsoft Excel by Joan Lambert. The book comes with the objective-by-objective test coverage. Furthermore, it contains easy-to-follow procedures and illustrations to review important skills. Moreover, this tutorial includes tasks to practice the learned material. At the same time, the individuals may consider braindumps. They are the questions and answers gathered from the previous tests. This is an effective tool to get familiar with the exam content as well as determine one’s weak areas. In addition, it may be used to check one’s level of readiness.

Career Opportunities

As mentioned earlier, those candidates who pass Microsoft 77-727 will obtain the associated certification: Microsoft Office Specialist: Microsoft Excel 2016. This certificate confirms one’s skills in working with Microsoft Excel 2016. It can come in handy for different job titles. Some of them are enumerated below:

  • Operations Analyst;
  • Procurement Specialist;
  • Education Program Coordinator;
  • Research Analyst;
  • Data Analyst;
  • Accountant;
  • Business Development Specialist;
  • Office Administrator.

The median salary outlook for these job roles varies from $46,000 to $61,000 per year.


Exam-collection.com Premium

Exam-collection.com Premium Files

Get Unlimited Access to all Exam-collection.com PREMIUM files!

  • Exam-collection.com Certified Safe Files
  • Guaranteed to have ACTUAL Exam Questions
  • Up-to-Date Exam Study Material - Verified by Experts
  • Instant Downloads
Enter Your Email Address to Receive Your 25% Off Discount Code
A Confirmation Link will be sent to this email address to verify your login
We value your privacy. We will not rent or sell your email address


Use Discount Code:


A confirmation link was sent to your e-mail.
Please check your mailbox for a message from support@exam-collection.com and follow the directions.


Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.