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


Related Questions