Database =DPRODUCT(database, field, criteria)

Quiz =DPRODUCT — 15 Questions

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

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

← DPRODUCT ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which category does =DPRODUCT belong to?

Question 2 of 15 2/15

Which statement about =DPRODUCT is correct?

Question 3 of 15 3/15

Is =DPRODUCT volatile?

Question 4 of 15 4/15

Which is the correct syntax of =DPRODUCT?

Question 5 of 15 5/15

How many optional arguments does =DPRODUCT have?

Question 6 of 15 6/15

In =DPRODUCT, which is argument #3?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

Does =DPRODUCT return a dynamic array?

Question 9 of 15 9/15

What is the output type of =DPRODUCT?

Question 10 of 15 10/15

In =DPRODUCT, which is argument #1?

Question 11 of 15 11/15

Since which Excel version is =DPRODUCT available?

Question 12 of 15 12/15

Is argument “field” required in =DPRODUCT?

Question 13 of 15 13/15

Is argument “criteria” required in =DPRODUCT?

Question 14 of 15 14/15

Which function is NOT related to =DPRODUCT?

Question 15 of 15 15/15

Which function is related to =DPRODUCT?

Click a question to see the answer.

1. Which category does =DPRODUCT belong to?

A. Statistical
B. Database ✓
C. Information
D. Lookup & Reference

Explanation: Category is “Database”.

2. Which statement about =DPRODUCT is correct?

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

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.

3. Is =DPRODUCT volatile?

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

Explanation: DPRODUCT is not volatile.

4. Which is the correct syntax of =DPRODUCT?

A. =DGET(database, field, criteria)
B. DPRODUCT(database, field, criteria)
C. =DPRODUCT(database, field, criteria) ✓
D. =DPRODUCT(database, field, criteria, 0)

Explanation: Correct syntax: =DPRODUCT(database, field, criteria)

5. How many optional arguments does =DPRODUCT have?

A. 2
B. 1
C. 3
D. 0 ✓

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

6. In =DPRODUCT, which is argument #3?

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

Explanation: Argument #3 is “criteria”.

7. What is the type of argument “field” in =DPRODUCT?

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

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

8. Does =DPRODUCT return a dynamic array?

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

Explanation: DPRODUCT does not spill.

9. What is the output type of =DPRODUCT?

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

Explanation: Output is “Number”.

10. In =DPRODUCT, which is argument #1?

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

Explanation: Argument #1 is “database”.

11. Since which Excel version is =DPRODUCT available?

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

Explanation: Version: “All versions”.

12. Is argument “field” required in =DPRODUCT?

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

Explanation: “field” is required.

13. Is argument “criteria” required in =DPRODUCT?

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

Explanation: “criteria” is required.

14. Which function is NOT related to =DPRODUCT?

A. DGET
B. PRODUCT
C. DSUM
D. FORECAST.LINEAR ✓

Explanation: “FORECAST.LINEAR” is not related to DPRODUCT.

15. Which function is related to =DPRODUCT?

A. ROWS
B. CSCH
C. BESSELI
D. DGET ✓

Explanation: “DGET” is related to DPRODUCT.