Question: Columns A and B contain the team # (found in column F) of each NBA team, for example Team #2 is Boston. Column A is
Columns A and B contain the team # (found in column F) of each NBA team, for example Team #2 is Boston. Column A is the home team and Column B is the away team for every NBA team. Column C is the home score and Column D is the away team score. Use COUNT functions toFIND NUMBER OF GAMES TEAM SCORED OVER ONE HUNDRED POINTS max 10 points A=away games, H=homegames HS = home score, AS = away score # Games team H A HS AS Team # Team # of Games Played scored > 100 points 5 2 89 108 1 Atl 82 #VALUE! 18 11 103 97 2 Bos 98 20 27 114 85 3 Charlotte 91 19 29 93 91 4 Chicago 82 17 21 83 74 5 Cleveland 82 6 8 94 87 6 Dallas 90 10 1 89 84 7 Denver 82 25 12 109 98 8 Detroit 92 28 16 112 119 9 Golden 82 22 7 96 99 10 Houston 82 24 26 101 95 11 Indiana 87 13 23 98 87 12 LAC 82 3 5 100 94 13 LAL 101 2 18 92 95 14 Memphis 82 15 27 97 92 15 Miami 82 4 11 73 98 16 Milwaukee 82 23 9 92 87 17 Minnesota 85 1 29 88 98 18 NJN 102 21 6 92 99 19 NYK 82 14 8 80 90 20 Orlando 86 10 12 98 92 21 Philadelphia 87 28 13 101 105 22 Phoenix 82 7 16 101 102 23 Portland 85 26 25 114 108 24 Sacramento 98 9 22 101 107 25 SAN 92 11 20 117 107 26 Seattle 87 27 6 109 92 27 Toronto 87 3 19 97 93 28 Utah 86 15 5 83 90 29 Washington 82 2 4 96 82 8 18 102 88 17 14 111 102 13 22 117 94 29 21 90 76 1 15 90 83 5 20 69 99 18 3 95 85 4 19 84 79 10 17 88 90 16 2 105 99 7 24 94 106 26 28 74 91 23 25 90 106 12 9 108 110 27 11 113 100 8 29 100 78 14 6 85 94
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
