• Home
  • Microsoft
  • 77-727 (Core Data Analysis, Manipulation, and Presentation)
Exam Code: 77-727
Exam Name: Core Data Analysis, Manipulation, and Presentation
Certification Provider: Microsoft
Corresponding Certification: MOS-Microsoft Office Specialist
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams

Over 53337+ Satisfied Customers

BEST OFFER

Instant Download Microsoft : 77-727

77-727

Check Updated on: Sep 17, 2026

No. of Questions: 35 Questions & Answers with Exam Engine

Download Limit: Unlimited

Choosing Purchase: "Desktop Test Engine"
Price: $59.98 

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.)

100% Money Back Guarantee

Actual4dump 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.

  • Best exam practice material
  • Three formats are optional
  • 10+ years of excellence
  • 365 Days Free Updates
  • Learn anywhere, anytime
  • 100% Safe shopping experience

Online Test Engine

  • Online Tool, Convenient, easy to study.
  • Instant Online Access 77-727 Dumps
  • Supports All Web Browsers
  • 77-727 Practice Online Anytime
  • Test History and Performance Review
  • Supports Windows / Mac / Android / iOS, etc.
  • Try Online Engine Demo
  • Total Questions: 35
  • Updated on: Sep 17, 2026
  • Price: $59.98

Desktop Test Engine

  • Installable Software Application
  • Simulates Real 77-727 Exam Environment
  • Builds 77-727 Exam Confidence
  • Supports MS Operating System
  • Two Modes For 77-727 Practice
  • Practice Offline Anytime
  • Software Screenshots
  • Total Questions: 35
  • Updated on: Sep 17, 2026
  • Price: $59.98

PDF Practice Q&A's

  • Printable 77-727 PDF Format
  • Prepared by Microsoft Experts
  • Instant Access to Download 77-727 PDF
  • Study Anywhere, Anytime
  • 365 Days Free Updates
  • Free 77-727 PDF Demo Available
  • Download Q&A's Demo
  • Total Questions: 35
  • Updated on: Sep 17, 2026
  • Price: $59.98

Knowing the subject is only part of 77-727 preparation; applying it under time limits is another. In 2026, Actual4dump test engines let you practice Microsoft Core Data Analysis, Manipulation, and Presentation questions in timed modes and review your progress across the 35-question set.

Microsoft 77-727 Exam Overview:

Certification Vendor:Microsoft
Exam Name:Excel 2016: Core Data Analysis, Manipulation, and Presentation
Exam Number:77-727
Available Languages:Chinese (Simplified), Thai, French, German, Korean, Japanese, Russian, Arabic (Saudi Arabia), Romanian, Portuguese (Brazil), Polish, Dutch, Turkish, English, Bulgarian, Italian, Chinese (Traditional), Spanish
Exam Format:Multiple Projects, Hands-on Tasks, Performance-based
Exam Duration:50 minutes
Related Certifications:Microsoft Office Specialist: Excel (Office 2016)
Sample Questions: DOWNLOAD DEMO
Exam Way:Performance-based exam delivered through Certiport testing centers or authorized online/proctored delivery where available.
Pre Condition:No prerequisite exams required.
Official Syllabus URL:https://learn.microsoft.com/en-us/credentials/certifications/mos-excel-2016/

Microsoft 77-727 Exam Syllabus Topics:

SectionObjectives
Perform Operations with Formulas and Functions- Format and Modify Text by Using Functions
  • 1. Format text by using RIGHT, LEFT, and MID functions
  • 2. Format text by using the CONCATENATE function
  • 3. Format text by using UPPER, LOWER, and PROPER functions
- Summarize Data by Using Functions
  • 1. Perform calculations by using the COUNT function
  • 2. Insert references
  • 3. Perform calculations by using the MIN and MAX functions
  • 4. Perform calculations by using the AVERAGE function
  • 5. Perform calculations by using the SUM function
- Perform Conditional Operations by Using Functions
  • 1. Perform logical operations by using the AVERAGEIF function
  • 2. Perform statistical operations by using the COUNTIF function
  • 3. Perform logical operations by using the IF function
  • 4. Perform logical operations by using the SUMIF function
Manage Data Cells and Ranges- Summarize and Organize Data
  • 1. Apply conditional formatting
  • 2. Insert sparklines
  • 3. Insert subtotals
  • 4. Outline data
