Correct Answer : Both (A) and (B)
Explanation : Both MODE.SNGL() and MODE.MULT() functions are used to find the most common value(s).=MODE.SNGL(value1, [value2, ...])=MODE.MULT(value1, [value2, ...])
MODE.SNGL()
MODE.MULT()
=MODE.SNGL(value1, [value2, ...])
=MODE.MULT(value1, [value2, ...])
Correct Answer : AVERAGEIFS
Explanation : The AVERAGEIF() function is used to calculate the average (arithmetic mean) of a range based on one or more true or false conditions.Syntax :=AVERAGEIFS(average_range, criteria_range1, criterion1, ...)
AVERAGEIF()
=AVERAGEIFS(average_range, criteria_range1, criterion1, ...)
Correct Answer : AVERAGEIF
Explanation : The AVERAGEIF() function is used to calculate the average (arithmetic mean) of a range based on a true or false condition.Syntax :=AVERAGEIF(criteria_range, criterion, [average_range])
Correct Answer : AVERAGE
Explanation : The AVERAGE() function is used to calculate the average (arithmetic mean).Syntax :=AVERAGE(value1, [value2, ...])
AVERAGE()
=AVERAGE(value1, [value2, ...])