Basketball Team: Player Statistics

As part of our solving real-life problems in Excel series, figure out who scored the most points overall in this interactive.

Highest-scoring game

Now that we know what function and cell range to use, we'll type our formula, =MAX(B2:F2), in cell H2 and then use the fill handle to add it to the other cells in column H.

screenshot of excel 2013

Now we can easily see how many points each of the players scored in their highest-scoring game!

illustration of character

"Say, this is just great!

It's interesting to see that Hope had the highest-scoring game, even though she didn't score the most points overall. And every player scored at least 10 points in one of their games, which is something they can all be proud of! I can't wait to show this to the team. Thanks again!"