Online Access Free 77-728 Exam Questions

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.
Task2:
Remove all of the conditional formatting from the "Year 1" sheet.

Correct Answer:

See the explanation below.
Explanation
On the "Year 1" sheet, go to home - conditional formatting - clear rules - clear rules from entire sheet

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.
Task5:
Exhibit:

On the"Cost Pivot Chart" worksheet add a 3D Stacked Bar Chart that shows the data in the PivotTable.

Correct Answer:

See the explanation below.
Explanation
Select the PivotTable and from the Analyze tab select the chart as mentioned below

You are an accountant for an event stadium. You have created a workbook to keep track of the four vendors that are available at the stadium.
Task2:
Create a PivotTable in Cell A2 of the "Vendor Costs" worksheet based on cells C3 K19 on the "Purchases" worksheet to show the average of the total cost for each vendor. Display each vendor on a row.

Exhibit:

You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.
Task5:
In column F of the "Hosts" worksheet, create a formula that uses date and time functions to show how many years ago the games were hosted in eachcity.