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

Quiz =SKEW — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

Does =SKEW return a dynamic array?

Question 2 of 10 2/10

Which statement about =SKEW is correct?

Question 3 of 10 3/10

In =SKEW, which is argument #1?

Question 4 of 10 4/10

How many arguments does =SKEW have in total?

Question 5 of 10 5/10

Is =SKEW volatile?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

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

Question 8 of 10 8/10

Since which Excel version is =SKEW available?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

Which category does =SKEW belong to?

Click a question to see the answer.

1. Does =SKEW return a dynamic array?

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

Explanation: SKEW does not spill.

2. Which statement about =SKEW is correct?

A. Arguments can either be numbers or names, arrays, or references that contain numbers. ✓
B. Only works in old versions
C. Arguments that are error values or text that cannot be translated into numbers cause errors.
D. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.

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

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

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

Explanation: Argument #1 is “number1”.

4. How many arguments does =SKEW have in total?

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

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

5. Is =SKEW volatile?

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

Explanation: SKEW is not volatile.

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

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

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

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

A. Select entire column for best performance
B. Only works in old versions
C. Volatile and recalculates every time
D. If there are fewer than three data points, or the sample standard deviation is zero, SKEW returns the #DIV/0! error value. ✓

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

8. Since which Excel version is =SKEW available?

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

Explanation: Version: “All versions”.

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

A. Only works in old versions
B. Output is always a dynamic array
C. Check the number and values of the data ✓
D. Requires add-in

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

10. Which category does =SKEW belong to?

A. Logical
B. Engineering
C. Information
D. Statistical ✓

Explanation: Category is “Statistical”.