Clipboard UPDATES AVAILABLE Updates for Office are ready to be installed, but first w MOST RECENT MONTH AVERAGE TEMP in MOST RECENT MONTH 2 City of interest State AVERAGE MINIMUM MAXIMUM AVERAGE Average Temperature ("Farenheit) ANNUAL TEMP AVERAGE TEMP AVERAGE TEMP ANNUAL TEMP for City for City for State Jonathan Weiss Write a formula that converts the month name in 10 to the Excel numeric that corresponds to the MINIMUM MAXIMUM Averar 30th day of that month in the year AVERAGE TEMP AVERAGE TEMP JAN Nationwide Nationwide When you copy the formula from C2-F2 it should give you the numeric value of the oth day of each of the months in C10-F10 HINT: Use DATEVALUE on ng the form ANO 2020 that you construct using CONCATENATE 10. City 11 Albany 12 Albuquerque 13 Anchorage 14 Asheville 15 Atlanta 16 Atlantic City 17 Austin 18 Baltimore 19. Baton Roug 20 Bullines 21 Birmingham 2 Bismarck 23 Boise 25 Baldespa 26 Buffalo 27 Burlington 28 Caribou 29 Casper 30 Charleston 31 Charleston 12 Charlotte 33 Cheyenne 14 Chicago Ce commented