Time saved at the start is time earned for study: Prep4SureReview emails the complete Microsoft Core Data Analysis, Manipulation, and Presentation package, 77-727 practice questions included, about a minute after payment.
Microsoft 77-727 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Create Charts and Objects | - Format Charts
|
| Topic 2: Create Tables | - Manage Table Styles and Options
|
| Topic 3: Perform Operations with Formulas and Functions | - Perform Conditional Operations by Using Functions
|
| Topic 4: Manage Data Cells and Ranges | - Format Cells and Ranges
|
| Topic 5: Create and Manage Worksheets and Workbooks | - Customize Options and Views for Worksheets and Workbooks
|
77-727 Exam FAQ: Reduce Your Risk, Read This First
Microsoft Core Data Analysis, Manipulation, and Presentation is an official Microsoft exam, identified by exam code 77-727. Passing it earns the MOS-Microsoft Office Specialist certification at the Associate level. It also relates to Microsoft Office Specialist: Excel (Office 2016). Certifications like this one remain a reliable route to standing out: they prove ability in a way resumes alone cannot.
No prerequisite exams required.
Vendor requirements change from time to time, so verify the current conditions before registering via the official exam page.
Yes. You can download the free demo of the Microsoft Core Data Analysis, Manipulation, and Presentation questions before you buy, and after purchase you have the right to one year of free updates. When your product expires, extending the update service costs 50% of the regular price. Three versions, PDF, software, and online APP, let you study the way that suits you.
A 100% money-back guarantee protects you under clear conditions. Take the Microsoft Core Data Analysis, Manipulation, and Presentation exam within 60 days of purchase; if you fail, you can claim a full refund, provided the exam matches your product. Attempts within 3 days of purchase are ineligible, as are downloaded-but-unused products, free materials, and expired orders; the candidate name must match the payer name. Submit a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and claims are processed within 7 days. Alternatively, exchange for two other exam products of equal value, free, while keeping the update service on your original purchase.
Delivery is instant: files unlock for download at payment and are automatically emailed within one minute. If nothing arrives within 2 hours, check spam and contact customer service, available 24/7. Installation is unlimited across your computers.
The Microsoft Core Data Analysis, Manipulation, and Presentation syllabus divides into 5 domains. The leading areas are Manage Data Cells and Ranges, Create and Manage Worksheets and Workbooks, and Perform Operations with Formulas and Functions. The complete outline is published above; knowing your shortcomings starts with knowing the syllabus.
Microsoft Core Data Analysis, Manipulation, and Presentation Sample Questions:
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 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 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,sortthe table to order the records by the "CountryOrRegion" field, with
customers in the United States first and customers in Canada second.
Then sort the customers in each country alphabetically (from A to Z) by the "StateOrProvince" field.
Finally, sort the customers in each state or province in ascending order by the 'PostalCode" field.
Correct Answer:
See explanation below.
Explanation
1. Select a cell in the "CountryOrRegion" field on the "Customers" worksheet.
2. Select Sort from theSort & Filtergroup in theDatatab.
3. In theSortdialog box, underColumnin theSort bybox, Select the "CountryOrRegion" field.
4. Under theSort Onoption, select the type of sort desired, in this caseValues, to sort by text.
5. UnderOrder, selectCustom List, then set it for customers in the United States to appear first, then the
customers in Canada.
6. Then to add another column to sort by, clickAdd Level.
7. In theSortdialog box, underColumnin theSort bybox, Select the "StateOrProvince" field.
8. Under theSort Onoption, selectValues.
9. UnderOrder, selectA to Z.
10. Add a final column by clickingAdd Level.
11. In theSortdialog box, underColumnin theSort bybox, Select the "PostalCode" field.
12. UnderSort On, selectValues.
13. UnderOrder, selectSmallest to Largest.
14. ClickOK.
References:
https://support.office.com/en-us/article/sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654
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.
Christine 
Hogan 
John 
Hayden 
Patrick 
Dominic 
Hiram 
Hogan 
Moses 
Josephine 
Bernie 
Christ 
Pamela 
Pandora 
