• 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 59597+ Satisfied Customers

BEST OFFER

Instant Download Microsoft : 77-727 Questions & Answers as PDF & Test Engine

77-727

Updated: Oct 31, 2026

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

Download Limit: Unlimited

Choosing Purchase: "Online Test Engine"
Price: $59.00 

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

ExamPrepAway 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

77-727 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: Oct 31, 2026
  • Price: $59.00

77-727 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: Oct 31, 2026
  • Price: $59.00

77-727 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: Oct 31, 2026
  • Price: $59.00

The cost of the 77-727 exam itself is high enough that nobody wants to pay it twice. If you worry about wasting time and money on a failed attempt, the Microsoft Core Data Analysis, Manipulation, and Presentation materials at ExamPrepAway exist for exactly that concern — thorough preparation, verified answers, and a written refund policy behind it all.

Microsoft 77-727 Exam Overview:

Certification Vendor:Microsoft
Exam Name:Excel 2016: Core Data Analysis, Manipulation, and Presentation
Exam Number:77-727
Available Languages:Korean, Italian, Arabic (Saudi Arabia), German, Chinese (Simplified), English, Japanese, Bulgarian, Romanian, Turkish, Dutch, Spanish, Chinese (Traditional), Portuguese (Brazil), Thai, French, Russian, Polish
Related Certifications:Microsoft Office Specialist: Excel (Office 2016)
Exam Duration:50 minutes
Exam Format:Hands-on Tasks, Performance-based, Multiple Projects
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
Topic 1: Create Charts and Objects- Format Charts
  • 1. Apply chart layouts and styles
  • 2. Move charts to a chart sheet
  • 3. Resize charts
  • 4. Add and modify chart elements
- Insert and Format Objects
  • 1. Insert text boxes and shapes
  • 2. Add alternative text to objects for accessibility
  • 3. Modify object properties
  • 4. Insert images
- Create Charts
  • 1. Add additional data series
  • 2. Switch between rows and columns in source data
  • 3. Create a new chart
  • 4. Analyze data by using Quick Analysis
Topic 2: Create Tables- Create and Manage Tables
  • 1. Add or remove table rows and columns
  • 2. Create an Excel table from a cell range
  • 3. Convert a table to a cell range
- Manage Table Styles and Options
  • 1. Insert total rows
  • 2. Configure table style options
  • 3. Apply styles to tables
- Filter and Sort a Table
  • 1. Remove duplicate records
  • 2. Filter records
  • 3. Sort data by multiple columns
  • 4. Change sort order
Topic 3: Manage Data Cells and Ranges- Summarize and Organize Data
  • 1. Insert subtotals
  • 2. Insert sparklines
  • 3. Apply conditional formatting
  • 4. Outline data
- Format Cells and Ranges
  • 1. Wrap text within cells
  • 2. Apply cell formats
  • 3. Merge cells
  • 4. Apply cell styles
  • 5. Format cells by using Format Painter
  • 6. Modify cell alignment and indentation
  • 7. Apply number formats
- Insert Data in Cells and Ranges
  • 1. Cut, copy, or paste data
  • 2. Paste data by using special paste options
  • 3. Replace data
  • 4. Insert and delete cells
  • 5. Fill cells by using Auto Fill
Topic 4: Perform Operations with Formulas and Functions- Summarize Data by Using Functions
  • 1. Perform calculations by using the SUM function
  • 2. Perform calculations by using the COUNT function
  • 3. Perform calculations by using the AVERAGE function
  • 4. Perform calculations by using the MIN and MAX functions
  • 5. Insert references
- Format and Modify Text by Using Functions
  • 1. Format text by using UPPER, LOWER, and PROPER functions
  • 2. Format text by using RIGHT, LEFT, and MID functions
  • 3. Format text by using the CONCATENATE function
- Perform Conditional Operations by Using Functions
  • 1. Perform logical operations by using the IF function
  • 2. Perform logical operations by using the SUMIF function
  • 3. Perform statistical operations by using the COUNTIF function
  • 4. Perform logical operations by using the AVERAGEIF function
