Statistical =SKEW.P(number 1, [number 2],…)

Quiz =SKEW.P — 10 Questions

10 quiz questions about =SKEW.P — test syntax, arguments, examples & errors!

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

← SKEW.P ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

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

Question 2 of 10 2/10

Is argument “number” required in =SKEW.P?

Question 3 of 10 3/10

Which use case fits =SKEW.P?

Question 4 of 10 4/10

How many required arguments does =SKEW.P have?

Question 5 of 10 5/10

Which statement about =SKEW.P is correct?

Question 6 of 10 6/10

Which function is NOT related to =SKEW.P?

Question 7 of 10 7/10

What usually causes #VALUE! in =SKEW.P?

Question 8 of 10 8/10

What usually causes #NUM! in =SKEW.P?

Question 9 of 10 9/10

What is the fix for #NUM! in =SKEW.P?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. Which formula is a valid example of =SKEW.P?

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

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

2. Is argument “number” required in =SKEW.P?

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

Explanation: “number” is optional.

3. Which use case fits =SKEW.P?

A. Conditional Aggregation
B. Date & Time Calculations
C. Depreciation
D. Descriptive Statistics ✓

Explanation: Use case “Descriptive Statistics” fits SKEW.P.

4. How many required arguments does =SKEW.P have?

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

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

5. Which statement about =SKEW.P is correct?

A. Arguments can either be numbers or names, arrays, or references that contain numbers. ✓
B. Volatile and recalculates every time
C. Only works in old versions
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.

6. Which function is NOT related to =SKEW.P?

A. STDEV-P
B. KURT
C. MOD ✓
D. SKEW

Explanation: “MOD” is not related to SKEW.P.

7. What usually causes #VALUE! in =SKEW.P?

A. Select entire column for best performance
B. If arguments use data types that are not valid, SKEW.P returns the #VALUE! error value. ✓
C. Text is always ignored
D. اگر آرگومان‌ها مقادیر نامعتبر باشند، تابع SKEW.P خطای #NUM! را برمی‌گرداند.

Explanation: If arguments use data types that are not valid, SKEW.P returns the #VALUE! error value. — Fix: مطمئن شوید آرگومان‌ها عدد، نام، آرایه یا مرجع حاوی اعداد هستند و متن غیرقابل تبدیل وارد نکرده‌اید.

8. What usually causes #NUM! in =SKEW.P?

A. Requires add-in
B. Only works in old versions
C. اگر کمتر از سه نقطه داده وجود داشته باشد یا انحراف معیار نمونه صفر باشد، تابع SKEW.P خطای #DIV/0! را برمی‌گرداند.
D. If arguments are values that are not valid, SKEW.P returns the #NUM! error value. ✓

Explanation: If arguments are values that are not valid, SKEW.P returns the #NUM! error value. — Fix: مقادیر عددی معتبر وارد کنید و مطمئن شوید داده‌ها در محدوده قابل محاسبه هستند.

9. What is the fix for #NUM! in =SKEW.P?

A. Text is always ignored
B. اگر کمتر از سه نقطه داده وجود داشته باشد یا انحراف معیار نمونه صفر باشد، تابع SKEW.P خطای #DIV/0! را برمی‌گرداند.
C. مقادیر عددی معتبر وارد کنید و مطمئن شوید داده‌ها در محدوده قابل محاسبه هستند. ✓
D. Requires add-in

10. How many arguments does =SKEW.P have in total?

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

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