Database =DGET(database, field, criteria)

Quiz =DGET — 10 Questions

10 quiz questions about =DGET — test syntax, arguments, examples & errors!

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

← DGET ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which use case fits =DGET?

Question 2 of 10 2/10

What is the output type of =DGET?

Question 3 of 10 3/10

What usually causes #VALUE! in =DGET?

Question 4 of 10 4/10

What usually causes #NUM! in =DGET?

Question 5 of 10 5/10

How many arguments does =DGET have in total?

Question 6 of 10 6/10

How many optional arguments does =DGET have?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

How many required arguments does =DGET have?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

Which is the correct syntax of =DGET?

Click a question to see the answer.

1. Which use case fits =DGET?

A. Dynamic Ranges & Dashboards
B. Conditional Aggregation
C. Worksheet Info & Navigation
D. Lookup & Retrieval ✓

Explanation: Use case “Lookup & Retrieval” fits DGET.

2. What is the output type of =DGET?

A. Value
B. Logical
C. Mixed ✓
D. Array

Explanation: Output is “Mixed”.

3. What usually causes #VALUE! in =DGET?

A. Volatile and recalculates every time
B. If no record matches the criteria, DGET returns the #VALUE! error value. ✓
C. بیش از یک رکورد با شرط مطابقت دارد و تابع نمی‌تواند یک مقدار واحد برگرداند.
D. Output is always a dynamic array

Explanation: If no record matches the criteria, DGET returns the #VALUE! error value. — Fix: Check the criteria values and the criteria range headers

4. What usually causes #NUM! in =DGET?

A. Output is always a dynamic array
B. If more than one record matches the criteria, DGET returns the #NUM! error value. ✓
C. Text is always ignored
D. هیچ رکوردی با شرط مطابقت ندارد.

Explanation: If more than one record matches the criteria, DGET returns the #NUM! error value. — Fix: شرط‌ها را دقیق‌تر کنید تا فقط یک رکورد باقی بماند، یا از تابع دیگری مانند DFILTER/DSUM استفاده کنید.

5. How many arguments does =DGET have in total?

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

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

6. How many optional arguments does =DGET have?

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

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

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

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

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

8. How many required arguments does =DGET have?

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

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

9. What is the type of argument “criteria” in =DGET?

A. Logical
B. Range ✓
C. Mixed
D. Array

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

10. Which is the correct syntax of =DGET?

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

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