| Exam Code/Number: | 77-727Join the discussion |
| Exam Name: | Core Data Analysis, Manipulation, and Presentation |
| Certification: | Microsoft |
| Question Number: | 35 |
| Publish Date: | Oct 12, 2026 |
|
Rating
100%
|
|
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.
Simultaneously replace all instances of the text "Pickup" with the text "Truck".
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 "Adult Program" worksheet, insert aColumnsparkline for each sport that shows the enrollment for the
past five years.
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 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.
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 C8 on the "Summer Bookings" worksheet, insert a function that joins the customer "Lastname" to the
customer "Firstname" separated by a comma and space. (Example: Campbell, David).
