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

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

Question 2 of 10 2/10

How many optional arguments does =SKEW have?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Which is the correct syntax of =SKEW?

Question 5 of 10 5/10

How many required arguments does =SKEW have?

Question 6 of 10 6/10

Which category does =SKEW belong to?

Question 7 of 10 7/10

Which function is NOT related to =SKEW?

Question 8 of 10 8/10

Which formula is a valid example of =SKEW?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

Which statement about =SKEW is correct?

Click a question to see the answer.

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

A. Select entire column for best performance
B. Only works in old versions
C. Output is always a dynamic array
D. Check the number and values of the data ✓

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

2. How many optional arguments does =SKEW have?

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

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

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

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

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

4. Which is the correct syntax of =SKEW?

A. SKEW(number1, [number2], ...)
B. =SKEW(number1, [number2], ...) ✓
C. =SKEW(number1, [number2], ..., 0)
D. =KURT(number1, [number2], ...)

Explanation: Correct syntax: =SKEW(number1, [number2], ...)

5. How many required arguments does =SKEW have?

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

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

6. Which category does =SKEW belong to?

A. Text
B. Statistical ✓
C. Database
D. Logical

Explanation: Category is “Statistical”.

7. Which function is NOT related to =SKEW?

A. KURT
B. SKEW-P
C. ISEVEN ✓
D. MEDIAN

Explanation: “ISEVEN” is not related to SKEW.

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

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

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

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

A. Output is always a dynamic array
B. Requires add-in
C. Text is always ignored
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

10. Which statement about =SKEW is correct?

A. Volatile and recalculates every time
B. Arguments that are error values or text that cannot be translated into numbers cause errors.
C. Select entire column for best performance
D. Arguments can either be numbers or names, arrays, or references that contain numbers. ✓

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