This is an excel worksheet for data analytics. Use COUNT functions to determine the # of games played and # of games team scored >100 points.

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 to answer the cells in yellow. max10 points A= away games, H= homegames HS= home score AS= away score \begin{tabular}{|r|r|r|r|} \hline \multicolumn{1}{|c|}{ H } & H & AS \\ \hline 5 & 2 & 89 & 108 \\ \hline 18 & 11 & 103 & 97 \\ \hline 20 & 27 & 114 & 85 \\ \hline 19 & 29 & 93 & 91 \\ \hline 17 & 21 & 83 & 74 \\ \hline 6 & 8 & 94 & 87 \\ \hline 10 & 1 & 89 & 84 \\ \hline 25 & 12 & 109 & 98 \\ \hline 28 & 16 & 112 & 119 \\ \hline 22 & 7 & 96 & 99 \\ \hline 24 & 26 & 101 & 95 \\ \hline 13 & 23 & 98 & 87 \\ \hline 3 & 5 & 100 & 94 \\ \hline 2 & 18 & 92 & 95 \\ \hline 15 & 27 & 97 & 92 \\ \hline 4 & 11 & 73 & 98 \\ \hline 23 & 9 & 92 & 87 \\ \hline 1 & 29 & 88 & 98 \\ \hline 21 & 6 & 92 & 99 \\ \hline 14 & 8 & 80 & 90 \\ \hline 10 & 12 & 98 & 92 \\ \hline 28 & 13 & 101 & 105 \\ \hline 7 & 16 & 101 & \end{tabular}