Database =DAVERAGE(database, field, criteria)

Quiz =DAVERAGE — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

How many arguments does =DAVERAGE have in total?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Is argument “database” required in =DAVERAGE?

Question 5 of 10 5/10

Which statement about =DAVERAGE is correct?

Question 6 of 10 6/10

Which formula is a valid example of =DAVERAGE?

Question 7 of 10 7/10

In =DAVERAGE, which is argument #2?

Question 8 of 10 8/10

Is argument “field” required in =DAVERAGE?

Question 9 of 10 9/10

How many optional arguments does =DAVERAGE have?

Question 10 of 10 10/10

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

Click a question to see the answer.

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

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

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

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

A. Array
B. Date
C. Any type ✓
D. Value

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

3. What is the type of argument “criteria” in =DAVERAGE?

A. Any type
B. Reference
C. Range ✓
D. Mixed

Explanation: Type of “criteria” is “Range”.

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

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

Explanation: “database” is optional.

5. Which statement about =DAVERAGE is correct?

A. Requires add-in
B. Select entire column for best performance
C. Only works in old versions
D. 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. ✓

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.

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

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

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

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

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

Explanation: Argument #2 is “field”.

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

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

Explanation: “field” is optional.

9. How many optional arguments does =DAVERAGE have?

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

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

10. What is the type of argument “database” in =DAVERAGE?

A. Text
B. Array
C. Number
D. Range ✓

Explanation: Type of “database” is “Range”.