Question

The function _________is used for calculating average in Excel
​

Answer 1

Explanation:

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.

Answer 2

Answer:

Excel AVERAGE

Explanation:

• The Excel AVERAGE function calculates the average (arithmetic mean) of supplied numbers. AVERAGE can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants.
• The AVERAGE function calculates the average of numbers provided as arguments. To calculate the average, Excel sums all numeric values and divides by the count of numeric values.
• The AVERAGE function will ignore logical values and numbers entered as text