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

77-728 real exams

Exam Code: 77-728

Exam Name: Excel 2016 Expert: Interpreting Data for Insights

Updated: Nov 19, 2026

Q & A: 26 Questions and Answers

Already choose to buy "PDF"
Price: $49.99 

In 2026, the 77-728 exam still has a reputation for tricky wording and broad coverage, and the Microsoft Excel 2016 Expert: Interpreting Data for Insights syllabus is no exception. Working through 26 practice questions at PassTorrent helps you spot weak areas early instead of discovering them in the testing center.

Microsoft 77-728 Exam Overview:

Certification Vendor:Microsoft
Exam Name:Microsoft Excel 2016 Expert: Interpreting Data for Insights
Exam Number:77-728
Passing Score:700 (out of 1000)
Real Exam Qty:Performance-based tasks (approximately 35–40)
Available Languages:German, French, Spanish, Japanese, English, Portuguese (Brazil), Chinese (Simplified)
Exam Duration:60 minutes
Exam Format:Performance-based tasks, Live-in-application (Microsoft Excel 2016)
Related Certifications:Microsoft Office Specialist Excel 2016 Expert
Exam Price:Varies by region (typically around 100 USD equivalent)
Certificate Validity Period:No expiration (MOS 2016 certifications do not expire)
Recommended Training:Official Microsoft Excel training resources
Microsoft Learn MOS Excel Expert 2016 resources
Exam Registration:Microsoft Certification Dashboard
Pearson VUE Microsoft Exams Registration
Sample Questions:Free Download 77-728 bootcamp pdf
Exam Way:Proctored exam delivered via testing centers or online proctoring depending on region
Pre Condition:Recommended experience with Microsoft Excel 2016 at an advanced level; MOS Excel 2016 (77-727) is often taken prior but not strictly required
Official Syllabus URL:https://learn.microsoft.com/en-us/credentials/certifications/mos-excel-expert-2016/

Microsoft 77-728 Exam Syllabus Topics:

