Statistical =SKEW(number1, [number2], ...)

Quiz =SKEW — 15 Questions

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

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

← SKEW ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the output type of =SKEW?

Question 2 of 15 2/15

Which use case fits =SKEW?

Question 3 of 15 3/15

What is the type of argument “number1” in =SKEW?

Question 4 of 15 4/15

Is =SKEW volatile?

Question 5 of 15 5/15

Which formula is a valid example of =SKEW?

Question 6 of 15 6/15

What usually causes #DIV/0! in =SKEW?

Question 7 of 15 7/15

Is argument “number1” required in =SKEW?

Question 8 of 15 8/15

Does =SKEW return a dynamic array?

Question 9 of 15 9/15

Which statement about =SKEW is correct?

Question 10 of 15 10/15

How many required arguments does =SKEW have?

Question 11 of 15 11/15

What is the fix for #DIV/0! in =SKEW?

Question 12 of 15 12/15

Since which Excel version is =SKEW available?

Question 13 of 15 13/15

How many optional arguments does =SKEW have?

Question 14 of 15 14/15

In =SKEW, which is argument #1?

Question 15 of 15 15/15

Which function is related to =SKEW?

Click a question to see the answer.

1. What is the output type of =SKEW?

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

Explanation: Output is “Number”.

2. Which use case fits =SKEW?

A. Descriptive Statistics ✓
B. Daily Tasks
C. Probability & Hypothesis Testing
D. Loans & Installments

Explanation: Use case “Descriptive Statistics” fits SKEW.

3. What is the type of argument “number1” in =SKEW?

A. Value
B. Date
C. Number ✓
D. Mixed

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

4. Is =SKEW volatile?

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

Explanation: SKEW is not volatile.

5. Which formula is a valid example of =SKEW?

A. SKEW(A2:A11)
B. =SKEW(A2:A11) ✓
C. =KURT(A2:A11)
D. =SKEW(A2:A11, 0)

Explanation: Correct example: =SKEW(A2:A11)

6. What usually causes #DIV/0! in =SKEW?

A. If there are fewer than three data points, or the sample standard deviation is zero, SKEW returns the #DIV/0! error value. ✓
B. Text is always ignored
C. Output is always a dynamic array
D. Only works in old versions

Explanation: If there are fewer than three data points, or the sample standard deviation is zero, SKEW returns the #DIV/0! error value. — Fix: Check the number and values of the data

7. Is argument “number1” required in =SKEW?

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

Explanation: “number1” is required.

8. Does =SKEW return a dynamic array?

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

Explanation: SKEW does not spill.

9. Which statement about =SKEW is correct?

A. Logical values and text representations of numbers that you type directly into the list of arguments are counted.
B. Arguments can either be numbers or names, arrays, or references that contain numbers. ✓
C. Arguments that are error values or text that cannot be translated into numbers cause errors.
D. Requires add-in

Explanation: Correct: Arguments can either be numbers or names, arrays, or references that contain numbers.

10. How many required arguments does =SKEW have?

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

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

11. What is the fix for #DIV/0! in =SKEW?

A. Only works in old versions
B. Check the number and values of the data ✓
C. Volatile and recalculates every time
D. Output is always a dynamic array

Explanation: If there are fewer than three data points, or the sample standard deviation is zero, SKEW returns the #DIV/0! error value. — Fix: Check the number and values of the data

12. Since which Excel version is =SKEW available?

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

Explanation: Version: “All versions”.

13. How many optional arguments does =SKEW have?

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

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

14. In =SKEW, which is argument #1?

A. value
B. lookup_value
C. range
D. number1 ✓

Explanation: Argument #1 is “number1”.

15. Which function is related to =SKEW?

A. FILTERXML
B. FLOOR.PRECISE
C. COVARIANCE.S
D. KURT ✓

Explanation: “KURT” is related to SKEW.