FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

BASICS OF BIG DATA

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
This function will return the arithmetic mean of a given range of numbers.
A
FV
B
Average
C
IF
D
Min
Explanation: 

Detailed explanation-1: -Answer. The Microsoft Excel AVERAGEIF function returns the average (arithmetic mean) of all numbers in a range of cells, based on a given criteria.

Detailed explanation-2: -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-3: -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-4: -The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.

Detailed explanation-5: -The AVERAGE function in Excel is used to find the arithmetic mean of specified numbers. The syntax is as follows: AVERAGE(number1, [number2], …)

There is 1 question to complete.
Previous
Next