How to Find Average, Maximum, Minimum Values in Excel Tables

It’s a well known fact that teachers tend to use Microsoft Excel a lot, especially when it comes to keeping grades and test scores. Keeping track of student grades is incredibly easy with Excel, and it’s also great for archiving old grades and scores for future reference.

If you are a teacher that uses Excel as a grading sheet, you might want to find out what your students averages grades and test scores are, as well as what the class maximum and minimum grades are. Here is how you can do it easily using basic Excel formulas.

If you want to find the average grade in your class, use the following formula. In the empty cell below the test scores enter =AVERAGE(B2:B17). The cells within the parenthesis are the start and end cells of your score sheet.

maximum excel table

Hit enter and you will see the average score for your class below.

minimum excel table

Obviously, with a list this short, you will be able to pick out the highest score by eye, but in the case of a larger list of test scores, you can use the Maximum formula to find the highest score very easily.

In the empty cell below the test scores enter =MAX(B2:B17). The cells within the parenthesis are the start and end cells of your score sheet.

average number of scores

Hit enter and you will see the highest score for your class below.

highest value of number in excel table

To find the lowest score use MIN instead of MAX in the formula.

excel list number

Hit enter and you will see the lowest score for your class below.

lowest number in excel table