Online Access Free 77-728 Practice Test

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 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 an accountant for an event stadium. You have created a workbook to keep track of the four vendors that are available at the stadium.
Task3:
On the "Profits PivtChart" sheet change the settings for the PivotTable to refresh the data of the PivotTable whenever the file is opened.

Correct Answer:

See the explanation below.
Explanation
Right click on Pivottable and select Pivottable options
On the data tab click on "Refresh data when opening the file"

Exhibit:

Task3:
On the "Available Must" worksheet, use a query to load the cells beginning at A1 from the HarvestLog.xlsx workbook in the documents folder. Include only the "Variety","Location" and "Litters of must" Columns.

Correct Answer:

See the explanation below.
Explanation
Put the curser on cell A1 of the "Available Must" worksheet and then go to Data tab- New Query - from File - from Workbook Select the desired file and edit it in Query Editor. Remove the columns and only include onlyVariety, Location and Litters of must columns

Put the curser on cell A1 of the "Available Must" worksheet and then go to Data tab- New Query - from File - from Workbook Select the desired file and edit it in Query Editor. Remove the columns and only include onlyVariety, Location and Litters of must columns