Topic 5: Create and Manage Worksheets and Workbooks- Configure Worksheets and Workbooks for Distribution
  • 1. Set a print area
  • 2. Set print scaling
  • 3. Inspect a workbook for compatibility issues
  • 4. Inspect a workbook for accessibility issues
  • 5. Save workbooks in alternative file formats
  • 6. Print all or part of a workbook
  • 7. Display repeating row and column titles on multipage worksheets
  • 8. Inspect a workbook for hidden properties or personal information
- Create Worksheets and Workbooks
  • 1. Import data from a delimited text file
  • 2. Add a worksheet to an existing workbook
  • 3. Copy and move a worksheet
  • 4. Create a workbook
- Format Worksheets and Workbooks
  • 1. Change worksheet tab color
  • 2. Change worksheet order
  • 3. Modify page setup
  • 4. Adjust row height and column width
  • 5. Insert headers and footers
  • 6. Insert and delete columns or rows
  • 7. Rename a worksheet
  • 8. Change workbook themes
- Navigate in Worksheets and Workbooks
  • 1. Search for data within a workbook
  • 2. Navigate to a named cell, range, or workbook element
  • 3. Insert and remove hyperlinks
- Customize Options and Views for Worksheets and Workbooks
  • 1. Change magnification by using zoom tools
  • 2. Change window views
  • 3. Hide or unhide worksheets
  • 4. Change workbook views
  • 5. Modify document properties
  • 6. Display formulas
  • 7. Hide or unhide columns and rows
  • 8. Customize the Quick Access Toolbar

77-727 Exam Details and Product Questions

No prerequisite exams required.

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 ExamPrepAway: 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:

  • Perform Operations with Formulas and Functions ()
  • Create Tables ()
  • Manage Data Cells and Ranges ()

The Microsoft Core Data Analysis, Manipulation, and Presentation practice questions at ExamPrepAway 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.

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.

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

Reveal Solution  Discussion  0

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

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

Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.

Check the spreadsheet for accessibility problems. Correct the error by adding "Tree Nursery Inventory" as an
alternative text file. You do not need to fix the warning.

Reveal Solution  Discussion  0

Correct Answer:

See explanation below.
Explanation
1. To check the accessibility select theReviewtab from the ribbon.
2. SelectCheck Accessibility.
3. Review the results.
4. Exit theAccessibility Checker.
5. Right-click on the worksheet then clickFormatand then clickAlt Text.
6. Type "Tree Nursery Inventory" in theDescriptionbox.
7. ClickOK.
References:
https://support.office.com/en-us/article/Use-the-Accessibility-Checker-to-find-accessibility-issues-a16f6de0-2f39

Viewing page 1 out of 9 pages.
Viewing questions 1-4 out of 35 questions.

11%

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

The valid 77-727 study materials would be the best guide for the 77-727 preparation.

Leonard

Leonard     4 star  

I passed the 77-727 exam by only studying the 77-727 exam materials for about one week, really appreciate!

Zachary

Zachary     5 star  

ExamPrepAway 77-727 real exam questions help me a lot.

Sara

Sara     4 star  

Don't sleep on it, you still have to study on this 77-727 learning guide! And i have to say i got my certification all due to its precise questions and amswers. Take it seriously and you will pass as me!

Bertha

Bertha     5 star  

Thanks for your Core Data Analysis, Manipulation, and Presentation dumps.

Anna

Anna     4 star  

I passed 77-727 test yesterday with outstanding result.

Nicole

Nicole     5 star  

Great ExamPrepAway 77-727 real exam questions.

Jenny

Jenny     5 star  

Thank you, I have cleared the certification. Dumps helped me a lot.

Griselda

Griselda     4.5 star  

You can pass the 77-727 exam only with this 77-727 preparation dump. It contains all the Q&A needed in the real exam. I got 93% marks.

Amy

Amy     4.5 star  

I passed my exam with 92% marks. Only 3 questions weren't from the 77-727 exam dumps. You were spot on ExamPrepAway.

Ella

Ella     4 star  

77-727 test materials are valid, and they helped me pass the exam in my first attempt, thank you very much!

Miranda

Miranda     4.5 star  

I prepared my test by reading ExamPrepAway dumps and passed 77-727.

Cheryl

Cheryl     5 star  

Perfect material help me pass 77-727 exam easily.

Lewis

Lewis     4 star  

LEAVE A REPLY

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

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.

Related Exams

 77-725 Prep Away  77-727 Prep Away