The first argument of the AVERAGEIFS function is ________.
A)average_range
B)criteria_range
C)criteria
D)logical_test

Question

Quizplus · Accepted Answer

The first argument of the AVERAGEIFS function is the range of cells that will be averaged. This is known as the average_range. The criteria_range and criteria are used to specify the conditions under which the average will be calculated, but they are not the first argument. The logical_test is used in other functions such as the IF function, but not in the AVERAGEIFS function.

The First Argument of the AVERAGEIFS Function Is ________