Free Microsoft 77-728 Exam Dumps Questions & Answers

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 5:
Exhibit:

In cell H7 on the "Event 1 -Stand Sales" worksheet, add a formula that uses a single logical function to display TRUE if everyone sold at least on hot dog and FALSE if even one person did not sell any hot dogs.

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

Correct Answer:

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

Exhibit:

Task 1:
On the "Batches in progress" worksheet format columns C and D to display numeric values to three decimal places.
The format should be applied to existing and new row.

Correct Answer:

See the explanation below.
Explanation
Select the entire column C and D and from Home tab click on increase decimals which will turn the decimal to three points