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

How many arguments does =BIN2HEX have in total?

Question 2 of 10 2/10

Which is the correct syntax of =BIN2HEX?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

How many required arguments does =BIN2HEX have?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Which function is NOT related to =BIN2HEX?

Question 7 of 10 7/10

What is the output type of =BIN2HEX?

Question 8 of 10 8/10

Since which Excel version is =BIN2HEX available?

Question 9 of 10 9/10

Which use case fits =BIN2HEX?

Question 10 of 10 10/10

Which category does =BIN2HEX belong to?

Click a question to see the answer.

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

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

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

2. Which is the correct syntax of =BIN2HEX?

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

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

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

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

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

4. How many required arguments does =BIN2HEX have?

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

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

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

A. برای places یک عدد وارد کنید و موارد متنی یا خانه‌های خالی را اصلاح کنید. ✓
B. Select entire column for best performance
C. Output is always a dynamic array
D. زمانی رخ می‌دهد که number عدد دودویی معتبر نباشد یا بیش از ۱۰ کاراکتر داشته باشد، یا نتیجه به کاراکتر بیشتری از places نیاز داشته باشد، یا places منفی باشد.

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

6. Which function is NOT related to =BIN2HEX?

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

Explanation: “DROP” is not related to BIN2HEX.

7. What is the output type of =BIN2HEX?

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

Explanation: Output is “Number/Text”.

8. Since which Excel version is =BIN2HEX available?

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

Explanation: Version: “All versions”.

9. Which use case fits =BIN2HEX?

A. Data Cleaning
B. Conditional Formatting & Validation
C. Reporting
D. Scientific & Unit Conversion ✓

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

10. Which category does =BIN2HEX belong to?

A. Engineering ✓
B. Compatibility
C. Statistical
D. Web

Explanation: Category is “Engineering”.