Master the Microsoft 77-728 Exam: Essential Study Tips and Strategies

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.

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.

Task3:

Exhibit:

In Cell B19 on the “Merchandise-Sales” worksheet, calculate the total number of T-shirts that were sold for less than $18 at all concerts at which more than 1500 t-shirts were sold.

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)

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.

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 a news reporter. You have a been given the assignment to give a history of the Olympic Games.

Task3:

Create new customized colors with the Accent 1 option to RGB “255”, “153”, “51”. Name the customized colors “Orange Table”

Exhibit:

Task5:

On the “Quality Control” worksheet change the table name from “Table3” to WeeklyQuality”.