Group the city worksheets. Fil the formatting of cells A1, A2, and A5 C5 from the OKC worksheet to the other city worksheets Enter dates 6/1 to 6/30 in this date format (no year) in the Date column. Apply Green, Accen 6. Lighter 60% fill to the dates. Enter a function in cell B39 to calculate the highest temperature of the month. Enter a functie 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 ti highest temperature. The dataset may contain several identical highest temperatures, but th 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 ti lowest temperature Ungroup the worksheets Use a Web browser to go to www.wunderground.com, a weather Web site. At the top of ti page. Click More, click Historical Weather and submit a search for OKC, Oklahoma. Copy thi URL and create a hyperlink to this Web page for cell A3 in the OKC worksheet Add a Screen Tip 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 Lawtor Fort Sill) worksheets as well (in cell A3) Set the Screen Tips as Click to see weather histo for Tulsa (no period) and Click to see weather history for Lawton (no period) Continue te use www.wunderground.com for the weather links. Check each hyperlink to ensure it work correctly In cell B6 in the Summary sheet enter a 3-D formula to calculate the highest temperature fro 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 fror the three cities for 6/1 Copy the formula down the Low column Group the city worksheets. Fil the formatting of cells A1, A2, and A5 C5 from the OKC worksheet to the other city worksheets Enter dates 6/1 to 6/30 in this date format (no year) in the Date column. Apply Green, Accen 6. Lighter 60% fill to the dates. Enter a function in cell B39 to calculate the highest temperature of the month. Enter a functie 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 ti highest temperature. The dataset may contain several identical highest temperatures, but th 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 ti lowest temperature Ungroup the worksheets Use a Web browser to go to www.wunderground.com, a weather Web site. At the top of ti page. Click More, click Historical Weather and submit a search for OKC, Oklahoma. Copy thi URL and create a hyperlink to this Web page for cell A3 in the OKC worksheet Add a Screen Tip 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 Lawtor Fort Sill) worksheets as well (in cell A3) Set the Screen Tips as Click to see weather histo for Tulsa (no period) and Click to see weather history for Lawton (no period) Continue te use www.wunderground.com for the weather links. Check each hyperlink to ensure it work correctly In cell B6 in the Summary sheet enter a 3-D formula to calculate the highest temperature fro 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 fror the three cities for 6/1 Copy the formula down the Low column
