Engineering =BIN2HEX(number, [places])

Quiz =BIN2HEX — 15 Questions

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

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

← BIN2HEX ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the type of argument “places” in =BIN2HEX?

Question 2 of 15 2/15

Is =BIN2HEX volatile?

Question 3 of 15 3/15

In =BIN2HEX, which is argument #1?

Question 4 of 15 4/15

Which statement about =BIN2HEX is correct?

Question 5 of 15 5/15

Which is the correct syntax of =BIN2HEX?

Question 6 of 15 6/15

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

Question 7 of 15 7/15

Which category does =BIN2HEX belong to?

Question 8 of 15 8/15

Does =BIN2HEX return a dynamic array?

Question 9 of 15 9/15

What usually causes #NUM! in =BIN2HEX?

Question 10 of 15 10/15

Which function is NOT related to =BIN2HEX?

Question 11 of 15 11/15

Is argument “places” required in =BIN2HEX?

Question 12 of 15 12/15

Which formula is a valid example of =BIN2HEX?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

What is the output type of =BIN2HEX?

Question 15 of 15 15/15

In =BIN2HEX, which is argument #2?

Click a question to see the answer.

1. What is the type of argument “places” in =BIN2HEX?

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

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

2. Is =BIN2HEX volatile?

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

Explanation: BIN2HEX is not volatile.

3. In =BIN2HEX, which is argument #1?

A. range
B. lookup_value
C. number ✓
D. places

Explanation: Argument #1 is “number”.

4. Which statement about =BIN2HEX is correct?

A. Volatile and recalculates every time
B. If places is not an integer, it is truncated.
C. Select entire column for best performance
D. If number is negative, BIN2HEX ignores places and returns a 10-character hexadecimal number. ✓

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

5. Which is the correct syntax of =BIN2HEX?

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

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

6. What is the fix for #VALUE! in =BIN2HEX?

A. Select entire column for best performance
B. برای places یک عدد وارد کنید و موارد متنی یا خانه‌های خالی را اصلاح کنید. ✓
C. Volatile and recalculates every time
D. Only works in old versions

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

7. Which category does =BIN2HEX belong to?

A. Engineering ✓
B. Database
C. Compatibility
D. Logical

Explanation: Category is “Engineering”.

8. Does =BIN2HEX return a dynamic array?

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

Explanation: BIN2HEX does not spill.

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

A. Text is always ignored
B. Volatile and recalculates every time
C. Only works in old versions
D. If number is not a valid binary number, or if number contains more than 10 characters (10 bits), BIN2HEX returns the #NUM! error value. If BIN2HEX requires more than places characters, it returns the #NUM! error value. If places is negative, BIN2HEX returns the #NUM! error value. ✓

Explanation: If number is not a valid binary number, or if number contains more than 10 characters (10 bits), BIN2HEX returns the #NUM! error value. If BIN2HEX requires more than places characters, it returns the #NUM! error value. If places is negative, BIN2HEX returns the #NUM! error value. — Fix: places between 1 and 10

10. Which function is NOT related to =BIN2HEX?

A. CONVERT
B. BIN2HEX_X
C. —
D. LOGNORM.INV ✓

Explanation: “LOGNORM.INV” is not related to BIN2HEX.

11. Is argument “places” required in =BIN2HEX?

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

Explanation: “places” is optional.

12. Which formula is a valid example of =BIN2HEX?

A. =BIN2HEX(11111011, 4, 0)
B. BIN2HEX(11111011, 4)
C. =CONVERT(11111011, 4)
D. =BIN2HEX(11111011, 4) ✓

Explanation: Correct example: =BIN2HEX(11111011, 4)

13. What is the type of argument “number” in =BIN2HEX?

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

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

14. What is the output type of =BIN2HEX?

A. Reference
B. Number
C. Number/Text ✓
D. Logical

Explanation: Output is “Number/Text”.

15. In =BIN2HEX, which is argument #2?

A. range
B. criteria
C. value
D. places ✓

Explanation: Argument #2 is “places”.