Short on time before your 77-728 exam date? The Microsoft Excel 2016 Expert: Interpreting Data for Insights question set from ActualCollection packs 26 practice questions into a format you can work through whenever a spare hour shows up. In 2026, plenty of busy professionals fit their prep into lunch breaks and commutes, and this material is built for exactly that.
Microsoft 77-728 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Excel Expert (Office 2016) - Interpreting Data for Insights |
| Exam Number: | 77-728 |
| Exam Format: | Hands-on Excel tasks, Performance-based, Multiple projects |
| Real Exam Qty: | 40-60 |
| Exam Duration: | 50-60 |
| Available Languages: | Japanese, French, Dutch, Korean, Spanish, German, Chinese (Simplified), English, Chinese (Traditional) |
| Related Certifications: | Microsoft Office Specialist: 2016 Master Microsoft Office Specialist: Excel Expert (Office 2016) |
| Exam Price: | USD 100 |
| Passing Score: | 700/1000 |
| Certificate Validity Period: | No fixed expiration for the certification version; exam retired with Office 2016 certification track |
| Sample Questions: | ![]() |
| Exam Way: | Delivered through Certiport authorized testing centers; performance-based exam conducted on a live Excel 2016 environment. |
| Pre Condition: | 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. |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/exams/77-728/ |
Microsoft 77-728 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Create Advanced Formulas | 35-40% | - Troubleshoot formulas
|
| Apply Custom Data Formats and Layouts | 20-25% | - Prepare a workbook for internationalization
|
| Manage Workbook Options and Settings | 10-15% | - Manage workbooks
|
| Create Advanced Charts and Tables | 25-30% | - Create advanced charts
|
Microsoft 77-728 Exam: Frequently Asked Questions
The Microsoft Excel 2016 Expert: Interpreting Data for Insights exam is the official Microsoft test registered under exam code 77-728. Passing it earns you the Microsoft Certification certification, a credential at the Expert level. It is also linked to the related certifications: Microsoft Office Specialist: Excel Expert (Office 2016), Microsoft Office Specialist: 2016 Master. Microsoft exams are valued because they test job-ready skills, so a passing score here carries real weight on a resume.
The Microsoft Excel 2016 Expert: Interpreting Data for Insights exam includes 40-60 questions to be completed within 50-60. Do the pacing math before exam day: with that many items on the clock, you need a steady rhythm and the discipline to flag a hard question and move on instead of stalling. Two or three full timed sessions with the ActualCollection test engine will show you exactly what that pace feels like, so time pressure stops being a factor on the real day.
To pass the Microsoft Excel 2016 Expert: Interpreting Data for Insights exam you need 700/1000, and the official registration fee is USD 100. A retake is not discounted: a failed attempt means paying the full USD 100 again, so treat your first sitting as the expensive one. A sensible rule is to book your seat only after you are scoring comfortably above the passing mark on the ActualCollection practice tests, not just squeaking past it once.
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.
Eligibility rules do change from time to time, so confirm the current requirements before you register on the official exam page.
Yes. ActualCollection offers a free PDF demo of the Microsoft Excel 2016 Expert: Interpreting Data for Insights material so you can judge the question quality and format before spending anything. After purchase, your license includes 365 days of free updates, and if you want to keep receiving updates after that period, renewals are available at a 50% discount.
If you take the Microsoft Excel 2016 Expert: Interpreting Data for Insights exam within 60 days of your purchase and do not pass, ActualCollection backs you with a 100% money-back guarantee. The claim must match the exam your product covers: attempts taken within 3 days of purchase are not eligible (that is too little preparation time), and neither are downloaded-but-unused products, free materials, or expired orders. The candidate name must match the payer name, and you need to submit a scanned enrollment slip plus the official Score Report PDF within 2 days of the exam; claims are processed within 7 days. Prefer not to refund? You can swap instead and receive two other exam products of equal value for free while keeping the update service on your original purchase.
Delivery itself is instant: your files are downloadable right away and emailed to you within one minute of payment. If nothing arrives within 2 hours, contact customer service. There is no limit on how many computers you may install the software on.
The official Microsoft Excel 2016 Expert: Interpreting Data for Insights syllabus is organized into 4 domains. Key areas include Apply Custom Data Formats and Layouts (20-25%), Create Advanced Formulas (35-40%), and Create Advanced Charts and Tables (25-30%). The complete, up-to-date topic list appears in the exam topics section above; work through it line by line and flag anything you cannot yet explain in your own words.
Microsoft Excel 2016 Expert: Interpreting Data for Insights Sample Questions:
Question 1
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.
Task 1:
Exhibit:
On the "Sales Pivot Chart" worksheet add the "Price each t-shirt" field as a filter to the PivotChart.
Question 2
Exhibit:
Task 1:
On the "Batches in progress" worksheet format columns C and D to display numeric values to three decimal places.
The format should be applied to existing and new row.
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.
Task4:
Exhibit:
Remove the name "Sales" that refers to the range "Merchandise-Sales'ISAS1 SHS17".
Solutions:
| Question 1 Answer: Only visible for members | Question 2 Answer: Only visible for members | Question 3 Answer: Only visible for members |






1376 Customer Reviews
