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

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

Question 2 of 10 2/10

Which formula is a valid example of =BIN2HEX?

Question 3 of 10 3/10

Which statement about =BIN2HEX is correct?

Question 4 of 10 4/10

In =BIN2HEX, which is argument #1?

Question 5 of 10 5/10

Which function is related to =BIN2HEX?

Question 6 of 10 6/10

In =BIN2HEX, which is argument #2?

Question 7 of 10 7/10

What usually causes #VALUE! in =BIN2HEX?

Question 8 of 10 8/10

What usually causes #NUM! in =BIN2HEX?

Question 9 of 10 9/10

Which use case fits =BIN2HEX?

Question 10 of 10 10/10

How many optional arguments does =BIN2HEX have?

Click a question to see the answer.

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

A. places between 1 and 10 ✓
B. Volatile and recalculates every time
C. Requires add-in
D. Only works in old versions

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

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

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

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

3. Which statement about =BIN2HEX is correct?

A. If number is negative, BIN2HEX ignores places and returns a 10-character hexadecimal number. ✓
B. Output is always a dynamic array
C. Text is always ignored
D. If places is not an integer, it is truncated.

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

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

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

Explanation: Argument #1 is “number”.

5. Which function is related to =BIN2HEX?

A. EDATE
B. FTEST
C. RATE
D. CONVERT ✓

Explanation: “CONVERT” is related to BIN2HEX.

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

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

Explanation: Argument #2 is “places”.

7. What usually causes #VALUE! in =BIN2HEX?

A. If places is nonnumeric, BIN2HEX returns the #VALUE! error value. ✓
B. زمانی رخ می‌دهد که number عدد دودویی معتبر نباشد یا بیش از ۱۰ کاراکتر داشته باشد، یا نتیجه به کاراکتر بیشتری از places نیاز داشته باشد، یا places منفی باشد.
C. Volatile and recalculates every time
D. Text is always ignored

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

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

A. 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. ✓
B. Select entire column for best performance
C. Requires add-in
D. Output is always a dynamic array

9. Which use case fits =BIN2HEX?

A. Reshape Tables
B. Daily Tasks
C. Conditional Logic
D. Scientific & Unit Conversion ✓

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

10. How many optional arguments does =BIN2HEX have?

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

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