$.$ In the attached workbook, the $$E$1-4$ tab is a spreadsheet with test scores for nine

students. Develop a VBA code to:

a$.$ Read in the number of students and the number of tests and echo them back to the

spreadsheet

b$.$ Calculate and output the average score for each test $($e$.$g$.,$ test $1$ average, test $2$

average, etc.$).$

c$.$ Identify and output the maximum and minimum test score for each test $($e$.$g$.,$ test

$1$ maximum and minimum score, test $2$ maximum and minimum score, etc.$)$