• Home
  • Microsoft
  • 77-728 (Excel 2016 Expert: Interpreting Data for Insights)

Pass Your Microsoft 77-728 Exam Without Effort

100% Authentic Exam Questions, Answers Validated by IT Professionals

Regular Updates, Fast Download!

Add Comment

77-728 Exam Facts

Microsoft 77-728 is a qualifying test that evaluates the professionals’ advanced knowledge of Microsoft Excel 2016. The exam checks their skills in managing workbook settings and options. Moreover, this test includes applying custom data formats and layouts. Furthermore, the exam assesses the competence of the individuals in creating advanced tables, charts, and formulas. Those who nail the 77-728 test will earn the associated certificate that is Microsoft Office Specialist: Microsoft Excel 2016 Expert. Besides that, this exam is the main prerequisite for getting the Microsoft Office Specialist 2016 Master certification.

Requirements

Those students who plan to take Microsoft 77-728 need to be well versed with the Excel environment as well as possess the ability to guide others to the proper use of the program features. These specialists should have expertise in creating, managing, and distributing professional spreadsheets for various specialized situations and purposes. The applicants need to have competence in customizing their Excel environments to enhance productivity and meet the project needs. The intended audience for this certification test is Data Analysts, Accountants, Financial Analysts, and Commercial Bankers, among others.

Exam Overview

The 77-728 test has the duration of 50 minutes and includes about 40 to 60 questions. The exam is available in various languages. These include Dutch, French, Spanish, English, Korean, Japanese, Chinese (Simplified and Traditional), and German. To register for the test, the applicants need to pay $100. The 77-728: Excel 2016 Expert: Interpreting Data for Insights exam consists of several topics. The following is a brief overview of their subtopics:

Managing Workbook Settings and Options: The first domain measures the specialists’ expertise in:

  • Managing workbooks: It covers enabling macros in workbooks, saving a workbook as a template, displaying the hidden tabs of ribbon, referencing data in another workbook, and referencing data by using structured references.
  • Managing the review of a workbook: It concentrates on protecting worksheets, restricting editing, protecting workbook structure, encrypting a workbook with password, managing versions of a workbook, and configuring formula calculation options.

Applying Custom Data Formats and Layouts: Within this subject area, the examinees need to demonstrate their proficiency in:

  • Applying custom data formats and validation: It takes a look at creating custom formats of numbers, populating cells by utilizing advanced Fill Series options, and configuring data validation.
  • Applying advanced conditional filtering and formatting: It includes creating conditional rules of formatting, which use formulas, creating custom conditional rules of formatting, and managing conditional rules of formatting.
  • Creating and changing custom elements of a workbook: It is centered on creating and changing cell styles, creating and changing simple macros, creating custom formats of colors, creating and changing custom themes, and inserting and configuring form controls.
  • Preparing workbooks for internationalization: It is about applying international currency formats, displaying data in multiple international formats, and managing options for +Body and +Heading fonts.

Creating Advanced Formulas: The next section assesses the competence of the individuals in:

  • Applying the functions within formulas: It gives attention to performing statistical operations by utilizing the SUMIFS, AVERAGEIFS, and COUNTIFS functions, performing logical operations by utilizing the nested functions, and performing logical operations by utilizing the AND, OR, and NOT functions.
  • Looking up data by using the functions: It covers looking up data by using the INDEX, HLOOKUP, VLOOKUP, and MATCH functions.
  • Applying advanced date and time functions: It concentrates on referencing date and time by utilizing the NOW and TODAY functions and serializing numbers by utilizing the date and time functions.
  • Performing business intelligence and data analysis: It takes a look at referencing date and time by utilizing the NOW and TODAY functions, calculating data by utilizing the financial functions, performing what-if analysis by utilizing Goal Seek and Scenario Manager, using the cube functions to get data out of the Excel data model, as well as importing, consolidating, combining, transforming, displaying, and connecting to data.
  • Troubleshooting formulas: It is about monitoring formulas and cells by utilizing Watch Window, tracing precedence and dependence, evaluating formulas, and validating formulas by using error-checking rules.
  • Defining named objects and ranges: It is centered on naming tables, data ranges, and cells and managing named ranges and objects.

Creating Advanced Tables and Charts: The last module checks the proficiency of the students in:

  • Creating advanced charts: It covers creating dual-axis charts, saving a chart as a template, and adding trendlines to charts.
  • Creating and working with PivotTables: It includes creating PivotTables, creating slicers, adding calculated fields, modifying field selections and options, formatting data, and grouping PivotTable data.
  • Creating and working with PivotCharts: It is about creating PivotCharts, drilling down into PivotChart details, manipulating options in existing PivotCharts, and applying styles to PivotCharts.

Preparation Options

There are several learning tools that the individuals can use to prepare for the Microsoft 77-728 test. For instance, they can utilize exam dumps. They are the materials that consist of questions and answers from the previous tests. The applicants can utilize them to get conversant with the question patterns of the real exam. Moreover, dumps may be used to determine one’s weak areas. In addition, using this tool, the specialists can check their level of readiness. At the same time, the professionals may think about the official guidebook. It can be MOS 2016 Study Guide for Microsoft Excel Expert by Paul McFedries. This book contains important information regarding working with Microsoft Excel 2016. Besides that, it includes hands-on tasks as well as ready-made practice files. All in all, be sure to choose the preparation resources that suit your learning style and needs.

Career Opportunities

After clearing the Microsoft 77-728 exam, the professionals can validate their competence in working with Microsoft Excel 2016. This may be useful for different job roles. Some of them include a Data Analyst, an Office Manager, an Administrative Assistant, an Operations Analyst, a Staff Accountant, a Business Analyst, and a Financial Analyst. Furthermore, it can be a Procurement Specialist, a Logistics Analyst, a Marketing Analyst, an Education Program Coordinator, a Demand Planner, and a Grants Manager. According to the information from the PayScale website, the average remuneration for the Operations Analysts is $58,000 per annum, while the Procurement Specialists can get about $59,000 per year. At the same time, the median compensation outlook for the Business Analysts is $61,000 per annum.

SPECIAL OFFER: GET 25% OFF

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

SPECIAL OFFER: GET 25% OFF

Use Discount Code:

EXAM25

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.

Next

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.