The file named Qb2013.xlsx gives NFL quarterback (QB) statistics for the 2013 season. Write formulas in cells J2 and K2 that return the QB’s TDs and interceptions when you type a QB’s name in cell I2.

Transcribed Image Text:

In cell 12 I have a dropdown box which I can use to select the name of an NFL QB. Write formulas in J2 and K2 which place the QB's TD's in J2 and Interceptions in K2 10 points. Name Nick Foles Peyton Manning Josh McCown Philip Rivers Aaron Rodgers Drew Brees Russell Wilson Tony Romo Ben Roethlisberger Colin Kaepernick Sam Bradford Matt Ryan Jay Cutler Alex Smith Andy Dalton Cam Newton Tom Brady Andrew Luck Matthew Stafford Mike Glennon Carson Palmer Robert Griffin III Ryan Fitzpatrick Ryan Tannehill Matt Cassel Kellen Clemens Case Keenum Christian Ponder Team PHI DEN CHI SDG GNB NOR SEA DAL PIT SFO STL ATL CHI ΚΑΝ CIN CAR NWE IND DET TAM ARI WAS TEN ΜΙΑ MIN STL HOU MIN G 13 16 8 16 9 16 16 15 16 16 7 16 11 15 16 16 16 16 16 13 16 13 11 16 9 10 8 9 QBRat 119.2 115.1 109 105.5 104.9 104.7 101.2 96.7 92 91.6 90.9 89.6 89.2 89.1 88.8 88.8 87.3 87 84.2 83.9 83.9 82.2 82 81.7 81.6 78.8 78.2 77.9 Player Peyton Manning Comp 203 450 149 378 193 446 257 342 375 243 159 439 224 308 363 292 380 343 371 247 362 274 217 355 153 142 137 152 TD Att 11 317 659 224 544 290 650 407 535 584 416 262 651 355 508 586 473 628 570 634 416 572 456 350 588 254 242 253 239 Int Pct 12 64 68.3 66.5 69.5 66.6 68.6 63.1 63.9 64.2 58.4 60.7 67.4 63.1 60.6 61.9 61.7 60.5 60.2 58.5 59.4 63.3 60.1 62 60.4 60.2 58.7 54.2 63.6 Yds 2891 5477 1829 4478 2536 5162 3357 3828 4261 3197 1687 4515 2621 3313 4293 3379 4343 3822 4650 2608 4274 3203 2454 3913 1807 1673 1760 1648 Y/G 222.4 342.3 228.6 279.9 281.8 322.6 209.8 255.2 266.3 199.8 241 282.2 238.3 220.9 268.3 211.2 271.4 238.9 290.6 200.6 267.1 246.4 223.1 244.6 200.8 167.3 220 183.1 Y/A 9.1 8.3 8.2 8.2 8.7 7.9 8.2 7.2 7.3 7.7 6.4 6.9 7.4 6.5 7.3 7.1 6.9 6.7 7.3 6.3 7.5 7 7 6.7 7.1 6.9 7 6.9 TD 27 55 13 32 17 39 26 31 28 21 14 26 19 23 33 24 25 23 29 19 24 16 14 24 11 8 9 7 Int 2 10 1 11 6 12 9 10 14 8 4 17 12 7 20 13 11 9 19 9 22 12 12 17 9 7 6 9