Computer Applications
Explain the following function:
AVERAGE ( )
Spreadsheet
45 Likes
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)
Answered By
23 Likes