Formula: =AVERAGE(range)

Description: The AVERAGE function calculates the average of the values in a range of cells.

Example:

=AVERAGE(A1:A10)

This formula will calculate the average of the values in cells A1 to A10, and return the result.

Usage:

To use the AVERAGE function, simply enter the range of cells that you want to average into the parentheses of the formula. For example, if you want to average the values in cells A1 to A10, you would enter the following formula:

=AVERAGE(A1:A10)

You can also use the AVERAGE function to average the values in multiple ranges of cells. To do this, simply separate the ranges with commas. For example, to average the values in cells A1 to A10 and B1 to B10, you would enter the following formula:

=AVERAGE(A1:A10, B1:B10)

The AVERAGE function is a very useful function for calculating averages in Excel. It can be used in a variety of ways, such as calculating class averages, employee salaries, and product prices.

Here is an example of how to use the AVERAGE function to calculate the average class grade for a group of students:

=AVERAGE(C2:C10)

This formula will calculate the average of the values in cells C2 to C10, which contain the grades for each student in the class. The result of the formula will be the average class grade.

I hope this tutorial is helpful!