$12$:$21$ PM

$0\mathrm{.}0$KB$/$s

A

$1$

B

Vo

$5$G

LTE N

$49$

$2$

$3$

Data

$4$ Nick Foles $119\mathrm{.}2,203$

Quarterback Data

$5$ Peyton Manning $115\mathrm{.}1,450$

$6$ Josh McCown $109\mathrm{.}0,149$

$7$ Philip Rivers $105\mathrm{.}5,378$

$8$ Aaron Rodgers $104\mathrm{.}9,193$

$9$ Drew Brees $104\mathrm{.}7,446$

$10$ Russell Wilson $101\mathrm{.}2,257$

$11$ Tony Romo $96\mathrm{.}700,342$

$12$ Ben Roethlisberger $92\mathrm{.}00,375$

$13$ Colin Kaepernick $91\mathrm{.}600,243$

$14$ Sam Bradford $90\mathrm{.}900,159$

$15$ Matt Ryan $89\mathrm{.}60,439$

$16$ Jay Cutler $89\mathrm{.}20,224$

$17$ Alex Smith $89\mathrm{.}10,308$

$18$ Andy Dalton $88\mathrm{.}80,363$

$19$ Cam Newton $88\mathrm{.}80,292$

$20$ Tom Brady $87\mathrm{.}30,380$

$21$ Andrew Luck $87\mathrm{.}00,343$

$22$ Matthew Stafford $84\mathrm{.}20,371$

$23$ Mike Glennon $83\mathrm{.}90,247$

$24$ Carson Palmer $83\mathrm{.}90,362$

$25$ Robert Griffin $82\mathrm{.}20,274$

$26$ Ryan Fitzpatrick $82\mathrm{.}00,217$

$27$ Ryan Tannehill $81\mathrm{.}70,355$

$28$ Matt Cassel $81\mathrm{.}60,153$

$29$ Kellen Clemens $78\mathrm{.}80,142$

$30$ Case Keenum $78\mathrm{.}20,137$

$31$

$32$

$33$

Average

Rating

Completions

D$12$:$21$ PM

$0\mathrm{.}0$KB$/$s

$5$G

Vo

LTE

$49$

E

F

H

Column A contains a QB$\text{'}$s name, followed by his QB rating, followed by the number

of passes he completed during the $2013$ season. Create formulas to extract his

rating into column B and his number of completions into column C and find the

average of all QB$\text{'}$s ratings and completions.

Highlight completions cell where QB completion is less than the average

completion.

$*$You will have to use the VALUE function to convert text into numbers before you

can average.