Engineering =BIN2HEX(number, [places])

Quiz =BIN2HEX — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

Is argument “number” required in =BIN2HEX?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Since which Excel version is =BIN2HEX available?

Question 4 of 10 4/10

In =BIN2HEX, which is argument #1?

Question 5 of 10 5/10

Does =BIN2HEX return a dynamic array?

Question 6 of 10 6/10

How many arguments does =BIN2HEX have in total?

Question 7 of 10 7/10

Which function is NOT related to =BIN2HEX?

Question 8 of 10 8/10

Which formula is a valid example of =BIN2HEX?

Question 9 of 10 9/10

How many required arguments does =BIN2HEX have?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. Is argument “number” required in =BIN2HEX?

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

Explanation: “number” is required.

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

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

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

3. Since which Excel version is =BIN2HEX available?

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

Explanation: Version: “All versions”.

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

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

Explanation: Argument #1 is “number”.

5. Does =BIN2HEX return a dynamic array?

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

Explanation: BIN2HEX does not spill.

6. How many arguments does =BIN2HEX have in total?

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

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

7. Which function is NOT related to =BIN2HEX?

A. BIN2HEX_X
B. CHISQ.INV.RT ✓
C. CONVERT
D. —

Explanation: “CHISQ.INV.RT” is not related to BIN2HEX.

8. 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)

9. How many required arguments does =BIN2HEX have?

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

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

10. What is the fix for #NUM! in =BIN2HEX?

A. places between 1 and 10 ✓
B. Select entire column for best performance
C. Requires add-in
D. Output is always a dynamic array

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