Over 63990+ Satisfied Customers
$79.98
56%OFF
(Include: PDF + Desktop Test Engine + Online Test Engine)
Instant Download: Upon successful payment, Our systems will automatically send the product you have purchased to your mailbox by email. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)
Download DemoCustom purchase
PrepAwayETE has an unprecedented 99.6% first time pass rate among our customers. We're so confident of our products that we provide no hassle product exchange.
Every day, our expert team checks the 77-727 exam question bank for updates, so the version you study in 2026 is the version that reflects the live exam. PrepAwayETE treats the accuracy of the Microsoft Core Data Analysis, Manipulation, and Presentation materials as a daily responsibility, not a one-time effort.
| 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 |
| Certificate Validity Period: | Lifetime |
| Exam Price: | $100–$120 USD (varies by region) |
| Exam Format: | Hands-on tasks, Performance-based, Simulated environment |
| Real Exam Qty: | 30–35 |
| Related Certifications: | MOS Expert 2016 MOS Master 2016 |
| Available Languages: | Russian, French, Turkish, Arabic (Saudi Arabia), Traditional Chinese, Japanese, Polish, Italian, Spanish, Simplified Chinese, German, Thai, Dutch, Portuguese (Brazil), Korean, Romanian, Bulgarian, English |
| Recommended Training: | Microsoft Official Courseware MOS Excel 2016 Training |
| Exam Registration: | Microsoft Learn Exam Page Certiport Registration |
| Sample Questions: | DOWNLOAD DEMO |
| 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/ |
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: 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 |
| Topic 2: Create tables | 15–20% | - Remove duplicate records - Apply table styles and options - Filter and sort records - Create and manage tables |
| Topic 3: Create and manage worksheets and workbooks | 30–35% | - Customize options and views - Create worksheets and workbooks - Configure workbooks for distribution - Navigate in worksheets and workbooks - Format worksheets and workbooks |
| Topic 4: Create charts and objects | 15–20% | - Create charts - Add alternative text for accessibility - Format graphic elements - Insert and format objects |
| Topic 5: Perform operations with formulas and functions | 10–15% | - Format and modify text - Perform calculations by using functions
|
Registration for the 77-727 exam runs through these official channels:
Given the exam's cost, book your sitting when your mock-exam results — not your calendar — say you are ready.
The 77-727 exam contains 30–35 questions with 50 minutes minutes to complete them. The PC test engine and the online test engine both let you rehearse under the same time pressure, so pacing stops being a variable on exam day.
No formal prerequisites
Passing the 77-727 exam requires 700 (on a scale of 100–1000), and registration costs $100–$120 USD (varies by region). That fee is exactly why candidates worry about wasting money on a failed attempt — and why structured preparation with verified answers is worth more than hopeful improvisation.
Same Microsoft Core Data Analysis, Manipulation, and Presentation content, different reach. The PC test engine runs on Windows, simulates the formal exam atmosphere, and shows you where your shortcomings and strengths lie — with no limit on the number of computers you install it on. The online test engine is available only at PrepAwayETE: it runs on Windows, Mac, Android, and iOS, and once loaded it works without internet, so you can practice the 77-727 exam questions on any device, at any time, anywhere. Both are built from the same daily-checked question bank.
The official outline divides the 77-727 exam into weighted domains, including:
The Microsoft Core Data Analysis, Manipulation, and Presentation practice questions at PrepAwayETE follow these same objectives across all three formats — PDF, PC engine, and online engine.
Work with your constraints, not against them. Short, regular sessions beat rare marathon ones: run a timed mock early to map your shortcomings, then spend your limited hours on those weak areas using the expert-verified answers to close each gap. The 77-727 exam bank is organized around the official objectives, so nothing you study is off-topic — and the online engine turns commutes and queues into usable Microsoft Core Data Analysis, Manipulation, and Presentation practice time.
Microsoft recommends these training resources for candidates:
If your schedule allows only one supplement to self-study, make it timed practice with verified answers — it converts knowledge into exam performance.
The 77-727 exam is the official assessment behind the Microsoft Core Data Analysis, Manipulation, and Presentation certification from Microsoft. Many candidates come to it at a career plateau, looking for a credential that demonstrates verified, practical command of the published objectives. The exam rewards preparation — and preparation is the one part of the process fully under your control.
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 "Spring Sales" worksheet, apply Style 3 and Monochromatic Color 2 (Monochromatic Palette 2) to the
3-D Pie chart.
Correct Answer:
See explanation below.
Explanation
1. Click on the 3-D Pie Chart on the "Spring Sales" worksheet.
2. This would display theChart Tools, click on the desired style which is Style 3 Monochromatic Color 2 from
theChart Stylesgroup situated on theDesigntab.
References:
https://support.office.com/en-us/article/Change-the-layout-or-style-of-a-chart-A346E438-D22A-4540-AA87-BC
Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.
Hiderows 29 and 30.
Correct Answer:
See explanation below.
Explanation
1. Select the rows you want to hide, in this case rows number 29 and 30 by clicking on them.
2. Right-click on the selected rows then click Hide.
References:
https://support.office.com/en-us/article/Hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f
Project 6 of 7: Bike Tours
Overview
You are the owner of a small bicycle tour company summarizing trail rides that have been booked for the next
six months.
Insert page numbering in the center of the footer on the "Summer Bookings" worksheet using the format Page
1 of ?.
Correct Answer:
See explanation below.
Explanation
1. On the "Summer Bookings" worksheet, clickHeader & Footerfrom theTextgroup situation on theInserttab.
2. ClickClick to add footerwhich would display theHeader & Footertools which gets added to theDesigntab.
3. Specify where the page number should be by selecting theCenter sectionbox.
4. On theDesigntab in theHeader & Footer Elementsgroup, clickPage Number.
5. The placeholder&[Page]will appear in the selected section, to add the total numberofpages type the word of
followed by the space in theHeader & Footer Elementsgroup after clickingNumber of Pages, then the
placeholder&[Page] of &[Pages]appear.
6. Click anywhere outside the header or footer area to display the page numbers inPage Layout View.
7. Once you are done working in thePage Layout View, clickNormalin theWorkbook Viewsgroup situated on
theViewtab. OR You can also clickNormalon the status bar.
References:
https://support.office.com/en-us/article/Insert-page-numbers-on-worksheets-27A88FB9-F54E-4AC4-84D7-BF95
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.
Apply the Rose, Table Style Light 17 (Table Style Light 17) to the "Inventory" table.
Correct Answer:
See explanation below.
Explanation
1. On the "Inventory" table, click on any cell.
2. Click onFormat as Tablefrom theHometab.
3. Select the Rose, Table Style Light 17 as desired.
References:
https://support.office.com/en-us/article/Format-an-Excel-table-6789619F-C889-495C-99C2-2F971C0E2370
Viewing page 1 out of 9 pages.
Viewing questions 1-4 out of 35 questions.
1193 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)My eternal desire to be on the cutting edge of my professional career always keep me hunting for latest certification exams related to my field. Thanks PrepAwayETE for helping me achieve it.
Ian
I can say that PrepAwayETE is well-reputed brand among the candidates. I used it's dump 2 times, and passed my exam in a short time.
Mark
So cool!
I used your update version and passed my 77-727 exam.
Haley
Excellent course for you to pass the 77-727 exam!
Kerr
Excellent dumps for 77-727. Valid questions and quite similar to the actual exam. Thank you so much PrepAwayETE. Cleared my exam yesterday and scored 90%.
Prescott
77-727 exam file is 100% valid! Took test today and passed. 77-727 exam is easy.
Mortimer
The best thing is to find the most reliable vendor for you are going to pass for sure. Thanks to PrepAwayETE, i have passed the 77-727 exam today.
Joyce
Using PrepAwayETE exam dumps, I passed with a high score in my 77-727 exam. Most of questions are from the dumps. I am pretty happy.
Dolores
I bought two versions of 77-727 exam braindumps, the PDF and Online test engine, they assisted me pass the exam just one time, so exciting!
Renee
My friend suggested me to take 77-727 exam as I saw an IT firm needed an employee with that qualification. Thanks to the dumps available at PrepAwayETE, and I passed exam with 90%.
Isaac
Exam practising software proved to be value for money. Thank you PrepAwayETE for providing such guidance. Advice to all to prepare with the practise exam software in order to get good marks. I got A 92% in the 77-727 certification exam.
Vita
I recommend you buy the 77-727 exam dump for your exam preparation. I passed last week. It is really helpful!
Thomas
PrepAwayETE is one of the best sites to educate yourself. Scored 91% in the 77-727 certification exam. You learn so many exam tips in no time
Asa
Excellent exam preparatory pdf files for Microsoft 77-727 exam. Helped me a lot in passing the exam in one attempt. Really satisfied with the content. Thank you so much PrepAwayETE.
Zara
I just passed my 77-727 exam after using 77-727 practice test and had 93% questions from your 77-727 practice braindumps. Thank you so much!
Harold
online test engine is very useful for me,because i could practice the 77-727 question dumps in my phone when i was waititng or on the bus even without internet,i could make the most of my time.Last week,i passed the 77-727. so i want to share the PrepAwayETE with you guys,hope you will get a good result in test.
Steward
I bought 77-727 exam dumps with my friends from you, and we both passed 77-727 exam, thank you very much!
John
I highly recommend to all of you this 77-727 exam dumps. I got a high passing score with this dump.
Thomas
0
0
0
0
If you have any question please leave me your email address, we will reply and send email to you in 12 hours.
Our Working Time: ( GMT 0:00-15:00 )
From Monday to Saturday
