Privacy is part of the service at Lead2Passed: a strict information protection system guards every 77-727 order, and even customer service staff cannot see your complete details while they help you with the Microsoft Core Data Analysis, Manipulation, and Presentation bank.
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) |
| Related Certifications: | MOS Master 2016 MOS Expert 2016 |
| Real Exam Qty: | 30–35 |
| Certificate Validity Period: | Lifetime |
| Available Languages: | Dutch, German, Korean, Romanian, Italian, Japanese, English, Simplified Chinese, Russian, Arabic (Saudi Arabia), Turkish, Bulgarian, French, Spanish, Portuguese (Brazil), Traditional Chinese, Polish, Thai |
| Exam Duration: | 50 minutes |
| Exam Format: | Performance-based, Hands-on tasks, Simulated environment |
| Exam Price: | $100–$120 USD (varies by region) |
| Recommended Training: | Microsoft Official Courseware MOS Excel 2016 Training |
| Exam Registration: | Certiport Registration Microsoft Learn Exam Page |
| 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/ |
Microsoft 77-727 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Create and manage worksheets and workbooks | 30–35% | - Customize options and views - Create worksheets and workbooks - Navigate in worksheets and workbooks - Format worksheets and workbooks - Configure workbooks for distribution |
| Create tables | 15–20% | - Create and manage tables - Apply table styles and options - Remove duplicate records - Filter and sort records |
| Manage data cells and ranges | 15–20% | - Summarize and organize data - Insert data in cells and ranges - Create and modify named ranges - Format cells and ranges |
| Create charts and objects | 15–20% | - Format graphic elements - Create charts - Add alternative text for accessibility - Insert and format objects |
| Perform operations with formulas and functions | 10–15% | - Insert references - Perform calculations by using functions
|
Your Microsoft Core Data Analysis, Manipulation, and Presentation Preparation Questions, Answered
- Create and manage worksheets and workbooks (30–35%)
- Create tables (15–20%)
- Manage data cells and ranges (15–20%)
Microsoft Core Data Analysis, Manipulation, and Presentation Sample Questions:
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.
On the "Adult Program" worksheet, insert aColumnsparkline for each sport that shows the enrollment for the
past five years.
Correct Answer:
See explanation below.
Explanation
1. On the "Adult Program" worksheet, select the area you want the sparkline to be inserted.
2. Click Column in theSparklinesgroup from theInserttab.
3. Enter the range of cells in theData Rangebox, in this caseA10:A19.
OR
3. Select the range of cells by temporarily collapsing the dialog box and manually selecting the cells.
4. ClickOKand theSparkline Toolswill appear, theDesigntab can be used to customize the sparklines.
References:
https://support.office.com/en-us/article/analyze-trends-in-data-using-sparklines-be6579cf-a8e3-471a-a459-87361
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.
In cell C8 on the "Summer Bookings" worksheet, insert a function that joins the customer "Lastname" to the
customer "Firstname" separated by a comma and space. (Example: Campbell, David).
Correct Answer:
See explanation below.
Explanation
1. In cell C8 on the "Summer Bookings" worksheet, insert the followingCONCATfunction: "=CONCAT(E6 ",
"D6)"OR"=E6& ", ", D6".
References:
https://support.office.com/en-us/article/Combine-text-from-two-or-more-cells-into-one-cell-81ba0946-ce78-42ed
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, use the data in the "Products" and "Total" columns only to create a 3-D
Pie chart. Position the new chart to the right of the column charts.
Correct Answer:
See explanation below.
Explanation
1. Select the data you would like to use, in this case it would be the data in the "Products" and "Total"
columns from the "Summer Sales" worksheet.
2. Click onInsert Pie Chartsituation on theInserttab then pick the 3-D Pie chart as desired.
3. Format the chart as desired by usingChart Elements, theChart Styles, or theChart Filters.
4. Drag the Pie Chart to the desired location which is to the right of the column charts.
References:
https://support.office.com/en-us/article/Add-a-pie-chart-1A5F08AE-BA40-46F2-9ED0-FF84873B7863
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.
In cell M10 on the "Summer Bookings" worksheet, insert a function that calculates the total amount of sales
from the "Total" column for groups containing 12 or more people even if the order of the rows is changed.
Correct Answer:
See explanation below.
Explanation
1. In cell M10 on the "Summer Bookings", insert the followingSUMIFformula: "=SUMIF(G6:G24, ">= 12",
I6:I24)."'
References:
https://support.office.com/en-us/article/SUMIF-function-169B8C99-C05C-4483-A712-1697A653039B
Viewing page 1 out of 9 pages.
Viewing questions 1-4 out of 35 questions.
1133 Customer Reviews
