We're so confident of our products that we provide no hassle product exchange.
Skills measured
- Applying formulas and functions
- Working with macros and forms
- Presenting data visually
- Sharing and maintaining workbooks
Reference: https://www.microsoft.com/en-us/learning/exam-77-888.aspx
Microsoft 77-888 Exam Overview:
| Certification Vendor: | Microsoft |
| Exam Name: | Excel 2010 Expert |
| Exam Number: | 77-888 |
| Passing Score: | 700 (on a scale of 1-1000) |
| Real Exam Qty: | 25-30 performance-based tasks |
| Certificate Validity Period: | Lifetime (retired exam, no renewal required) |
| Exam Duration: | 50 minutes |
| Exam Format: | Performance-based tasks, Live software simulation, Hands-on lab |
| Exam Price: | $100 USD |
| Available Languages: | English, Arabic, Simplified Chinese, Traditional Chinese, German, Spanish, French, Italian, Japanese, Korean, Dutch, Brazilian Portuguese |
| Related Certifications: | Microsoft Office Specialist (MOS) 2010 77-882 Excel 2010 |
| Recommended Training: | Microsoft Official Courseware MOS Expert Study Guides |
| Exam Registration: | Microsoft Learn Exam Page Certiport (MOS Exam Provider) |
| Sample Questions: | Microsoft 77-888 Sample Questions |
| Exam Way: | Proctored onsite at authorized test centers; online proctoring not available for this retired exam |
| Pre Condition: | No formal prerequisites; recommended to hold MOS Excel 2010 (77-882) or equivalent experience |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/exams/77-888/ |
Below are the topics of Microsoft 77-888 Exam
Candidates must know the topics before they start of preparation. Because it will really help them in hitting the core. Our Microsoft 77-888 exam dumps will include the following topics:
- Sharing and Maintaining workbooks
- Presenting Data Visually
- Applying Formulas and Functions
- Working with Macros and Forms
Microsoft 77-888 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Sharing and Maintaining Workbooks | 20% | - Manage versions and review workbooks - Apply workbook settings and properties - Import, export, and manipulate XML data - Protect and share workbooks and worksheets |
| Topic 2: Applying Formulas and Functions | 30% | - Apply logical, statistical, and mathematical functions - Apply financial and database functions - Use lookup, reference, and text functions - Work with array formulas and nested functions - Audit formulas and trace precedents/dependents |
| Topic 3: Working with Macros and Forms | 25% | - Implement data validation and protection - Insert and modify form controls - Configure macro security settings - Create, edit, and run macros - Use data analysis tools: What-If, Goal Seek, Solver |
| Topic 4: Presenting Data Visually | 25% | - Create and modify advanced charts and PivotCharts - Build and customize PivotTables - Apply advanced conditional formatting and styles - Manage tables, ranges, and structured references |
By Kyle
