Free Microsoft 77-727 Exam Dumps Questions & Answers
| Exam Code/Number: | 77-727Join the discussion |
| Exam Name: | Core Data Analysis, Manipulation, and Presentation |
| Certification: | Microsoft |
| Free Question Number: | 35 |
| Publish Date: | Sep 20, 2026 |
| # of views: | 4075 |
|
|
|
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 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.
On the "Summer Bookings" worksheet, remove the table functionality from the table. Retain the cell
formatting and location of the data.
Project 7 of 7: Farmers Market
Overview
You are the Director of a local farmers' market. You are creating and modifying charts for a report which
shows the amounts and variety of products sold during the season.
On the "Spring Sales" worksheet, add the title "New Products" to the column chart. Label the vertical axis
"Gross Sales" and the horizontal axis "Months".
Project 7 of 7: Farmers Market
Overview
You are the Director of a local farmers' market. You are creating and modifying charts for a report which
shows the amounts and variety of products sold during the season.
On the "Summer Sales" worksheet, use the data in the "Products" and "Total" columns only to create a 3-D
Pie chart. Position the new chart to the right of the column charts.
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.