Microsoft Core Data Analysis, Manipulation, and Presentation : 77-727 Exam Questions

Exam Code: 77-727
Exam Name: Core Data Analysis, Manipulation, and Presentation
Updated: Aug 29, 2026
Q&As: 35 Questions and Answers

Microsoft 77-727 Value Pack (Frequently Bought Together)

pdf demo PDF Version + PC Test Engine + Online Test Engine

PDF Version: Convenient, easy to study. Printable Microsoft 77-727 PDF Format. It is an electronic file format regardless of the operating system platform.

PC Test Engine: Install on multiple computers for self-paced, at-your-convenience training.

Online Test Engine: Supports Windows / Mac / Android / iOS, etc., because it is the software based on WEB browser.

Value Pack Total: $149.97 $69.99

About Microsoft Core Data Analysis, Manipulation, and Presentation Exam Braindumps

Are you the most generous one of the army of the workers? Are you still distressed by the low salary and the tedious work? (77-727 VCE dumps: Core Data Analysis, Manipulation, and Presentation) Are you yet fretting fail in seizing the opportunity to get promotion? With the rapid development of the economy and technology, (77-727 test prep) there are much more challenges our workers must face with. What should workers do to face the challenges and seize the chance of success? Our 77-727 prep +test bundle have given the clear answer.

The 77-727 VCE dumps: Core Data Analysis, Manipulation, and Presentation of our company is the best achievement which integrated the whole wisdom and intelligence of our Microsoft researchers and staff members. That the customers are primacy is the unshakable principle which all of our company adhere to. The 77-727 test prep is the best evidence to prove the high efficiency and best quality we serve each customer.

Considered service experience

Every user of our 77-727 VCE dumps: Core Data Analysis, Manipulation, and Presentation has his or her priority in experiencing our all-round and considered services that not only come from our Core Data Analysis, Manipulation, and Presentation test prep but also come from our customer service center. As a result, we provide the free demo of the 77-727 exam prep for the new customers, as for the regular customer we will constantly offer various promotion. You can purchase our Core Data Analysis, Manipulation, and Presentation test prep with your membership discounts. Furthermore, you can put up all your questions and give the feedbacks to our online service center when you are engaged in our 77-727 VCE dumps: Core Data Analysis, Manipulation, and Presentation, our customer service staffs will help you figure out your questions and work out your problems as possible as they can.

After purchase, 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.)

The Microsoft 77-727 exam is necessary to obtain the associate-level certification known as the Microsoft Office Specialist: Microsoft Excel 2016. This test validates the candidates' skills in developing core data manipulation, analysis, and presentations with the help of Excel 2016 functions.

Skills measured

Create and manage worksheets and workbooks (30-35%)
Manage data cells and ranges (15-20%)
Create tables (15-20%)
Perform operations with formulas and functions (10-15%)
Create charts and objects (15-20%)

Reference: https://www.microsoft.com/en-us/learning/exam-77-727.aspx

Secure privacy management

Our company always holds on the basic principle that protecting each customer's privacy is the undeniable responsibility for all of our staffs. For each customer who uses our 77-727 VCE dumps: Core Data Analysis, Manipulation, and Presentation, we will follow the strict private policies and protect his or her personal information and used material data. And for every sum of money that our user pays for the 77-727 test prep, we will ensure the security of the transaction and resolutely refuse illegal ways. Whatever the case is, we will firmly protect the privacy right of each user of 77-727 exam prep.

High efficiency, high passing rate

No one wants to waste their time on anything in such a seedy and competing society, and neither of our 77-727 VCE –examcollection does. The first target of our Microsoft researchers design the products for is helping the massive workers succeed in getting the certification with the highest efficiency. Time saving is one of the significant factors that lead to the great popularity of our 77-727 VCE dumps: Core Data Analysis, Manipulation, and Presentation, which means that it only takes you 20-30 hours with exam prep until you get the certification. What's more, time witnesses that our 77-727 test prep have 100% passing rate. In the past 13 years, we constantly aid each one candidate get through the Core Data Analysis, Manipulation, and Presentation test as well as make him a huge success in the road of his career.

Microsoft 77-727 Exam Syllabus Topics:

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