Before you purchase anywhere, ask two questions: is the bank valid, and is my money safe? TestInsides answers both for the 77-727 exam — continuous version checks, a strict information safety system, and a written refund policy for Microsoft Core Data Analysis, Manipulation, and Presentation buyers.
Microsoft 77-727 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Excel 2016: Core Data Analysis, Manipulation, and Presentation |
| Exam Number: | 77-727 |
| Exam Price: | $100–$120 USD (varies by region) |
| Exam Format: | Simulated environment, Hands-on tasks, Performance-based |
| Real Exam Qty: | 30–35 |
| Certificate Validity Period: | Lifetime |
| Related Certifications: | MOS Expert 2016 MOS Master 2016 |
| Exam Duration: | 50 minutes |
| Passing Score: | 700 (on a scale of 100–1000) |
| Available Languages: | Bulgarian, Simplified Chinese, Korean, Polish, Spanish, Italian, Japanese, German, Romanian, Thai, Traditional Chinese, Turkish, English, Dutch, Arabic (Saudi Arabia), Portuguese (Brazil), Russian, French |
| Recommended Training: | Microsoft Official Courseware MOS Excel 2016 Training |
| Exam Registration: | Microsoft Learn Exam Page Certiport Registration |
| 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 |
|---|---|---|
| Create and manage worksheets and workbooks | 30–35% | - Format worksheets and workbooks - Customize options and views - Navigate in worksheets and workbooks - Create worksheets and workbooks - Configure workbooks for distribution |
| Perform operations with formulas and functions | 10–15% | - Perform calculations by using functions
- Insert references |
| Create tables | 15–20% | - Create and manage tables - Filter and sort records - Remove duplicate records - Apply table styles and options |
| Create charts and objects | 15–20% | - Create charts - Add alternative text for accessibility - Insert and format objects - Format graphic elements |
| 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 |
Straight Answers for Microsoft Core Data Analysis, Manipulation, and Presentation Candidates
Microsoft recommends the following official training resources:
Choose the format that fits your schedule, then reinforce it with regular question practice.
The latest exam information lists 30–35 questions for the 77-727 exam, to be completed within 50 minutes minutes. Knowing the format cold is half the battle — timed practice handles the other half.
These are the core domains of the Microsoft Core Data Analysis, Manipulation, and Presentation blueprint:
- Perform operations with formulas and functions (10–15%)
- Create and manage worksheets and workbooks (30–35%)
- Manage data cells and ranges (15–20%)
The remaining domains appear in the full official outline, all of which our bank addresses.
Microsoft sets the following prerequisites for the Microsoft Core Data Analysis, Manipulation, and Presentation: No formal prerequisites.
Check the current requirements on the official certification page before scheduling.
Validity is maintained, not assumed. Our dedicated IT team checks the system and pushes new versions to the site continuously, so the 77-727 bank on sale is always the latest — with expert-verified answers across the Microsoft Core Data Analysis, Manipulation, and Presentation objectives. You can also pick the format that fits your devices: an easy-to-read PDF, a Windows PC test engine, or a browser-based online engine for Windows, Mac, Android, and iOS. Questions? Support replies to instant messages and emails within two hours.
Upon successful payment, the complete materials are available immediately: a download link on screen and an automatic email to your mailbox within about a minute. If nothing arrives within two hours, check spam and contact support. Every purchase carries a 365-day service warranty — you can download the latest valid version free whenever it is released, no matter when you bought — and a 50% renewal discount follows when the period ends.
Use the official registration channels below:
Pick a center or online appointment that suits your timeline, and book early for the best selection of dates.
Yes, we keep our promises — in writing. If you fail the corresponding exam within 60 days of purchase, email us a scanned copy of your enrollment slip and your official Score Report PDF within two days of the exam date; we process verified refunds in full within seven days. The exclusions are plain: exams taken within three days of purchase, candidate names that do not match the payer, and free or expired products. If you prefer, we will exchange your product for two others of equal value at no charge.
As of the latest information, the 77-727 exam's passing score is 700 (on a scale of 100–1000) and the registration fee is $100–$120 USD (varies by region). Microsoft can adjust either figure, so verify both on the official site before you book.
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 "Orders" worksheet, use an automatic formatting method to format cells in the "OrderTotal" column
that contain above-average values by applying Green Fill with Dark Green Text. Use a technique that
automatically updates the formatting if the column values change.
Correct Answer:
See explanation below.
Explanation
1. Select the cells in the "OrderTotal" column which is the data range you are required to highlight the cells
which are above-average.
2. ClickConditional Formattingfrom theHometab, then selectTop/Bottom Rules, then select theAbove
Averageoption.
3. A popped up dialog box will then appear, select the Green Fill with Dark Green Text option as desired.
4. ClickOK.
References:
https://www.extendoffice.com/documents/excel/2195-excel-highlight-above-average.html
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.
Navigate to the range named "Oregon", and remove the contents of the selected cells.
Correct Answer:
See explanation below.
Explanation
1. ClickFind & Selectfrom theHometab then click onGo To.
OR
1.Press Ctrl+G on the keyboard.
2. Double-click the name range you want, in this case "Oregon".
3. Delete the contents in the selected cells by pressing Delete on your keyboard.
References:
https://support.office.com/en-us/article/Find-named-ranges-14513DF5-0D79-4CD5-9A03-968905B244E6
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 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, format the table so that every other row is shaded. Use a technique that
automatically updates the formatting if you insert a new row.
Correct Answer:
See explanation below.
Explanation
1. On the "Customers" worksheet, click theSelect AllbuttonORpress Ctrl+A.
2. Click the arrow next toConditional Formattingfrom theHometab in theStylesgroup, then selectNew Rule.
3. ClickSelect a Rule Typein theNew Formatting Ruledialog box, then selectUse a formula to determine which
cells to format.
4. In theFormat values where this formula is truebox, enter =MOD(ROW(),2)=0.
5. Click onFormat.
6. Click theFilltab from theFormat Cellsdialog box.
7. Select the desired shade background and then clickOK, you are able to view how the background would
look in thePreviewwindow in theNew Formatting Ruledialog box.
8. Once satisfied, apply the formatting to the cells by clickingOK.
References:
https://support.office.com/en-us/article/Apply-shading-to-alternate-rows-in-a-worksheet-A443B0F5-2025-42F6-
Jim 
Barret 
Evelyn 
Rudolf 
Cornell 
Queena 
Ives 
Webster 
Hulda 
Hulda 
Sandy 
Steven 
Earl 
Sandy 
Belinda 
Matthew 
Regan 
