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 type of argument “number1” in =SKEW?

Question 2 of 10 2/10

Does =SKEW return a dynamic array?

Question 3 of 10 3/10

Which statement about =SKEW is correct?

Question 4 of 10 4/10

Which function is related to =SKEW?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

How many optional arguments does =SKEW have?

Question 7 of 10 7/10

How many required arguments does =SKEW have?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Which use case fits =SKEW?

Question 10 of 10 10/10

What is the output type of =SKEW?

Click a question to see the answer.

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

A. Array
B. Number ✓
C. Date
D. Logical

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

2. Does =SKEW return a dynamic array?

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

Explanation: SKEW does not spill.

3. Which statement about =SKEW is correct?

A. Arguments that are error values or text that cannot be translated into numbers cause errors.
B. Select entire column for best performance
C. Arguments can either be numbers or names, arrays, or references that contain numbers. ✓
D. Logical values and text representations of numbers that you type directly into the list of arguments are counted.

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

4. Which function is related to =SKEW?

A. FINV
B. CHOOSE
C. DPRODUCT
D. KURT ✓

Explanation: “KURT” is related to SKEW.

5. 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. Output is always a dynamic array
C. Only works in old versions
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

6. How many optional arguments does =SKEW have?

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

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

7. How many required arguments does =SKEW have?

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

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

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

A. Volatile and recalculates every time
B. Check the number and values of the data ✓
C. Only works in old versions
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

9. Which use case fits =SKEW?

A. Error Handling
B. Date & Time Calculations
C. Descriptive Statistics ✓
D. Conditional Logic

Explanation: Use case “Descriptive Statistics” fits SKEW.

10. What is the output type of =SKEW?

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

Explanation: Output is “Number”.