77-728 Sample Questions Answers

Exhibit:

You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.

Task2:

Prevent users from adding, deleting or modifying worksheets unless they enter the password “12345”

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)

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.

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.