In the process of making tables, we may use Excel to perform various calculations on the data such as sum, difference, product, quotient, and average to complete our calculation. Calculating the average of all kinds of data is…