Excel questions

Enter a nested IF function in cell C6 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.

H 5 exploring e09 grader h3 June LastFirst Excel Draw Page Layout Formulas Data Review view Power Pivot Q Tell me what you want to do File Home Insert Store PivotTable Recommended Table Pictures Online a.. My Add-ins Recommended J PivotChart 3D Line Column PivotTables Pictures Charts Map Illustrations Tables Add-ins Charts Tours Sparklines C6 June Temperature Summary n "F Date High High City Low ow-City 64 90 84 90 90 EY13 90 614 90 6115 94 20 616 94 617 94 22 23 620 94 25 26 96 622 99 27 623 00 28 624 103 625 30 626 32 627 102 628 33 629 96 34 630 99 35 37 Monthly Records 38 39 High Low 40 Date 41 City 42 OKC Tulsa Lawton Summary Ready