Engineering =OCT2HEX(number, [places])

Quiz =OCT2HEX — 10 Questions

10 quiz questions about =OCT2HEX — test syntax, arguments, examples & errors!

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

← OCT2HEX ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many optional arguments does =OCT2HEX have?

Question 2 of 10 2/10

Since which Excel version is =OCT2HEX available?

Question 3 of 10 3/10

Which function is NOT related to =OCT2HEX?

Question 4 of 10 4/10

Which formula is a valid example of =OCT2HEX?

Question 5 of 10 5/10

Which function is related to =OCT2HEX?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Is =OCT2HEX volatile?

Question 8 of 10 8/10

In =OCT2HEX, which is argument #1?

Question 9 of 10 9/10

Which statement about =OCT2HEX is correct?

Question 10 of 10 10/10

Which is the correct syntax of =OCT2HEX?

Click a question to see the answer.

1. How many optional arguments does =OCT2HEX have?

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

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

2. Since which Excel version is =OCT2HEX available?

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

Explanation: Version: “All versions”.

3. Which function is NOT related to =OCT2HEX?

A. SUMX2MY2 ✓
B. —
C. OCT2HEX_X
D. CONVERT

Explanation: “SUMX2MY2” is not related to OCT2HEX.

4. Which formula is a valid example of =OCT2HEX?

A. =OCT2HEX(100, 4) ✓
B. =OCT2HEX(100, 4, 0)
C. =CONVERT(100, 4)
D. OCT2HEX(100, 4)

Explanation: Correct example: =OCT2HEX(100, 4)

5. Which function is related to =OCT2HEX?

A. SECOND
B. CRITBINOM
C. CONVERT ✓
D. DVAR

Explanation: “CONVERT” is related to OCT2HEX.

6. What is the fix for #NUM! in =OCT2HEX?

A. Volatile and recalculates every time
B. Requires add-in
C. Enter a valid octal number ✓
D. Text is always ignored

Explanation: If number is not a valid octal number, OCT2HEX returns the #NUM! error value. If OCT2HEX requires more than places characters, it returns the #NUM! error value. If places is negative, OCT2HEX returns the #NUM! error value. — Fix: Enter a valid octal number

7. Is =OCT2HEX volatile?

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

Explanation: OCT2HEX is not volatile.

8. In =OCT2HEX, which is argument #1?

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

Explanation: Argument #1 is “number”.

9. Which statement about =OCT2HEX is correct?

A. If places is not an integer, it is truncated.
B. Select entire column for best performance
C. Text is always ignored
D. If number is negative, OCT2HEX ignores places and returns a 10-character hexadecimal number. ✓

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

10. Which is the correct syntax of =OCT2HEX?

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

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