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

Is argument “field” required in =DGET?

Question 2 of 10 2/10

Which statement about =DGET is correct?

Question 3 of 10 3/10

Is =DGET volatile?

Question 4 of 10 4/10

Which formula is a valid example of =DGET?

Question 5 of 10 5/10

Does =DGET return a dynamic array?

Question 6 of 10 6/10

Which category does =DGET belong to?

Question 7 of 10 7/10

What is the output type of =DGET?

Question 8 of 10 8/10

In =DGET, which is argument #1?

Question 9 of 10 9/10

How many optional arguments does =DGET have?

Question 10 of 10 10/10

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

Click a question to see the answer.

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

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

Explanation: “field” is required.

2. Which statement about =DGET is correct?

A. 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. ✓
B. Select entire column for best performance
C. To perform an operation on an entire column in a database, enter a blank line below the column labels in the criteria range.
D. Make sure that the criteria range does not overlap the list.

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 =DGET volatile?

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

Explanation: DGET is not volatile.

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

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

Explanation: Correct example: =DGET(A4:E10, "Yield", A1:A3)

5. Does =DGET return a dynamic array?

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

Explanation: DGET does not spill.

6. Which category does =DGET belong to?

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

Explanation: Category is “Database”.

7. What is the output type of =DGET?

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

Explanation: Output is “Mixed”.

8. In =DGET, which is argument #1?

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

Explanation: Argument #1 is “database”.

9. How many optional arguments does =DGET have?

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

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

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

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

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