- Format Cells and Ranges
  • 1. Apply cell styles
  • 2. Format cells by using Format Painter
  • 3. Apply cell formats
  • 4. Apply number formats
  • 5. Merge cells
  • 6. Wrap text within cells
  • 7. Modify cell alignment and indentation
- Insert Data in Cells and Ranges
  • 1. Fill cells by using Auto Fill
  • 2. Insert and delete cells
  • 3. Replace data
  • 4. Paste data by using special paste options
  • 5. Cut, copy, or paste data
Create and Manage Worksheets and Workbooks- Navigate in Worksheets and Workbooks
  • 1. Navigate to a named cell, range, or workbook element
  • 2. Insert and remove hyperlinks
  • 3. Search for data within a workbook
- Format Worksheets and Workbooks
  • 1. Insert and delete columns or rows
  • 2. Insert headers and footers
  • 3. Rename a worksheet
  • 4. Adjust row height and column width
  • 5. Change workbook themes
  • 6. Change worksheet tab color
  • 7. Modify page setup
  • 8. Change worksheet order
- Customize Options and Views for Worksheets and Workbooks
  • 1. Modify document properties
  • 2. Change magnification by using zoom tools
  • 3. Change workbook views
  • 4. Hide or unhide columns and rows
  • 5. Change window views
  • 6. Hide or unhide worksheets
  • 7. Display formulas
  • 8. Customize the Quick Access Toolbar
- Create Worksheets and Workbooks
  • 1. Create a workbook
  • 2. Import data from a delimited text file
  • 3. Add a worksheet to an existing workbook
  • 4. Copy and move a worksheet
- Configure Worksheets and Workbooks for Distribution
  • 1. Inspect a workbook for hidden properties or personal information
  • 2. Inspect a workbook for accessibility issues
  • 3. Print all or part of a workbook
  • 4. Display repeating row and column titles on multipage worksheets
  • 5. Set print scaling
  • 6. Inspect a workbook for compatibility issues
  • 7. Set a print area
  • 8. Save workbooks in alternative file formats
Create Charts and Objects- Insert and Format Objects
  • 1. Insert text boxes and shapes
  • 2. Modify object properties
  • 3. Insert images
  • 4. Add alternative text to objects for accessibility
- Format Charts
  • 1. Add and modify chart elements
  • 2. Move charts to a chart sheet
  • 3. Apply chart layouts and styles
  • 4. Resize charts
- Create Charts
  • 1. Switch between rows and columns in source data
  • 2. Create a new chart
  • 3. Analyze data by using Quick Analysis
  • 4. Add additional data series
Create Tables- Manage Table Styles and Options
  • 1. Insert total rows
  • 2. Apply styles to tables
  • 3. Configure table style options
- Filter and Sort a Table
  • 1. Change sort order
  • 2. Filter records
  • 3. Sort data by multiple columns
  • 4. Remove duplicate records
- Create and Manage Tables
  • 1. Add or remove table rows and columns
  • 2. Convert a table to a cell range
  • 3. Create an Excel table from a cell range

Common Questions About Microsoft Core Data Analysis, Manipulation, and Presentation

The 77-727 exam, Core Data Analysis, Manipulation, and Presentation, assesses whether a candidate can apply Microsoft knowledge to the skills measured by this credential. It is associated with the MOS-Microsoft Office Specialist certification. The certification is positioned at the Associate level. Related credentials include Microsoft Office Specialist: Excel (Office 2016).

The stated prerequisite information for Microsoft Core Data Analysis, Manipulation, and Presentation is: No prerequisite exams required. Before registering, review the eligibility details on the official exam page to confirm the requirements.

Yes. Actual4dump provides a free PDF demo so you can review the format and quality of the Microsoft Core Data Analysis, Manipulation, and Presentation practice questions before placing an order. Your purchase includes 365 days of free updates, and you can extend the update service after expiration at a 50% discount.

If you take the corresponding 77-727 exam within 60 days of purchase and do not pass, you may apply for a full refund under the 100% Money Back Guarantee. Claims based on an exam taken within 3 days of purchase are not eligible; free materials, expired orders, and downloaded products that were not used before sitting for the exam are also excluded. The candidate name must match the payer name.

To apply, submit a scanned enrollment slip and the official Score Report PDF within 2 days after the exam. Eligible requests are processed within 7 days. If you prefer an alternative, you may receive two free products of equal value and keep the update service for your original purchase.

Delivery is instant after payment. Your download is also sent to your email within one minute; if it has not arrived within 2 hours, contact customer service. There is no limit on the number of computers on which the material can be installed.

