Statistical =PERMUTATIONA(number, number-chosen)

Quiz =PERMUTATIONA — 15 Questions

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

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

← PERMUTATIONA ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the fix for #VALUE! in =PERMUTATIONA?

Question 2 of 15 2/15

In =PERMUTATIONA, which is argument #1?

Question 3 of 15 3/15

Is =PERMUTATIONA volatile?

Question 4 of 15 4/15

What is the type of argument “number_chosen” in =PERMUTATIONA?

Question 5 of 15 5/15

Does =PERMUTATIONA return a dynamic array?

Question 6 of 15 6/15

Since which Excel version is =PERMUTATIONA available?

Question 7 of 15 7/15

What usually causes #NUM! in =PERMUTATIONA?

Question 8 of 15 8/15

Is argument “number” required in =PERMUTATIONA?

Question 9 of 15 9/15

What is the fix for #NUM! in =PERMUTATIONA?

Question 10 of 15 10/15

Which formula is a valid example of =PERMUTATIONA?

Question 11 of 15 11/15

How many optional arguments does =PERMUTATIONA have?

Question 12 of 15 12/15

How many arguments does =PERMUTATIONA have in total?

Question 13 of 15 13/15

Which function is NOT related to =PERMUTATIONA?

Question 14 of 15 14/15

What is the type of argument “number” in =PERMUTATIONA?

Question 15 of 15 15/15

What is the output type of =PERMUTATIONA?

Click a question to see the answer.

1. What is the fix for #VALUE! in =PERMUTATIONA?

A. Volatile and recalculates every time
B. برای هر دو آرگومان مقدار عددی وارد کنید و بررسی کنید سلول‌های مرجع خالی یا متنی نباشند. ✓
C. Output is always a dynamic array
D. Select entire column for best performance

Explanation: If numeric arguments use data types that are nonnumeric, PERMUTATIONA returns the #VALUE! error value. — Fix: برای هر دو آرگومان مقدار عددی وارد کنید و بررسی کنید سلول‌های مرجع خالی یا متنی نباشند.

2. In =PERMUTATIONA, which is argument #1?

A. value
B. number_chosen
C. number ✓
D. lookup_value

Explanation: Argument #1 is “number”.

3. Is =PERMUTATIONA volatile?

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

Explanation: PERMUTATIONA is not volatile.

4. What is the type of argument “number_chosen” in =PERMUTATIONA?

A. Text
B. Reference
C. Number ✓
D. Array

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

5. Does =PERMUTATIONA return a dynamic array?

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

Explanation: PERMUTATIONA does not spill.

6. Since which Excel version is =PERMUTATIONA available?

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

Explanation: Version: “Excel 2013”.

7. What usually causes #NUM! in =PERMUTATIONA?

A. آرگومان‌های عددی از نوع داده غیرعددی هستند.
B. If numeric arguments are values that are not valid, for example, when the total number is zero (0) and the chosen number is larger than zero (0), PERMUTATIONA returns the #NUM! error value. ✓
C. Text is always ignored
D. Only works in old versions

Explanation: If numeric arguments are values that are not valid, for example, when the total number is zero (0) and the chosen number is larger than zero (0), PERMUTATIONA returns the #NUM! error value. — Fix: Correct the input value

8. Is argument “number” required in =PERMUTATIONA?

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

Explanation: “number” is optional.

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

A. Output is always a dynamic array
B. Select entire column for best performance
C. Volatile and recalculates every time
D. Correct the input value ✓

10. Which formula is a valid example of =PERMUTATIONA?

A. =PERMUTATIONA(3,2, 0)
B. =PERMUT(3,2)
C. PERMUTATIONA(3,2)
D. =PERMUTATIONA(3,2) ✓

Explanation: Correct example: =PERMUTATIONA(3,2)

11. How many optional arguments does =PERMUTATIONA have?

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

Explanation: =PERMUTATIONA has 1 required, 1 optional (2 total).

12. How many arguments does =PERMUTATIONA have in total?

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

Explanation: =PERMUTATIONA has 1 required, 1 optional (2 total).

13. Which function is NOT related to =PERMUTATIONA?

A. PERMUT
B. POWER
C. COUPNCD ✓
D. PERMUTATIONA_X

Explanation: “COUPNCD” is not related to PERMUTATIONA.

14. What is the type of argument “number” in =PERMUTATIONA?

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

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

15. What is the output type of =PERMUTATIONA?

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

Explanation: Output is “Number”.