We're so confident of our products that we provide no hassle product exchange.
Introduction to Microsoft 77-727: Excel 2016-Core Data Analysis, Manipulation, and Presentation Exam
Candidates for Microsoft 77-727: Excel 2016-Core Data Analysis, Manipulation, and Presentation Exam are seeking to prove fundamental networking knowledge and skills. Before taking this exam, exam aspirants ought to have a solid fundamental information of the concepts shared in preparation guide.
It is suggested that professionals accustomed to the ideas and also the technologies represented here by taking relevant training courses. Candidates are expected to have some hands-on experience with tasks such as create and edit a workbook with multiple sheets, and they use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.
After passing this exam, candidates get a certificate from Microsoft that helps them to demonstrate their proficiency in MS Excel 2016 to their clients and employers.
The Microsoft 77-727 exam is necessary to obtain the associate-level certification known as the Microsoft Office Specialist: Microsoft Excel 2016. This test validates the candidates' skills in developing core data manipulation, analysis, and presentations with the help of Excel 2016 functions.
Reference: https://www.microsoft.com/en-us/learning/exam-77-727.aspx
Microsoft 77-727 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Excel 2016: Core Data Analysis, Manipulation, and Presentation |
| Exam Number: | 77-727 |
| Passing Score: | 700 (on a scale of 100–1000) |
| Exam Duration: | 50 minutes |
| Related Certifications: | MOS Master 2016 MOS Expert 2016 |
| Available Languages: | English, Romanian, French, Simplified Chinese, Japanese, Traditional Chinese, Portuguese (Brazil), Bulgarian, Arabic (Saudi Arabia), Thai, Dutch, Turkish, German, Italian, Korean, Spanish, Polish, Russian |
| Real Exam Qty: | 30–35 |
| Certificate Validity Period: | Lifetime |
| Exam Format: | Simulated environment, Hands-on tasks, Performance-based |
| Exam Price: | $100–$120 USD (varies by region) |
| Recommended Training: | Microsoft Official Courseware MOS Excel 2016 Training |
| Exam Registration: | Microsoft Learn Exam Page Certiport Registration |
| Sample Questions: | Microsoft 77-727 Sample Questions |
| Exam Way: | Online proctored or in-person at authorized testing centers |
| Pre Condition: | No formal prerequisites |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/exams/77-727/ |
Microsoft 77-727 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Manage data cells and ranges | 15–20% | - Insert data in cells and ranges - Summarize and organize data - Format cells and ranges - Create and modify named ranges |
| Topic 2: Create tables | 15–20% | - Filter and sort records - Create and manage tables - Apply table styles and options - Remove duplicate records |
| Topic 3: Create charts and objects | 15–20% | - Format graphic elements - Create charts - Add alternative text for accessibility - Insert and format objects |
| Topic 4: Perform operations with formulas and functions | 10–15% | - Perform calculations by using functions
- Format and modify text |
| Topic 5: Create and manage worksheets and workbooks | 30–35% | - Navigate in worksheets and workbooks - Format worksheets and workbooks - Customize options and views - Configure workbooks for distribution - Create worksheets and workbooks |
By Harley
