PDF Version DemoSecond-attempt candidates are the most honest judges of study material, and they keep choosing ActualPDF. The Microsoft Core Data Analysis, Manipulation, and Presentation package offers 35 verified 77-727 practice questions for people who want the next attempt to be the last.
Microsoft 77-727 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Excel 2016: Core Data Analysis, Manipulation, and Presentation |
| Exam Number: | 77-727 |
| Available Languages: | Chinese (Simplified), Spanish, Japanese, English, German, Portuguese, French |
| Passing Score: | 700/1000 |
| Real Exam Qty: | 35-50 |
| Exam Duration: | 50-60 |
| Certificate Validity Period: | No expiration (MOS 2016 certification generally does not expire) |
| Exam Format: | Hands-on lab simulation, Performance-based tasks, Project-based assessment |
| Exam Price: | $100 USD (varies by region) |
| Related Certifications: | Microsoft Office Specialist: Excel 2016 Microsoft Office Specialist: Excel 2016 Expert (77-728) |
| Recommended Training: | Microsoft Learn - Excel Certification Prep MOS Excel 2016 Expert Study Resources |
| Exam Registration: | Microsoft Credentials - MOS Certification Microsoft Certification Registration (Pearson VUE) |
| Sample Questions: |  |
| Exam Way: | Available via online proctored exams or authorized testing centers (Pearson VUE) |
| Pre Condition: | No strict prerequisite; prior experience with Microsoft Excel 2016 at an advanced level is recommended. |
| Official Syllabus URL: | https://learn.microsoft.com/credentials/certifications/mos-excel/ |
Microsoft 77-727 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Create Advanced Formulas and Functions | - Apply text, date, and financial functions - Use logical and lookup functions - Create and troubleshoot formulas |
| Analyze Data with PivotTables and Tools | - Create and manage PivotTables - Use data analysis tools (What-If Analysis, Forecasting) - Create PivotCharts |
| Manage and Share Workbooks | - Share and protect workbooks - Track and review changes - Manage workbook options and settings |
| Apply Custom Data Formats and Layouts | - Modify workbook structure and layout - Apply conditional formatting - Apply advanced formatting |
| Create Advanced Charts and Tables | - Format and enhance charts - Work with tables and structured data - Create and modify charts |
Questions and Answers About Microsoft Core Data Analysis, Manipulation, and Presentation
Microsoft Core Data Analysis, Manipulation, and Presentation is an official Microsoft exam, listed under exam code 77-727. A passing result earns you the Microsoft Office Specialist (MOS) Excel 2016 Expert certification at the Expert level. It also ties into Microsoft Office Specialist: Excel 2016 Expert (77-728), Microsoft Office Specialist: Excel 2016, extending its value across your certification roadmap. Employers read this credential as verified competence, which is why it keeps appearing in job requirements.
Expect 35-50 questions inside 50-60 on the Microsoft Core Data Analysis, Manipulation, and Presentation exam. That pace punishes hesitation, so rehearse it: the ActualPDF software engine simulates the real exam scene, reminds you of the questions you got wrong, and pushes you to re-practice them until the clock stops being your enemy.
Passing Microsoft Core Data Analysis, Manipulation, and Presentation requires 700/1000, and the official registration fee is $100 USD (varies by region). Retakes charge the full $100 USD (varies by region) again, which is why experienced candidates treat preparation as the cheaper exam fee. Verify your readiness with repeated ActualPDF practice scores above the requirement before you commit to a date.
No strict prerequisite; prior experience with Microsoft Excel 2016 at an advanced level is recommended.
Requirements evolve, so confirm the current conditions before registering on the official exam page.
Registration for Microsoft Core Data Analysis, Manipulation, and Presentation goes through the official channels listed here.
When you schedule, note that the exam is delivered Available via online proctored exams or authorized testing centers (Pearson VUE).
Microsoft recommends the following training for Microsoft Core Data Analysis, Manipulation, and Presentation candidates.
Follow any course with the 35 practice questions in the ActualPDF 77-727 package; the software engine will even remind you which mistakes need another round.
Yes. ActualPDF provides a free download demo of the Microsoft Core Data Analysis, Manipulation, and Presentation material, so you can check the content before choosing a version. After purchase, a one-year warranty covers you: the latest version is sent to you as it releases, free for 365 days, and after expiry you can extend the update service at a 50% discount.
Your purchase is covered by a 100% money-back guarantee with clear conditions. Take the Microsoft Core Data Analysis, Manipulation, and Presentation exam within 60 days of purchase; if you fail, provide your unqualified result by submitting a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and the full refund is processed within 7 days. The exam must match your product, candidate and payer names must match, and attempts within 3 days of purchase, unused downloads, free materials, and expired orders are not covered. Alternatively, exchange for two other exam products of equal value, free, or wait for updates while keeping your original product's update service.
Delivery is instant: files unlock for download at payment and are emailed within one minute. If nothing arrives within 2 hours, check spam and contact customer service, which works 7/24 and normally replies within two hours. Installation is unlimited across your computers.
The Microsoft Core Data Analysis, Manipulation, and Presentation syllabus spans 5 domains, led by Create Advanced Charts and Tables, Create Advanced Formulas and Functions, and Analyze Data with PivotTables and Tools. The complete topic list is published above; candidates who study the map first rarely get lost later.
Microsoft Core Data Analysis, Manipulation, and Presentation Sample Questions:
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a
workbook containing lists of donors.
Beginning at cell A5 of the "$5,000 Donors" worksheet, import the data from the tab-delimited sourcefile,
contributors.txt, located in the Documents folder. (Accept all defaults.)
See explanation below.
Explanation
1. Select cell A5 of the "$5,000 Donors" worksheet where you want the source file to be imported to.
2. Click on File, then selectOpen.
3. SelectText Filesfrom theOpendialog box.
4. Locate the contributors.txt file in the Documents folder, then double-click it.
5. ClickFinishto complete the operation.
References:
https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391
Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.
Check the spreadsheet for accessibility problems. Correct the error by adding "Tree Nursery Inventory" as an
alternative text file. You do not need to fix the warning.
See explanation below.
Explanation
1. To check the accessibility select theReviewtab from the ribbon.
2. SelectCheck Accessibility.
3. Review the results.
4. Exit theAccessibility Checker.
5. Right-click on the worksheet then clickFormatand then clickAlt Text.
6. Type "Tree Nursery Inventory" in theDescriptionbox.
7. ClickOK.
References:
https://support.office.com/en-us/article/Use-the-Accessibility-Checker-to-find-accessibility-issues-a16f6de0-2f39
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are
evaluating customer data and order data.
On the "Customers by Order" worksheet, use an Excel data tool to remove all records with duplicate
"CustomerID" values from the table. Do not remove any other records.
See explanation below.
Explanation
1. Select the cells in the "CustomerID" column which you want to have checked for duplicates.
2. SelectRemove Duplicatesfrom theDatatab.
3. Select the "CustomerID" column which you want to have checked under theColumnsoptions.
4. ClickOK.
References:
https://support.office.com/en-us/article/Find-and-remove-duplicates-00E35BEA-B46A-4D5D-B28E-66A552DC
Project 7 of 7: Farmers Market
Overview
You are the Director of a local farmers' market. You are creating and modifying charts for a report which
shows the amounts and variety of products sold during the season.
On the "Summer Sales" worksheet, add the "Total" data series to the "Top Sellers" column chart. Include the
total only for "Fruits", "Vegetables", and "Jams & Honey".
See explanation below.
Explanation
1. Select the "Top Sellers" column chart.
2. Click on the particular data point you want to label, clickAdd Chart Element +, from the upper right corner
next to the chart, then selectData Labels.
3. Then clickFormat Data Labels.
4. TheData Label Rangedialog box would appear, select the data range which are the cell values you want to
appear in the labels, in this case it would be the "Total" colunn for "Fruits", "Vegetables", and "Jams &
Honey", then clickOK.
References:
https://support.office.com/en-us/article/add-or-remove-data-labels-in-a-chart-884bf2f1-2e29-454e-8b42-f467c9f4
