Statistical =STDEVA(value1, [value2], ...)

Quiz =STDEVA — 10 Questions

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

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

← STDEVA ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which statement about =STDEVA is correct?

Question 2 of 10 2/10

What is the type of argument “value1” in =STDEVA?

Question 3 of 10 3/10

Which is the correct syntax of =STDEVA?

Question 4 of 10 4/10

Which function is NOT related to =STDEVA?

Question 5 of 10 5/10

Which use case fits =STDEVA?

Question 6 of 10 6/10

In =STDEVA, which is argument #1?

Question 7 of 10 7/10

How many arguments does =STDEVA have in total?

Question 8 of 10 8/10

Since which Excel version is =STDEVA available?

Question 9 of 10 9/10

Which category does =STDEVA belong to?

Question 10 of 10 10/10

How many required arguments does =STDEVA have?

Click a question to see the answer.

1. Which statement about =STDEVA is correct?

A. Only works in old versions
B. Output is always a dynamic array
C. STDEVA assumes that its arguments are a sample of the population. If your data represents the entire population, you must compute the standard deviation using STDEVPA. ✓
D. The standard deviation is calculated using the "n-1" method.

Explanation: Correct: STDEVA assumes that its arguments are a sample of the population. If your data represents the entire population, you must compute the standard deviation using STDEVPA.

2. What is the type of argument “value1” in =STDEVA?

A. Mixed
B. Text
C. Number
D. Any type ✓

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

3. Which is the correct syntax of =STDEVA?

A. =STDEV-S(value1, [value2], ...)
B. =STDEVA(value1, [value2], ...) ✓
C. STDEVA(value1, [value2], ...)
D. =STDEVA(value1, [value2], ..., 0)

Explanation: Correct syntax: =STDEVA(value1, [value2], ...)

4. Which function is NOT related to =STDEVA?

A. VARA
B. DOLLARFR ✓
C. STDEV-S
D. STDEVPA

Explanation: “DOLLARFR” is not related to STDEVA.

5. Which use case fits =STDEVA?

A. Loans & Installments
B. Date & Time Calculations
C. Descriptive Statistics ✓
D. Data Cleaning

Explanation: Use case “Descriptive Statistics” fits STDEVA.

6. In =STDEVA, which is argument #1?

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

Explanation: Argument #1 is “value1”.

7. How many arguments does =STDEVA have in total?

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

Explanation: =STDEVA has 1 required, 0 optional (1 total).

8. Since which Excel version is =STDEVA available?

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

Explanation: Version: “All versions”.

9. Which category does =STDEVA belong to?

A. Date & Time
B. Engineering
C. Logical
D. Statistical ✓

Explanation: Category is “Statistical”.

10. How many required arguments does =STDEVA have?

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

Explanation: =STDEVA has 1 required, 0 optional (1 total).