Computer Applications
Answer
This function takes all the values of the specified cells and returns the average of the cell values in the active cell.
Its syntax is:
=AVERAGE(number1, number2, …….) where argument type is Number and return type is Number.
To find the average of the cell values ranging from A1, A2, A3, …….. to An, the function will be written as:
=AVERAGE(A1, A2, A3, ……., An)
OR
=AVERAGE(A1:An)