DATABASE FUNDAMENTALS
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: -Detailed Solution. The correct answer is “ALT".
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.