SectionObjectives
Manage Advanced Charts and Tables- Create and modify charts
  • 1. Chart formatting and customization
    • 2. Advanced chart types
      - Analyze data with PivotTables
      • 1. Filter and summarize PivotTable data
        • 2. Create PivotTables
          Manage and Format Data- Apply advanced formatting
          • 1. Custom number formats
            • 2. Conditional formatting rules
              - Organize and validate data
              • 1. Sort and filter advanced data sets
                • 2. Data validation rules
                  Manage Workbook Options and Settings- Apply workbook-level settings
                  • 1. Manage workbook properties
                    • 2. Configure calculation options
                      - Prepare workbooks for collaboration
                      • 1. Inspect workbooks for issues
                        • 2. Manage versions and protection
                          Create Advanced Formulas and Macros- Apply advanced formulas
                          • 1. Lookup and reference functions
                            • 2. Logical and nested functions
                              - Create and manage macros
                              • 1. Assign macros to controls
                                • 2. Record macros

                                  77-728 Exam FAQ: What Candidates Ask About Microsoft Excel 2016 Expert: Interpreting Data for Insights

                                  The 77-728 exam, officially titled Excel 2016 Expert: Interpreting Data for Insights, is the Microsoft exam you pass to earn the Microsoft Office Specialist (MOS) Excel 2016 Expert certification, a credential at the Expert level. Passing it confirms the skills defined in the official exam outline, and it is associated with related credentials such as Microsoft Office Specialist Excel 2016 Expert.

                                  The 77-728 exam includes Performance-based tasks (approximately 35–40) questions and gives you 60 minutes to finish them. That is a tight pace per question, so get used to reading each stem once, flagging anything uncertain, and moving on rather than getting stuck. Running timed practice tests in the PassTorrent desktop or online test engine is the most reliable way to build that rhythm before exam day.

                                  The passing score for the 77-728 exam is 700 (out of 1000), and the official registration fee is Varies by region (typically around 100 USD equivalent). Keep in mind that a failed attempt means paying Varies by region (typically around 100 USD equivalent) again in full to retake it, so book your slot only when your scores on PassTorrent practice tests sit consistently above the passing line.

                                  Microsoft lists the following prerequisites or eligibility notes for the 77-728 exam: Recommended experience with Microsoft Excel 2016 at an advanced level; MOS Excel 2016 (77-727) is often taken prior but not strictly required. Requirements can change over time, so confirm the details on the official exam page at Microsoft's official site before you register.

                                  You can register for the 77-728 exam through the official channels below:

                                  The exam is delivered in the following format: Proctored exam delivered via testing centers or online proctoring depending on region. Choose a date that leaves you enough time to work through the full 26-question practice set first.

                                  Microsoft recommends the following training resources for 77-728 candidates:

                                  Official courses build the theory, and the 26 practice questions from PassTorrent help you turn that theory into exam-ready speed and accuracy.

                                  Yes. PassTorrent offers a free PDF demo of the 77-728 material, so you can check the question style and answer quality before purchasing. Every purchase also includes 365 days of free updates, and if your product expires you can extend the update service at a 50% discount from your member zone.

                                  Your purchase is protected by a 100% Money Back Guarantee with clear conditions: if you take the corresponding 77-728 exam within 60 days of purchase and do not pass, you can apply for a full refund. The candidate name must match the payer name, and you need to submit a scanned exam enrollment slip together with the official Score Report PDF within 2 days of taking the exam; claims are processed within 7 days. Sitting the exam within 3 days of purchase, downloading without taking the exam, free materials, and expired orders are not covered. If you would rather not take a refund, you can exchange your order for two free exam products of equal value and keep the update service on your original purchase.

                                  Delivery is instant: your download links are emailed within one minute of payment, and you can also download directly from the website. If nothing arrives within 2 hours, contact customer service and check your spam folder. There is no limit on how many computers you can install the material on.

                                  The 77-728 exam blueprint is divided into 4 domains, starting with Manage Advanced Charts and Tables; Manage and Format Data; Manage Workbook Options and Settings. For the complete domain-by-domain breakdown, see the Exam Topics section above — it lists every topic the current outline covers.

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

                                  Question #1

                                  Exhibit:

                                  You have spent the past year starting up an amusement park. You have decided to create a year end financial report for your stakeholders.
                                  Task2:
                                  Remove all of the conditional formatting from the "Year 1" sheet.

                                  Reveal Solution  Discussion  0

                                  Correct Answer:

                                  See the explanation below.
                                  Explanation
                                  On the "Year 1" sheet, go to home - conditional formatting - clear rules - clear rules from entire sheet

                                  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

                                  Exhibit:

                                  You have spent the past year starting up an amusement park. You have decided to create a year end financial report for your stakeholders.
                                  Task3:


                                  On the "Chart" sheet add a slicer for the "Expense/Income" Column

                                  Reveal Solution  Discussion  0

                                  Correct Answer:

                                  See the explanation below.
                                  Explanation
                                  Select the chart and then from 'analyze' tab of the 'Pivot Charts tools' tab, click on slicer. From the list select'Expenses/Income'and press ok

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

                                  11%

                                  What Clients Say About Us

                                  I tried this revolutionary 77-728 exam dumps and was stunned to see them really matching the actual exam. Highly appreciated!

                                  Ingrid Ingrid       4 star  

                                  This is all because of you. Passd 77-728

                                  Buck Buck       4 star  

                                  I will buy other Microsoft exams from you very soon.

                                  Meroy Meroy       5 star  

                                  Passed on my second attempt. The first time I try by myself, fail with 40%. The second time I purchase Microsoft 77-728 exam guide, it is valid. Pass with 92%.

                                  Baron Baron       5 star  

                                  Great value for money spent. Practised a lot on the exam testing software by PassTorrent. Real exam became much easier with it. Scored 91% marks in the 77-728 exam.

                                  Susan Susan       5 star  

                                  The secret of success is to do the common things uncommonly well., it was tough but somehow managed to do it.
                                  I AM PASSSSSSSSSED

                                  Wendy Wendy       4.5 star  

                                  I passed 77-728 exam easily. Well, I would like to recommend PassTorrent to other candidates. Thanks for your good exam materials and good service.

                                  Len Len       4 star  

                                  This is not the first time I bought your 77-728 guides.

                                  Matt Matt       5 star  

                                  The 77-728 practice dumps are valid! I have passed the paper recently and all questions that came in the paper were from the files. Thanks a lot!

                                  Tobey Tobey       4 star  

                                  My company asks me to get the 77-728 certification asap. When i felt worried, i found this 77-728 study guide, it is wonderful. Can't believe i passed so smoothly. Thanks so much!

                                  Kevin Kevin       4.5 star  

                                  I am from Indian, the money transfer is so convenient. Besides, 77-728 passed. I am very happy.

                                  King King       4.5 star  

                                  When I took the test, I found 5 new questions. Passd 77-728

                                  Marvin Marvin       5 star  

                                  Got through my last exam with only passing marks, which was not that much satisfying. I tried PassTorrent to encounter lack of time and summarized materials to get through 77-728 exam with distinction. It really proved their claim of providing 100% reaL q&as

                                  Ada Ada       5 star  

                                  Valid 77-728 exam materials, it covers everything you need to kmow for 77-728 exam. I passed my 77-728 exam with preparing for it for about a week. You can trust them!

                                  Kent Kent       4 star  

                                  77-728 certification is easy for me to get.

                                  Clementine Clementine       5 star  

                                  LEAVE A REPLY

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

                                  Why Choose PassTorrent

                                  Quality and Value

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

                                  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.

                                  Easy to Pass

                                  If you prepare for the exams using our PassTorrent 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.

                                  Try Before Buy

                                  PassTorrent 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

                                  amazon
                                  centurylink
                                  earthlink
                                  marriot
                                  vodafone
                                  comcast
                                  bofa
                                  charter
                                  vodafone
                                  xfinity
                                  timewarner
                                  verizon