Engineering =BIN2OCT(number, [places])

Quiz =BIN2OCT — 10 Questions

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

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

← BIN2OCT ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which formula is a valid example of =BIN2OCT?

Question 2 of 10 2/10

Which is the correct syntax of =BIN2OCT?

Question 3 of 10 3/10

Which statement about =BIN2OCT is correct?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

How many required arguments does =BIN2OCT have?

Question 6 of 10 6/10

What is the output type of =BIN2OCT?

Question 7 of 10 7/10

How many arguments does =BIN2OCT have in total?

Question 8 of 10 8/10

How many optional arguments does =BIN2OCT have?

Question 9 of 10 9/10

Does =BIN2OCT return a dynamic array?

Question 10 of 10 10/10

Which function is NOT related to =BIN2OCT?

Click a question to see the answer.

1. Which formula is a valid example of =BIN2OCT?

A. =BIN2OCT(1001, 3, 0)
B. =BIN2OCT(1001, 3) ✓
C. =CONVERT(1001, 3)
D. BIN2OCT(1001, 3)

Explanation: Correct example: =BIN2OCT(1001, 3)

2. Which is the correct syntax of =BIN2OCT?

A. =BIN2OCT(number, [places], 0)
B. =CONVERT(number, [places])
C. =BIN2OCT(number, [places]) ✓
D. BIN2OCT(number, [places])

Explanation: Correct syntax: =BIN2OCT(number, [places])

3. Which statement about =BIN2OCT is correct?

A. If places is not an integer, it is truncated.
B. Text is always ignored
C. If number is negative, BIN2OCT ignores places and returns a 10-character octal number. ✓
D. Only works in old versions

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

4. What is the fix for #VALUE! in =BIN2OCT?

A. زمانی رخ می‌دهد که number عدد دودویی معتبر نباشد یا بیش از ۱۰ کاراکتر داشته باشد، یا نتیجه به کاراکتر بیشتری از places نیاز داشته باشد، یا places منفی باشد.
B. برای places یک عدد وارد کنید و موارد متنی یا خانه‌های خالی را اصلاح کنید. ✓
C. Text is always ignored
D. Requires add-in

Explanation: If places is nonnumeric, BIN2OCT returns the #VALUE! error value. — Fix: برای places یک عدد وارد کنید و موارد متنی یا خانه‌های خالی را اصلاح کنید.

5. How many required arguments does =BIN2OCT have?

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

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

6. What is the output type of =BIN2OCT?

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

Explanation: Output is “Number/Text”.

7. How many arguments does =BIN2OCT have in total?

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

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

8. How many optional arguments does =BIN2OCT have?

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

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

9. Does =BIN2OCT return a dynamic array?

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

Explanation: BIN2OCT does not spill.

10. Which function is NOT related to =BIN2OCT?

A. CONVERT
B. BIN2OCT_X
C. —
D. STOCKHISTORY ✓

Explanation: “STOCKHISTORY” is not related to BIN2OCT.