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

In =BIN2HEX, which is argument #1?

Question 2 of 10 2/10

What usually causes #NUM! in =BIN2HEX?

Question 3 of 10 3/10

Which formula is a valid example of =BIN2HEX?

Question 4 of 10 4/10

How many required arguments does =BIN2HEX have?

Question 5 of 10 5/10

Which function is NOT related to =BIN2HEX?

Question 6 of 10 6/10

Which category does =BIN2HEX belong to?

Question 7 of 10 7/10

Which use case fits =BIN2HEX?

Question 8 of 10 8/10

What usually causes #VALUE! in =BIN2HEX?

Question 9 of 10 9/10

Which is the correct syntax of =BIN2HEX?

Question 10 of 10 10/10

What is the output type of =BIN2HEX?

Click a question to see the answer.

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

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

Explanation: Argument #1 is “number”.

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

A. Volatile and recalculates every time
B. 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. ✓
C. Select entire column for best performance
D. زمانی رخ می‌دهد که places غیرعددی باشد.

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

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

4. How many required arguments does =BIN2HEX have?

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

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

5. Which function is NOT related to =BIN2HEX?

A. BIN2HEX_X
B. IMAGE ✓
C. —
D. CONVERT

Explanation: “IMAGE” is not related to BIN2HEX.

6. Which category does =BIN2HEX belong to?

A. Engineering ✓
B. Database
C. Web
D. Information

Explanation: Category is “Engineering”.

7. Which use case fits =BIN2HEX?

A. Comparation
B. Scientific & Unit Conversion ✓
C. Investment Appraisal
D. Conditional Logic

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

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

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

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

9. Which is the correct syntax of =BIN2HEX?

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

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

10. What is the output type of =BIN2HEX?

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

Explanation: Output is “Number/Text”.