Excel 2016: Core Data Analysis, Manipulation, and Presentation

Here you have the best Microsoft 77-727 practice exam questions

You have 4 total questions across 1 pages (5 per page)
These questions were last updated on February 15, 2026
This site is not affiliated with or endorsed by Microsoft.

Question 1 of 4

SIMULATION -

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.
Exam 77-727: Question 1 - Image 1

On the "Customers" worksheet, format the table so that every other row is shaded. Use a technique that automatically updates the formatting if you insert a new row.

Question 2 of 4

On the "Customers" worksheet, sort the 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.

Question 3 of 4

On the "Customers" worksheet, enter a formula in cell N2 that uses an Excel function to return the average age of the customers based on the values in the
"CurrentAge" column.

Question 4 of 4

About the Microsoft 77-727 Certification Exam

About the Exam

The Microsoft 77-727 (Excel 2016: Core Data Analysis, Manipulation, and Presentation) validates your knowledge and skills. Passing demonstrates proficiency and can boost your career prospects in the field.

How to Prepare

Work through all 4 practice questions across 1 pages. Focus on understanding the reasoning behind each answer rather than memorizing responses to be ready for any variation on the real exam.

Why Practice Exams?

Practice exams help you familiarize yourself with the question format, manage your time, and reduce anxiety on the test day. Our 77-727 questions are regularly updated to reflect the latest exam objectives.