Online Access Free 77-728 Practice Test

Exhibit:

Task6:
On the "Quality Control" worksheet add a linear trendline to the chart that forecast the quality of batch C1005 through week 12.

Correct Answer:

See the explanation below.
Explanation
Select the chart and then go to chart elements - trendline - linear

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.
Task2:
Prevent users from adding, deleting or modifying worksheets unless they enter the password "12345".

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.