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: | Aug 03, 2026 |
| # of views: | 3884 |
|
|
|
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.
Apply the Rose, Table Style Light 17 (Table Style Light 17) to the "Inventory" table.
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.
Arrange the worksheets so that "$5,000 Donors" is first.
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 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 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.