The published Microsoft Core Data Analysis, Manipulation, and Presentation outline contains 5 major domains. The opening domains include:

  • Perform Operations with Formulas and Functions (official weight not provided)
  • Create Tables (official weight not provided)
  • Create Charts and Objects (official weight not provided)

Review the complete Exam Topics section above for every domain and subtopic before planning your study time.

Microsoft Core Data Analysis, Manipulation, and Presentation Sample Questions:

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.

Configure the "Car Inventory" worksheet so the column headings in row 9 appear on all printed pages.

Reveal Solution  Discussion  0

Correct Answer:

See explanation below.
Explanation
1. On the "Car Inventory" worksheet, clickPrint Titlesfrom thePage Setupgroup, situated on thePage
Layouttab.
2. UnderPrint Titles, on theSheettab, type the reference of the row you want to reappear (row 9) in theRows to
repeat at topbox.
References:
https://support.office.com/en-us/article/Print-rows-with-column-headers-on-top-of-every-page-D3550133-F6A1-

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 M9 on the "Summer Bookings" worksheet, insert a function that calculates the number of groups
containing 12 or more people even if the order of the rows is changed.

Reveal Solution  Discussion  0

Correct Answer:

See explanation below.
Explanation
1. In cell M9, on the "Summer Bookings" worksheet, insert the followingCOUNTIFformula:
"=COUNTIF(G6:G24, >= 12")"
References:
https://support.office.com/en-us/article/count-numbers-greater-than-or-less-than-a-number-453b0ccc-cfaa-4332-

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.

Reveal Solution  Discussion  0

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.


On the "Adult Program" worksheet, insert aColumnsparkline for each sport that shows the enrollment for the
past five years.

Reveal Solution  Discussion  0

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

987 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)

passed my 77-727 test with good score using Q&A from Actual4dump

Merlin

Merlin     5 star  

I was referred to you by my boss!I am a lucky one to have you 77-727 exam.

Selena

Selena     4.5 star  

Passed my 77-727 exam today with 91% marks. Actual4dump gives brilliant sample exams for preparation. Satisfied with the content.

Brook

Brook     4 star  

I would recommend Actual4dump for your 77-727 exam prep study guides and practice tests. My experience with them has been wonderful. I passed highly.

King

King     4 star  

I used your 77-727 exams for practice and to identify my weak areas.

Breenda

Breenda     5 star  

Passing 77-727 exam materials was not easy to me, but the 77-727 exam dumps in Actual4dump help me pass the exam successfully, thank you very much.

Amos

Amos     4 star  

Before taking Actual4dump 77-727 practice questions, I tried once but failed.

Howar

Howar     4 star  

I will try other Microsoft exams next week.

Orville

Orville     4 star  

77-727 exam material is valid and it gave me shortcut to success. I bought 77-727 exam dumps this time and passed. Thanks!

Michelle

Michelle     5 star  

This is the first time i took the 77-727 exam and it's also the first time i bought the 77-727 exam guide, and i passed!

David

David     4.5 star  

Good dumps. The forcast is accurate. Key knowledge is complete for before-exam prepare. No 77-727 I will spend double time and energy on learning and maybe can not pass. Really really appreciate!

Yedda

Yedda     4.5 star  

The scenarios given were very tricky. Try to blow through yhe sims and save all your time for the questions. I just passed my 77-727 exam.

Barnett

Barnett     4.5 star  

I have got my Microsoft certification. Your exam pdf is very helpful. I will purchase another dumps from you soon. Thank you, Actual4dump!

Egbert

Egbert     5 star  

Your practice tests and the 77-727 exam result feedback were superb.

Truda

Truda     4.5 star  

Nice 77-727 practice tests. They are very valid! I bought three versions of PDF+Soft+APP, they gave me different feelings on practice and i passed the exam with confidence. Thank you!

Montague

Montague     4 star  

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Related Exams

 77-725 Actual Dumps

Instant Download 77-727

After Payment, our system will send you the products you purchase in mailbox in a minute after payment. If not received within 2 hours, please contact us.

365 Days Free Updates

Free update is available within 365 days after your purchase. After 365 days, you will get 50% discounts for updating.

Porto

Money Back Guarantee

Full refund if you fail the corresponding exam in 60 days after purchasing. And Free get any another product.

Security & Privacy

We respect customer privacy. We use McAfee's security service to provide you with utmost security for your personal information & peace of mind.