Online Access Free 77-728 Practice Test

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

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:

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 a news reporter. You have a been given the assignment to give a history of the Olympic Games.
Task5:
In column F of the "Hosts" worksheet, create a formula that uses date and time functions to show how many years ago the games were hosted in eachcity.