DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=average()
|
|
|
=average
|
|
|
average()
|
|
|
=average();
|
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: -Average This is the arithmetic mean, and is calculated by adding a group of numbers and then dividing by the count of those numbers. For example, the average of 2, 3, 3, 5, 7, and 10 is 30 divided by 6, which is 5.
Detailed explanation-3: -key and click the cells that you want to average, and then press RETURN. For example, select A2, A4, and A7, and then press RETURN. Excel replaces the selected range reference in the AVERAGE function with cell references for the cells that you selected. In this example, the result is 8.
Detailed explanation-4: -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-5: -The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.