77-728 무료 덤프문제 온라인 액세스

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.

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)

정답:

See the explanation below.
Explanation
* Select column A - press Ctrl+1 and go to date in Number tab Select the desired format as given below and apply

* Selectcolumns C, E, G and H, press Ctrl+1 and go to currency in Number tab. Select the desired format as given below and apply

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.

정답:

See the explanation below.
Explanation
Go to file - options - customize ribbon and check the "Developer" tab

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.

정답:

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