DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The function used to calculate the average in a range is____
|
|
=SUM()
|
|
|
=MAX()
|
|
|
=COUNT()
|
|
|
=AVERAGE()
|
Explanation:
Detailed explanation-1: -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.
Detailed explanation-2: -The AVERAGE Function[1] is categorized under Excel Statistical functions. It will return the average value of a given series of numbers in Excel. The function is used to calculate the arithmetic mean of a given set of arguments in Excel.
Detailed explanation-3: -The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.
There is 1 question to complete.