Math & Trig =COMBIN(number, number_chosen)

Quiz =COMBIN — 10 Questions

10 quiz questions about =COMBIN — test syntax, arguments, examples & errors!

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

← COMBIN ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many required arguments does =COMBIN have?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Which category does =COMBIN belong to?

Question 4 of 10 4/10

Which is the correct syntax of =COMBIN?

Question 5 of 10 5/10

Is argument “number_chosen” required in =COMBIN?

Question 6 of 10 6/10

What usually causes #NUM! in =COMBIN?

Question 7 of 10 7/10

Since which Excel version is =COMBIN available?

Question 8 of 10 8/10

Which formula is a valid example of =COMBIN?

Question 9 of 10 9/10

Which function is related to =COMBIN?

Question 10 of 10 10/10

Which statement about =COMBIN is correct?

Click a question to see the answer.

1. How many required arguments does =COMBIN have?

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

Explanation: =COMBIN has 2 required, 0 optional (2 total).

2. What is the fix for #VALUE! in =COMBIN?

A. Output is always a dynamic array
B. برای هر دو آرگومان مقدار عددی وارد کنید. ✓
C. تعداد کل یا تعداد انتخاب‌شده منفی است یا تعداد کل از انتخاب‌شده کوچک‌تر است.
D. Text is always ignored

Explanation: If either argument is nonnumeric, COMBIN returns the #VALUE! error value. — Fix: برای هر دو آرگومان مقدار عددی وارد کنید.

3. Which category does =COMBIN belong to?

A. Text
B. Information
C. Math & Trig ✓
D. Engineering

Explanation: Category is “Math & Trig”.

4. Which is the correct syntax of =COMBIN?

A. COMBIN(number, number_chosen)
B. =COMBIN(number, number_chosen) ✓
C. =BINOM-DIST(number, number_chosen)
D. =COMBIN(number, number_chosen, 0)

Explanation: Correct syntax: =COMBIN(number, number_chosen)

5. Is argument “number_chosen” required in =COMBIN?

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

Explanation: “number_chosen” is required.

6. What usually causes #NUM! in =COMBIN?

A. If number < 0, number_chosen < 0, or number < number_chosen, COMBIN returns the #NUM! error value. ✓
B. Output is always a dynamic array
C. Only works in old versions
D. Requires add-in

Explanation: If number < 0, number_chosen < 0, or number < number_chosen, COMBIN returns the #NUM! error value. — Fix: Correct the input value

7. Since which Excel version is =COMBIN available?

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

Explanation: Version: “All versions”.

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

A. =COMBIN(8,2, 0)
B. =COMBIN(8,2) ✓
C. COMBIN(8,2)
D. =BINOM-DIST(8,2)

Explanation: Correct example: =COMBIN(8,2)

9. Which function is related to =COMBIN?

A. BINOM-DIST ✓
B. HEX2BIN
C. CHOOSE
D. ISFORMULA

Explanation: “BINOM-DIST” is related to COMBIN.

10. Which statement about =COMBIN is correct?

A. A combination is any set or subset of items, regardless of their internal order. Combinations are distinct from permutations, for which the internal order is significant.
B. Numeric arguments are truncated to integers. ✓
C. Requires add-in
D. Output is always a dynamic array

Explanation: Correct: Numeric arguments are truncated to integers.