Database =DSUM(database, field, criteria)

Quiz =DSUM — 15 Questions

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

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

← DSUM ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is argument “field” required in =DSUM?

Question 2 of 15 2/15

How many arguments does =DSUM have in total?

Question 3 of 15 3/15

Which statement about =DSUM is correct?

Question 4 of 15 4/15

Which formula is a valid example of =DSUM?

Question 5 of 15 5/15

Is argument “criteria” required in =DSUM?

Question 6 of 15 6/15

Is argument “records” required in =DSUM?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

In =DSUM, which is argument #3?

Question 9 of 15 9/15

Which function is NOT related to =DSUM?

Question 10 of 15 10/15

Is argument “fields” required in =DSUM?

Question 11 of 15 11/15

What is the type of argument “records” in =DSUM?

Question 12 of 15 12/15

Does =DSUM return a dynamic array?

Question 13 of 15 13/15

How many required arguments does =DSUM have?

Question 14 of 15 14/15

Which use case fits =DSUM?

Question 15 of 15 15/15

In =DSUM, which is argument #1?

Click a question to see the answer.

1. Is argument “field” required in =DSUM?

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

Explanation: “field” is required.

2. How many arguments does =DSUM have in total?

A. 5 ✓
B. 6
C. 7
D. 4

Explanation: =DSUM has 3 required, 2 optional (5 total).

3. Which statement about =DSUM is correct?

A. Volatile and recalculates every time
B. 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. ✓
C. Make sure that the criteria range does not overlap the list.
D. Output is always a dynamic array

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.

4. Which formula is a valid example of =DSUM?

A. =DSUM(A5:E11,"Profit",A1:A2, 0)
B. =DSUM(A5:E11,"Profit",A1:A2) ✓
C. DSUM(A5:E11,"Profit",A1:A2)
D. =DAVERAGE(A5:E11,"Profit",A1:A2)

Explanation: Correct example: =DSUM(A5:E11,"Profit",A1:A2)

5. Is argument “criteria” required in =DSUM?

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

Explanation: “criteria” is required.

6. Is argument “records” required in =DSUM?

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

Explanation: “records” is optional.

7. What is the type of argument “criteria” in =DSUM?

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

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

8. In =DSUM, which is argument #3?

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

Explanation: Argument #3 is “fields”.

9. Which function is NOT related to =DSUM?

A. DCOUNT
B. DAVERAGE
C. DCOUNTA
D. BESSELY ✓

Explanation: “BESSELY” is not related to DSUM.

10. Is argument “fields” required in =DSUM?

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

Explanation: “fields” is optional.

11. What is the type of argument “records” in =DSUM?

A. Date
B. Text
C. Number ✓
D. Logical

Explanation: Type of “records” is “Number”.

12. Does =DSUM return a dynamic array?

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

Explanation: DSUM does not spill.

13. How many required arguments does =DSUM have?

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

Explanation: =DSUM has 3 required, 2 optional (5 total).

14. Which use case fits =DSUM?

A. Probability & Hypothesis Testing
B. Lookup & Retrieval
C. Conditional Aggregation ✓
D. Dynamic Ranges & Dashboards

Explanation: Use case “Conditional Aggregation” fits DSUM.

15. In =DSUM, which is argument #1?

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

Explanation: Argument #1 is “database”.