Database =DSTDEV(database, field, criteria)

Quiz =DSTDEV — 15 Questions

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

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

← DSTDEV ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is argument “database” required in =DSTDEV?

Question 2 of 15 2/15

Is =DSTDEV volatile?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Which use case fits =DSTDEV?

Question 5 of 15 5/15

How many arguments does =DSTDEV have in total?

Question 6 of 15 6/15

Does =DSTDEV return a dynamic array?

Question 7 of 15 7/15

Which statement about =DSTDEV is correct?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

Which function is related to =DSTDEV?

Question 10 of 15 10/15

Is argument “field” required in =DSTDEV?

Question 11 of 15 11/15

Which category does =DSTDEV belong to?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

Since which Excel version is =DSTDEV available?

Question 14 of 15 14/15

What is the output type of =DSTDEV?

Question 15 of 15 15/15

Is argument “criteria” required in =DSTDEV?

Click a question to see the answer.

1. Is argument “database” required in =DSTDEV?

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

Explanation: “database” is required.

2. Is =DSTDEV volatile?

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

Explanation: DSTDEV is not volatile.

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

A. Date
B. Reference
C. Range ✓
D. Value

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

4. Which use case fits =DSTDEV?

A. External Data, Web & Cube
B. Data Cleaning
C. Comparation
D. Conditional Aggregation ✓

Explanation: Use case “Conditional Aggregation” fits DSTDEV.

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

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

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

6. Does =DSTDEV return a dynamic array?

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

Explanation: DSTDEV does not spill.

7. Which statement about =DSTDEV is correct?

A. Text is always ignored
B. Requires add-in
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. 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.

8. What is the type of argument “database” in =DSTDEV?

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

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

9. Which function is related to =DSTDEV?

A. TINV
B. FIND
C. DAVERAGE ✓
D. ISTEXT

Explanation: “DAVERAGE” is related to DSTDEV.

10. Is argument “field” required in =DSTDEV?

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

Explanation: “field” is required.

11. Which category does =DSTDEV belong to?

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

Explanation: Category is “Database”.

12. What is the type of argument “field” in =DSTDEV?

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

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

13. Since which Excel version is =DSTDEV available?

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

Explanation: Version: “All versions”.

14. What is the output type of =DSTDEV?

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

Explanation: Output is “Number”.

15. Is argument “criteria” required in =DSTDEV?

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

Explanation: “criteria” is required.