Online Access Free 77-727 Exam Questions
| Exam Code: | 77-727 |
| Exam Name: | Core Data Analysis, Manipulation, and Presentation |
| Certification Provider: | Microsoft |
| Free Question Number: | 35 |
| Posted: | Oct 30, 2026 |
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.
Modify the cell formatting of cell J9 to display the text on two lines.
Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.
Configure the worksheet so that row 9 and the WordArt remain visible as you scroll vertically.
Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.
Hiderows 29 and 30.
Project 6 of 7: Bike Tours
Overview
You are the owner of a small bicycle tour company summarizing trail rides that have been booked for the next
six months.
In cell M9 on the "Summer Bookings" worksheet, insert a function that calculates the number of groups
containing 12 or more people even if the order of the rows is changed.