Attached is a screenshot of spreadsheet used to do this problem.
You will see the excel functions used for each column. The average score is highlighted in blue.
You will see the excel functions used for each column. The average score is highlighted in blue.