77-728 Exam Dumps : Excel 2016 Expert: Interpreting Data for Insights

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.

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:

Task6:

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