Database =DAVERAGE(database, field, criteria)

Quiz =DAVERAGE — 15 Questions

15 quiz questions about =DAVERAGE — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← DAVERAGE ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is =DAVERAGE volatile?

Question 2 of 15 2/15

What is the type of argument “field” in =DAVERAGE?

Question 3 of 15 3/15

How many optional arguments does =DAVERAGE have?

Question 4 of 15 4/15

How many arguments does =DAVERAGE have in total?

Question 5 of 15 5/15

In =DAVERAGE, which is argument #2?

Question 6 of 15 6/15

Which formula is a valid example of =DAVERAGE?

Question 7 of 15 7/15

Is argument “field” required in =DAVERAGE?

Question 8 of 15 8/15

Is argument “database” required in =DAVERAGE?

Question 9 of 15 9/15

Since which Excel version is =DAVERAGE available?

Question 10 of 15 10/15

Which function is related to =DAVERAGE?

Question 11 of 15 11/15

Does =DAVERAGE return a dynamic array?

Question 12 of 15 12/15

Which category does =DAVERAGE belong to?

Question 13 of 15 13/15

Which statement about =DAVERAGE is correct?

Question 14 of 15 14/15

In =DAVERAGE, which is argument #1?

Question 15 of 15 15/15

Which function is NOT related to =DAVERAGE?

Click a question to see the answer.

1. Is =DAVERAGE volatile?

A. No
B. No ✓
C. Yes
D. —

Explanation: DAVERAGE is not volatile.

2. What is the type of argument “field” in =DAVERAGE?

A. Reference
B. Number
C. Logical
D. Any type ✓

Explanation: Type of “field” is “Any type”.

3. How many optional arguments does =DAVERAGE have?

A. 2
B. 3 ✓
C. 5
D. 4

Explanation: =DAVERAGE has 0 required, 3 optional (3 total).

4. How many arguments does =DAVERAGE have in total?

A. 4
B. 3 ✓
C. 5
D. 2

Explanation: =DAVERAGE has 0 required, 3 optional (3 total).

5. In =DAVERAGE, which is argument #2?

A. criteria
B. field ✓
C. database
D. range

Explanation: Argument #2 is “field”.

6. Which formula is a valid example of =DAVERAGE?

A. =DAVERAGE(A4:E10, "Yield", A1:B2) ✓
B. =DAVERAGE(A4:E10, "Yield", A1:B2, 0)
C. DAVERAGE(A4:E10, "Yield", A1:B2)
D. =AVERAGE(A4:E10, "Yield", A1:B2)

Explanation: Correct example: =DAVERAGE(A4:E10, "Yield", A1:B2)

7. Is argument “field” required in =DAVERAGE?

A. No ✓
B. —
C. Yes
D. No

Explanation: “field” is optional.

8. Is argument “database” required in =DAVERAGE?

A. —
B. No ✓
C. No
D. Yes

Explanation: “database” is optional.

9. Since which Excel version is =DAVERAGE available?

A. Excel 365
B. Excel 2019
C. All versions ✓
D. Excel 2007 (Compatibility)

Explanation: Version: “All versions”.

10. Which function is related to =DAVERAGE?

A. ISO.CEILING
B. T.DIST.2T
C. HYPGEOMDIST
D. AVERAGE ✓

Explanation: “AVERAGE” is related to DAVERAGE.

11. Does =DAVERAGE return a dynamic array?

A. No ✓
B. —
C. Yes
D. No

Explanation: DAVERAGE does not spill.

12. Which category does =DAVERAGE belong to?

A. Math & Trig
B. Database ✓
C. Cube
D. Statistical

Explanation: Category is “Database”.

13. Which statement about =DAVERAGE is correct?

A. Volatile and recalculates every time
B. Make sure the criteria range does not overlap the list.
C. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label for specifying the condition. For example, if the range G1:G2 contains the column label Income in G1 and the amount 10,000 in G2, you could define the range as MatchIncome and use that name as the criteria argument in the database functions. ✓
D. Requires add-in

Explanation: Correct: You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label for specifying the condition. For example, if the range G1:G2 contains the column label Income in G1 and the amount 10,000 in G2, you could define the range as MatchIncome and use that name as the criteria argument in the database functions.

14. In =DAVERAGE, which is argument #1?

A. criteria
B. field
C. value
D. database ✓

Explanation: Argument #1 is “database”.

15. Which function is NOT related to =DAVERAGE?

A. AVERAGE
B. RATE ✓
C. DMAX
D. DGET

Explanation: “RATE” is not related to DAVERAGE.