Enter a function in cell B39 to calculate the highest temperature of the month. Enter a function in cell C39 to calculate the lowest temperature of the month.

Use a nested MATCH function within the INDEX function in cell B40 to identify the date for the highest temperature. The dataset may contain several identical highest temperatures, but the nested function will identify the first date containing the match.

Use a nested MATCH function within the INDEX function in cell C40 to identify the date for the lowest temperature. Ungroup the worksheets.

Use a Web browser to go to www.wunderground.com, a weather Web site. At the top of the page, click More, click Historical Weather and submit a search for OKC, Oklahoma. Copy the URL and create a hyperlink to this Web page for cell A3 in the OKC worksheet. Add a ScreenTip stating Click to see weather history for Oklahoma City (no period).

Create hyperlinks for the Tulsa (hyperlink text is Tulsa) and Lawton (hyperlink text is Lawton-Fort Sill) worksheets as well (in cell A3). Set the ScreenTips as Click to see weather history for Tulsa (no period) and Click to see weather history for Lawton (no period). Continue to use www.wunderground.com for the weather links. Check each hyperlink to ensure it works correctly.

In cell B6 in the Summary sheet, enter a 3-D formula to calculate the highest temperature from the three cities for 6/1. Copy the formula down the High column.

In cell D6 in the Summary sheet, enter a 3-D formula to calculate the lowest temperature from the three cities for 6/1. Copy the formUse a nested MATCH function within the INDEX function in cell B40 to identify the date for the highest temperature. The dataset may contain several identical highest temperatures, but the nested function will identify the first date containing the match.

Use a nested MATCH function within the INDEX function in cell C40 to identify the date for the lowest temperature. Ungroup the worksheets.

In cell B6 in the Summary sheet, enter a 3-D formula to calculate the highest temperature from the three cities for 6/1. Copy the formula down the High column.

ula down the Low column.

In cell C6 in the Summary sheet, enter a nested IF function to determine which city had the highest temperature. Based on the result returned in B6, enter the city name as OKC or Tulsa or Lawton in C6. Remember to enclose city names in double quotation marks in the function. Use Help if needed to help you understand a nested IF statement. Copy the formula down the High-City column.

In cell E6 in the Summary sheet, enter a nested IF function to determine which city had the lowest temperature. Based on the result returned in D6, enter the city name as OKC or Tulsa or Lawton in E6. Copy the Enter nested INDEX and MATCH functions to identify the dates and cities for the respective highest and lowest temperatures. function down the Low-City column.

In the Summary sheet, enter functions in the shaded Monthly Records section (below the daily data) to identify the highest (in column B) and lowest temperature (in column D).

Enter nested INDEX and MATCH functions to identify the dates and cities for the respective highest and lowest temperatures.

Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of each worksheet. Select the option to center the worksheet data horizontally on each sheet.

Ensure that the worksheets are correctly named and placed in the following order in the workbook: OKC, Tulsa, Lawton, and Summary. Save and close the workbook, and submit the file as directed.

Total Points