USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
below which does not include the SUM function is
|
|
to sum
|
|
|
to reduce
|
|
|
for division and multiplication
|
|
|
to find the average
|
Explanation:
Detailed explanation-1: -The correct answer to the question “Which one is not a function in MS Excel” is option (b). AVG. There is no function in Excel like AVG, at the time of writing, but if you mean Average, then the syntax for it is also AVERAGE and not AVG. The other two options are correct.
Detailed explanation-2: -The correct answer is SUBTRACT(). SUBTRACT() is not a valid function in MS Excel.
Detailed explanation-3: -For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.
Detailed explanation-4: -Answer: The Excel AVERAGEIF function calculates the average of numbers in a range that meet supplied criteria.
There is 1 question to complete.