Engineering =OCT2BIN(number, [places])

Quiz =OCT2BIN — 10 Questions

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

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

← OCT2BIN ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which function is related to =OCT2BIN?

Question 2 of 10 2/10

Which use case fits =OCT2BIN?

Question 3 of 10 3/10

Which formula is a valid example of =OCT2BIN?

Question 4 of 10 4/10

How many arguments does =OCT2BIN have in total?

Question 5 of 10 5/10

Is argument “places” required in =OCT2BIN?

Question 6 of 10 6/10

Which statement about =OCT2BIN is correct?

Question 7 of 10 7/10

Which function is NOT related to =OCT2BIN?

Question 8 of 10 8/10

What usually causes #VALUE! in =OCT2BIN?

Question 9 of 10 9/10

What usually causes #NUM! in =OCT2BIN?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. Which function is related to =OCT2BIN?

A. CONFIDENCE.T
B. BESSELI ✓
C. MINA
D. IMSIN

Explanation: “BESSELI” is related to OCT2BIN.

2. Which use case fits =OCT2BIN?

A. Scientific & Unit Conversion ✓
B. Error Handling
C. Conditional Logic
D. Workdays & Due Dates

Explanation: Use case “Scientific & Unit Conversion” fits OCT2BIN.

3. Which formula is a valid example of =OCT2BIN?

A. OCT2BIN(3, 3)
B. =OCT2BIN(3, 3, 0)
C. =BESSELI(3, 3)
D. =OCT2BIN(3, 3) ✓

Explanation: Correct example: =OCT2BIN(3, 3)

4. How many arguments does =OCT2BIN have in total?

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

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

5. Is argument “places” required in =OCT2BIN?

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

Explanation: “places” is optional.

6. Which statement about =OCT2BIN is correct?

A. Output is always a dynamic array
B. Only works in old versions
C. If number is negative, it cannot be less than 7777777000, and if number is positive, it cannot be greater than 777.
D. If number is negative, OCT2BIN ignores places and returns a 10-character binary number. ✓

Explanation: Correct: If number is negative, OCT2BIN ignores places and returns a 10-character binary number.

7. Which function is NOT related to =OCT2BIN?

A. BESSELI
B. BESSELK
C. IMCONJUGATE ✓
D. BESSELJ

Explanation: “IMCONJUGATE” is not related to OCT2BIN.

8. What usually causes #VALUE! in =OCT2BIN?

A. Requires add-in
B. If places is nonnumeric, OCT2BIN returns the #VALUE! error value. ✓
C. Output is always a dynamic array
D. Text is always ignored

Explanation: If places is nonnumeric, OCT2BIN returns the #VALUE! error value. — Fix: برای places یک مقدار عددی وارد کنید.

9. What usually causes #NUM! in =OCT2BIN?

A. Text is always ignored
B. If number is not a valid octal number, OCT2BIN returns the #NUM! error value. If OCT2BIN requires more than places characters, it returns the #NUM! error value. If places is negative, OCT2BIN returns the #NUM! error value. ✓
C. Select entire column for best performance
D. Requires add-in

Explanation: If number is not a valid octal number, OCT2BIN returns the #NUM! error value. If OCT2BIN requires more than places characters, it returns the #NUM! error value. If places is negative, OCT2BIN returns the #NUM! error value. — Fix: عدد هشت‌هشتی معتبر در بازه مجاز وارد کنید و برای places عددی نامنفی به اندازه کافی بزرگ انتخاب کنید.

10. What is the type of argument “number” in =OCT2BIN?

A. Array
B. Text ✓
C. Date
D. Value

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