Microsoft 77-728 Actual Free Exam Questions & Community Discussion
Exhibit:
You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.
Task 1:
In cell B2 of the "No Medals" worksheet add a formula that uses a single function to look up the country code in the "IOC Teams" worksheet for the country listed in a cell A2 of the "No Medals" worksheet.
You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.
Task 1:
In cell B2 of the "No Medals" worksheet add a formula that uses a single function to look up the country code in the "IOC Teams" worksheet for the country listed in a cell A2 of the "No Medals" worksheet.
Correct Answer:
See the explanation below.
Explanation
Use VLOOKUP and give the parameters as mentioned in the question
Explanation
Use VLOOKUP and give the parameters as mentioned in the question
Exhibit:
Task6:
On the "Quality Control" worksheet add a linear trendline to the chart that forecast the quality of batch C1005 through week 12.
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
Explanation
Select the chart and then go to chart elements - trendline - linear
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 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
Explanation
Go to file - options - customize ribbon and check the "Developer" tab
0
0
0
10