| Exam Code/Number: | 77-727Join the discussion |
| Exam Name: | Core Data Analysis, Manipulation, and Presentation |
| Certification: | Microsoft |
| Question Number: | 35 |
| Publish Date: | Jun 02, 2026 |
|
Rating
100%
|
|
Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.
Change themarginsto 1.0'' (2.54 cm) on the top and bottom, 0.75'' (1.90 cm) on the left and right, with a 0.5''
(1.27 cm) header and footer.
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.
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 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.
Check the spreadsheet for accessibility problems. Correct the error by adding "Tree Nursery Inventory" as an
alternative text file. You do not need to fix the warning.
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.
Unhide the "Summary" worksheet.
