In 2026, certification journeys reward the prepared. With 35 verified practice questions for 77-727, automatic update delivery, and a support team on call around the clock, ExamCost keeps Microsoft Core Data Analysis, Manipulation, and Presentation preparation steady rather than stressful.
Microsoft 77-727 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Excel 2016: Core Data Analysis, Manipulation, and Presentation |
| Exam Number: | 77-727 |
| Exam Duration: | 50 minutes |
| Passing Score: | 700 (on a scale of 100–1000) |
| Exam Price: | $100–$120 USD (varies by region) |
| Exam Format: | Performance-based, Simulated environment, Hands-on tasks |
| Related Certifications: | MOS Expert 2016 MOS Master 2016 |
| Real Exam Qty: | 30–35 |
| Available Languages: | Bulgarian, Dutch, Simplified Chinese, French, Romanian, Polish, Spanish, Russian, Japanese, Turkish, Portuguese (Brazil), German, Thai, Arabic (Saudi Arabia), Traditional Chinese, Italian, English, Korean |
| Certificate Validity Period: | Lifetime |
| Recommended Training: | MOS Excel 2016 Training Microsoft Official Courseware |
| Exam Registration: | Certiport Registration Microsoft Learn Exam Page |
| 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: Create charts and objects | 15–20% | - Insert and format objects - Add alternative text for accessibility - Create charts - Format graphic elements |
| Topic 2: Create and manage worksheets and workbooks | 30–35% | - Format worksheets and workbooks - Customize options and views - Create worksheets and workbooks - Navigate in worksheets and workbooks - Configure workbooks for distribution |
| Topic 3: Create tables | 15–20% | - Filter and sort records - Create and manage tables - Apply table styles and options - Remove duplicate records |
| Topic 4: Perform operations with formulas and functions | 10–15% | - Perform calculations by using functions
- Format and modify text |
| Topic 5: Manage data cells and ranges | 15–20% | - Create and modify named ranges - Summarize and organize data - Format cells and ranges - Insert data in cells and ranges |
Common Questions Before the 77-727 Exam
- Create and manage worksheets and workbooks (30–35%)
- Perform operations with formulas and functions (10–15%)
- Create tables (15–20%)
Use the weights to plan how much time each topic deserves.
No formal prerequisites
Buying the Microsoft Core Data Analysis, Manipulation, and Presentation material ahead of your exam date gives you room to study calmly and to work through several refreshed versions of the question bank as updates arrive. Early preparation turns revision into a routine instead of a last-minute rush.
77-727 requires 700 (on a scale of 100–1000) to pass, and the official exam fee is $100–$120 USD (varies by region). Knowing both numbers early helps you plan the exam date and your study target together.
The 77-727 exam contains 30–35 questions with a 50 minutes-minute limit. Practicing under identical conditions on the ExamCost engine makes time pressure feel familiar rather than frightening.
Microsoft Official Courseware: Visit official page
MOS Excel 2016 Training: Visit official page
Microsoft Learn Exam Page: register for 77-727
Certiport Registration: register for 77-727
Our professionals monitor the latest IT developments and adjust the material as soon as the exam outline shifts. New questions with verified answers are added, old and irrelevant ones are removed, and the size of the Microsoft Core Data Analysis, Manipulation, and Presentation bank is matched to actual exam conditions so your revision stays efficient.
This package includes 35 practice questions for the 77-727 exam, sized to reflect the real test and kept current through regular review.
Microsoft Core Data Analysis, Manipulation, and Presentation Sample Questions:
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" worksheet, enter a formula in cell N2 that uses an Excel function to return the average age
of the customers based on the values in the "CurrentAge" column.
Correct Answer:
See explanation below.
Explanation
1. Select cell N2 on the "Customers" worksheet, which is where you want the Excel function to return the
result to.
2. In theAddressbar, type the average function syntax;=AVERAGE(K1:K101).
References:
https://support.office.com/en-us/article/AVERAGE-function-047BAC88-D466-426C-A32B-8F33EB960CF6
Project 5 of 7: City Sports
Overview
The city events manager wants to analyze the enrollment changes over the past five years for various adult and
youth sports programs. You have been tasked to prepare tables for the analysis.
Unhide the "Summary" worksheet.
Correct Answer:
See explanation below.
Explanation
1. SelectFormatfrom theHometab then chooseHide and Unhidethen selectUnhide.
OR
1. Hold on the Ctrl button on the keyboard and choose all the worksheet tabs then choose theUnhideoption in
the right menu.
2. Click on the first worksheet tab, then hold down the Shift key on the keyboard as you click on the last
worksheet tab, then choose theUnhideoption.
OR
1. From theViewtab, clickCustom Viewsin theWorkbook Viewsgroup.
2. Click the "Summary" view which is hidden, then clickShow.
References:
https://www.isunshare.com/blog/hide-or-unhide-sheets-in-excel-2016/
Project 4 of 7: Car Inventory
Overview
You manage the office of a used car business. You have been asked to prepare the inventory list for a big
annual sale.
Simultaneously replace all instances of the text "Pickup" with the text "Truck".
Correct Answer:
See explanation below.
Explanation
1. ClickFind & Selectfrom theEditinggroup situated on theHometab.
2. ClickReplace.
3. Type the text "Pickup" in theFine whatbox.
4. ClickOptionsto further define the search, specify the "Car Inventory" worksheetselect Sheet in
theWithinbox.
5. Type "Truck" in theReplace withbox.
6. ClickFind All, and then clickReplace All.
7. Finalize by clickingOK.
References:
https://support.office.com/en-us/article/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b
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.
On the "$5,000 Donors" worksheet, hyperlink cell C3 to the email address "[email protected]".
Correct Answer:
See explanation below.
Explanation
1. Click on cell C3.
2. Enter the following formula: "=HYPERLINK([email protected], C3)
References:
https://support.office.com/en-us/article/HYPERLINK-function-333C7CE6-C5AE-4164-9C47-7DE9B76F577F
Viewing page 1 out of 9 pages.
Viewing questions 1-4 out of 35 questions.
