The criteria range for the DAVERAGE function must consist of at least ________ vertical cell(s).
A)one
B)three
C)four
D)two

Question

Quizplus · Accepted Answer

The DAVERAGE function requires a criteria range with at least two vertical cells. One cell is used for the column label, and the other cell(s) are used for the criteria. In other words, the criteria range must include the column label and at least one cell for a criteria value.

The Criteria Range for the DAVERAGE Function Must Consist of at Least