Excel 2016: Core Data Analysis, Manipulation, and Presentation

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

You have 4 total questions to study from
Each page has 5 questions, making a total of 1 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on December 13, 2025
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.

Correct Answer:

Question 2 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 2 - Image 1

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.

Correct Answer:

Question 3 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 3 - Image 1

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.

Correct Answer:

Question 4 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 4 - Image 1

Correct Answer: