Microsoft 77-728 Exam Details & Actual Exam Questions
- Exam Code/Number: 77-728
- Exam Name/Title: Excel 2016 Expert: Interpreting Data for Insights
- Certification Provider: Microsoft
- Corresponding Certification: Microsoft Certification
- Exam Questions: 26
- Updated On: Nov,08 2026
- Certification Level: Expert
Microsoft Excel 2016 Expert: Interpreting Data for Insights Exam Questions
View 77-728 actual exam questions, answers and explanations for free.
94% student found the test questions almost same
All the information you need to pass Microsoft Excel 2016 Expert: Interpreting Data for Insights 77-728 exam and free practice exam verified by EduDump exam experts.
Said the test questions were almost same
Passed the exams with the material
Found the study quides effective and helpful
(41 Up Votes)Microsoft 77-728 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Excel 2016 Expert: Interpreting Data for Insights |
| Exam Number: | 77-728 |
| Real Exam Qty: | 40-60 |
| Available Languages: | Japanese, English, Spanish, Chinese (Simplified), French, Chinese (Traditional), Korean, German, Dutch |
| Exam Duration: | 50-60 |
| Certificate Validity Period: | Lifetime (for this specific software version) |
| Exam Format: | Performance-based, Interactive simulation, Project-based |
| Related Certifications: | MOS: PowerPoint 2016 (77-729) MOS: Microsoft Office Specialist 2016 Master MOS: Word 2016 Expert (77-726) |
| Exam Price: | $100 USD |
| Passing Score: | 700 out of 1000 |
| Recommended Training: | Microsoft Official Learning Path |
| Exam Registration: | Certiport Registration Microsoft Learn Exam Page |
| Sample Questions: | Microsoft 77-728 Sample Questions |
| Exam Way: | Online proctored or onsite at Certiport authorized test centers |
| Pre Condition: | No formal prerequisites; recommended to have completed MOS Excel 2016 Core or equivalent experience |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/exams/77-728/ |
Microsoft 77-728 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Manage Workbook Options and Settings | 10-15% | - Configure content for collaboration - Customize workbook and worksheet properties - Manage and format worksheets - Protect workbooks and worksheets - Configure workbook options and views |
| Topic 2: Apply Custom Data Formats and Layouts | 20-25% | - Create and manage custom cell formats - Manage structured data tables - Apply advanced conditional formatting and filtering - Apply custom number formats - Apply custom styles and templates |
| Topic 3: Create Advanced Formulas | 35-40% | - Troubleshoot formulas - Define named ranges and objects - Apply functions in formulas - Perform data analysis and business intelligence - Look up data using functions |
| Topic 4: Create Advanced Charts and Tables | 25-30% | - Create and modify PivotCharts - Manage data connections and analysis - Create advanced charts - Create and manage PivotTables - Apply chart styles and layouts |
0
0
0
10