Microsoft 77-728 : Excel 2016 Expert: Interpreting Data for Insights

  • Exam Code: 77-728
  • Exam Name: Excel 2016 Expert: Interpreting Data for Insights
  • Updated: Nov 09, 2026
  • Q & A: 26 Questions and Answers

Already choose to buy: "PDF"

Total Price: $49.99  

About Microsoft 77-728 Exam Questions

In 2026, employers still look for credentials they can verify quickly, and 77-728 remains one of them. BraindumpsPrep gives that goal a realistic path: 26 verified practice questions, marked-error feedback, and updates that follow the exam as it evolves.

Microsoft 77-728 Exam Syllabus Topics:

SectionWeightObjectives
Manage Workbook Options and Settings10-15%- Manage workbooks
  • 1. Enable macros in a workbook
  • 2. Display hidden ribbon tabs
  • 3. Use structured references
  • 4. Copy macros between workbooks
  • 5. Save a workbook as a template
  • 6. Reference data in another workbook
- Manage workbook review
  • 1. Configure formula calculation options
  • 2. Encrypt workbooks with passwords
  • 3. Manage workbook versions
  • 4. Protect worksheets
  • 5. Restrict editing
  • 6. Protect workbook structure
Create Advanced Formulas35-40%- Perform data analysis and business intelligence
  • 1. Consolidate data
  • 2. Import, transform, combine and connect data
  • 3. Use Scenario Manager
  • 4. Use financial functions
  • 5. Use cube functions with the Excel data model
  • 6. Perform what-if analysis with Goal Seek
- Apply advanced date and time functions
  • 1. Use NOW and TODAY functions
  • 2. Serialize numbers by using date and time functions
- Define named ranges and objects
  • 1. Name tables
  • 2. Manage named ranges and objects
  • 3. Name ranges
  • 4. Name cells
- Troubleshoot formulas
  • 1. Identify and resolve formula errors
- Look up data by using functions
  • 1. Use HLOOKUP
  • 2. Use MATCH
  • 3. Use INDEX
  • 4. Use VLOOKUP
- Apply functions in formulas
  • 1. Use AND, OR and NOT functions
  • 2. Use nested functions
  • 3. Use SUMIFS, AVERAGEIFS and COUNTIFS
Create Advanced Charts and Tables25-30%- Create and manage PivotTables
  • 1. Format PivotTable data
  • 2. Create slicers
  • 3. Create PivotTables
  • 4. Add calculated fields
  • 5. Modify field selections and options
  • 6. Use GETPIVOTDATA
  • 7. Group PivotTable data
- Create advanced charts
  • 1. Save charts as templates
  • 2. Create dual-axis charts
  • 3. Add trendlines
Apply Custom Data Formats and Layouts20-25%- Apply advanced conditional formatting and filtering
  • 1. Manage conditional formatting rules
  • 2. Use formulas in conditional formatting
  • 3. Create custom conditional formatting rules
- Apply custom data formats and validation
  • 1. Configure data validation
  • 2. Create custom number formats
  • 3. Use advanced Fill Series options
- Prepare a workbook for internationalization
  • 1. Display data in multiple international formats
  • 2. Apply international currency formats
  • 3. Manage font settings for different regions
- Create and modify custom workbook elements
  • 1. Create and modify themes
  • 2. Insert and configure form controls
  • 3. Create and modify cell styles
  • 4. Create and modify simple macros
  • 5. Create custom color formats

Your Microsoft Excel 2016 Expert: Interpreting Data for Insights Questions, Answered

How Do the Three Formats Differ, and Which Should You Choose?

The Microsoft Excel 2016 Expert: Interpreting Data for Insights content is the same across all three formats: a printable PDF, a software engine, and an online engine. The free demo lets you try each interface before buying, so you can pick the one that matches how you study rather than guessing.

How many 77-728 practice questions are included?

The package contains 26 practice questions for the 77-728 exam, all verified by our IT experts. A free demo is available so you can review the style before you buy.

Topics Covered in This Microsoft Excel 2016 Expert: Interpreting Data for Insights Material

  • Apply Custom Data Formats and Layouts (20-25%)
  • Create Advanced Charts and Tables (25-30%)
  • Create Advanced Formulas (35-40%)

Use the weights above to divide your study time where it matters most.

Why Do Candidates Prefer the Interactive Test Engine?

The engine presents Microsoft Excel 2016 Expert: Interpreting Data for Insights questions in random order, so each session feels like a fresh test rather than a memorized list. After every simulated exam you receive a score, and your errors are clearly marked, which makes it easy to see your weak and strong areas and build a focused study plan.

Time Limit and Question Count of the 77-728 Exam

The real 77-728 exam gives you 50-60 minutes for 40-60 questions. The engine lets you rehearse under the same kind of time pressure, so pacing decisions become automatic.

Passing Score and Exam Fee for 77-728

To pass 77-728 you need 700/1000, and the official fee is USD 100. Setting the target score early makes it easier to measure your progress in practice tests.

Prerequisites for 77-728

