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

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

Exhibit:

You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.
Task4:
In cell F2 of the "No Medals" worksheet, create a formula that will show if a team participated in both seasons or only the Summer games.
Display "Both" if the team participated in both seasons that year Display
"Summer Only" if the team participated only in the Summer games.

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.
Task 4:
Exhibit:

Add cells C53 E56 on the "Workforce Statistics" worksheet to the Watch Window.