Question

What is the function to find the average value for the cell range A1 to A5?​

Answer 1

Answer:

Description. Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

Explanation:

please mark as brainlist

Answer 2

Answer:

Microsoft Excel AVERAGEIF function The Microsoft Excel AVERAGEIF function returns the average (arithmetic mean) of all numbers in a range of cells, based on a given criteria. The AVERAGEIF function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel.