| Exam Code/Number: | 77-728Join the discussion |
| Exam Name: | Excel 2016 Expert: Interpreting Data for Insights |
| Certification: | Microsoft |
| Question Number: | 26 |
| Publish Date: | May 28, 2026 |
|
Rating
100%
|
|
Exhibit:
You have spent the past year starting up an amusement park. You have decided to create a year end financial report for your stakeholders.
Task 1:
Using the Fill Series option in Excel fill in the months April through October in cells C1 I1 Do not change the cell formatting.
Exhibit:
You have spent the past year starting up an amusement park. You have decided to create a year end financial report for your stakeholders.
Task4:
On the "Chart" sheet save the PivotChart as a template named "ParkChart" in the charts folder.
Exhibit:
You have spent the past year starting up an amusement park. You have decided to create a year end financial report for your stakeholders.
Task 5:
Show the Developer tab on the ribbon.
You have been a manager of a band for the past year. You are reviewing the data you have about the merchandise that was sold at all of the concerts.
Task2:
Exhibit:
On the "Merchandise-Costs" worksheet, change the dates in column A to Spanish (Mexico) using the format 14 de marzo de 2012. Change the currency C, E, G and H to $ Spanish (Mexico)