No prerequisite exams required. Exam is part of the requirements for Microsoft Office Specialist: Excel Expert (Office 2016) and Microsoft Office Specialist: 2016 Master certifications.

Microsoft Excel 2016 Expert: Interpreting Data for Insights Sample Questions:

Question #1

Exhibit:

You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.
Task4:
In cell F2 of the "No Medals" worksheet, create a formula that will show if a team participated in both seasons or only the Summer games.
Display "Both" if the team participated in both seasons that year Display
"Summer Only" if the team participated only in the Summer games.

Reveal Solution  Discussion  0

Correct Answer:

Pending. Send the suggestions for this question.

Question #2

You have been a manager of a band for the past year. You are reviewing the data you have about the merchandise that was sold at all of the concerts.
Task2:
Exhibit:

On the "Merchandise-Costs" worksheet, change the dates in column A to Spanish (Mexico) using the format 14 de marzo de 2012. Change the currency C, E, G and H to $ Spanish (Mexico)

Reveal Solution  Discussion  0

Correct Answer:

See the explanation below.
Explanation
* Select column A - press Ctrl+1 and go to date in Number tab Select the desired format as given below and apply

* Selectcolumns C, E, G and H, press Ctrl+1 and go to currency in Number tab. Select the desired format as given below and apply

Question #3

You have been a manager of a band for the past year. You are reviewing the data you have about the merchandise that was sold at all of the concerts.
Task5:
Exhibit:

On the"Cost Pivot Chart" worksheet add a 3D Stacked Bar Chart that shows the data in the PivotTable.

Reveal Solution  Discussion  0

Correct Answer:

See the explanation below.
Explanation
Select the PivotTable and from the Analyze tab select the chart as mentioned below

Viewing page 1 out of 9 pages.
Viewing questions 1-3 out of 26 questions.

11%

After purchase, Instant Download: Upon successful payment, Our systems will automatically send the product you have purchased to your mailbox by email. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)

Contact US:

Support: Contact now 

Free Demo Download

Related Exams

Related Certifications

Over 36781+ Satisfied Customers

What Clients Say About Us

I can declare BraindumpsPrep to be the best website available on the internet for certification exams preparations. With the help of 77-728 exam dumps, I passed exam easily.

Sid Sid       5 star  

Excellent dumps by BraindumpsPrep for 77-728 certification exam. I took help from these and passed my exam with 91% marks. Highly recommended.

Arno Arno       5 star  

I reviewed your 77-728 questions and confirmed they are the latest real questions.

Berton Berton       4 star  

I have bought 77-728 exam materials before. It has new version trully.

Tracy Tracy       4.5 star  

Thanks for the advise! I found the 77-728 exam braindump is very helpful as the 77-728 practice questions are very accurate. I passed the exam early today.

Malcolm Malcolm       5 star  

I passed highly in my 77-728 exam last week! This 77-728 exam file is valid! Thank you for your excellent work!

Gemma Gemma       4.5 star  

77-728 exam dumps is valid, I used it and it made my life easier and after the training was done I gave the 77-728 test, when I pass the Microsoft exam I was so happy! Thank you!

Ansel Ansel       4.5 star  

The 77-728 exam dumps are very accurate and reliable. You can rely on it. I passed my exam two days ago. Good luck!

Yves Yves       4 star  

Very happy with this purchase, cheaper than market price. High-quality 77-728 dump!

Bing Bing       5 star  

I was a little skeptical about these 77-728 exam dumps but now I am fascinated. Passed and got great marks too. I couldn't ask for more.

Francis Francis       4.5 star  

I'm so excited to pass the 77-728 exam with your practice questions. Thanks! I will recommend your site BraindumpsPrep to all my friends and classmates!

Prima Prima       4 star  

I passed this morning. I think it was hard exam. There are few NEW question, this dump 90% questions and answers. Thanks...Good Luck for all!

Miles Miles       5 star  

I noticed that the last 77-728 practice guide is before the exam changes posted, so i bought it at once and passed the exam as i expected.

Hayden Hayden       4.5 star  

BraindumpsPrep 77-728 study guide helped me polish my skills with its exceptional QandAs. This study guide not only improvedmy knowledgebut also providedme the solutions to pass exam in Outstanding achievements in 77-728 exam!

Caesar Caesar       5 star  

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

QUALITY AND VALUE

BraindumpsPrep Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.

EASY TO PASS

If you prepare for the exams using our BraindumpsPrep testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.

TESTED AND APPROVED

We are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.

TRY BEFORE BUY

BraindumpsPrep offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.

Our Clients

Our website is aimed at relieving your pressure from heavy study load. Our Study Material offers you high-quality training material and will help you have a good knowledge of the actual test. Our website provides the best test engine with self-assessment features for enhanced progress.

Tags

Useful Links

Contact Us

Our Working Time: ( GMT 0:00-15:00 )
From Monday to Saturday

Support: Contact now 

If you have any question please leave me your email address, we will reply and send email to you in 12 hours.

Copyright © 2026 BraindumpsPrep NETWORK CO.,LIMITED. All Rights Reserved. All trademarks used are properties of their respective owners. Privacy Policy