Exhibit:
Task 2:
On the “Quality Control” worksheet fill the cells A3:A7 with the Red pattern color in a 50% Gray pattern styleif the average quality rating for all weeks that have been tested is less than 5.
Exhibit:
Task4:
On the “Batches in Progress” worksheet, use an Excel forecast feature to calculate the “Desired Specific Gravity” for batch 1005 to result in a “Final Percent Alcohol” level of 15%.
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.