77-728 試験問題を無料オンラインアクセス

Exhibit:

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.
Task3:
On the "Profits PivtChart" sheet change the settings for the PivotTable to refresh the data of the PivotTable whenever the file is opened.

正解：

See the explanation below.
Explanation
Right click on Pivottable and select Pivottable options
On the data tab click on "Refresh data when opening the file"

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.
Task3:


On the "Chart" sheet add a slicer for the "Expense/Income" Column

Exhibit:

Task 2:
On the "Quality Control" worksheet fill the cells A3:A7 with the Red pattern color in a 50% Gray pattern styleif the average quality rating for all weeks that have been tested is less than 5.

Exhibit:

You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.
Task 1:
In cell B2 of the "No Medals" worksheet add a formula that uses a single function to look up the country code in the "IOC Teams" worksheet for the country listed in a cell A2 of the "No Medals" worksheet.