Online Access Free 77-727 Practice Test
| Exam Code: | 77-727 |
| Exam Name: | Core Data Analysis, Manipulation, and Presentation |
| Certification Provider: | Microsoft |
| Free Question Number: | 35 |
| Posted: | May 30, 2026 |
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.
On the "Orders" worksheet, enter a formula in cell J2 that uses an Excel function to return the "OrderTotal"
value of the individual order that has the highest "OrderTotal" value.
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.
Add the Alternative Text Title "Adult Enrollment" to the "Adult_Program" table.
Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.
Hiderows 29 and 30.
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.
On the "Customers by Order" worksheet, use an Excel data tool to remove all records with duplicate
"CustomerID" values from the table. Do not remove any other records.
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 "Youth Program" worksheet, create a table from the cell range A9:G19. Include row 9 as headers.