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: | Sep 04, 2025 |
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a
workbook containing lists of donors.
Add a new worksheet named "$1,000 Donors" to the workbook.
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, add the "Total" data series to the "Top Sellers" column chart. Include the
total only for "Fruits", "Vegetables", and "Jams & Honey".
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 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 7 of 7: Farmers Market
Overview
You are the Directorof 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, switch the rows with the columns on the first column chart.