The average function enables users to retrieve the mean value from a specified cell range. It is a powerful yet simple tool within Google Sheets. It is helpful in minimizing numerous data pieces into a single term that is understandable by everyone using a single number to represent it.  Visit : https://www.efinancialmodels.com/calculating-averages-in-google-sheets/