Engineering =HEX2OCT(number, [places])

Quiz =HEX2OCT — 10 Questions

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

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

← HEX2OCT ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

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

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Is =HEX2OCT volatile?

Question 4 of 10 4/10

In =HEX2OCT, which is argument #1?

Question 5 of 10 5/10

Which function is related to =HEX2OCT?

Question 6 of 10 6/10

Which category does =HEX2OCT belong to?

Question 7 of 10 7/10

What usually causes #NUM! in =HEX2OCT?

Question 8 of 10 8/10

Since which Excel version is =HEX2OCT available?

Question 9 of 10 9/10

What usually causes #VALUE! in =HEX2OCT?

Question 10 of 10 10/10

Does =HEX2OCT return a dynamic array?

Click a question to see the answer.

1. What is the type of argument “places” in =HEX2OCT?

A. Value
B. Text
C. Date
D. Number ✓

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

2. What is the type of argument “number” in =HEX2OCT?

A. Text ✓
B. Date
C. Logical
D. Reference

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

3. Is =HEX2OCT volatile?

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

Explanation: HEX2OCT is not volatile.

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

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

Explanation: Argument #1 is “number”.

5. Which function is related to =HEX2OCT?

A. BESSELI
B. CONVERT ✓
C. SERIESSUM
D. ISOMITTED

Explanation: “CONVERT” is related to HEX2OCT.

6. Which category does =HEX2OCT belong to?

A. Engineering ✓
B. Cube
C. Financial
D. Compatibility

Explanation: Category is “Engineering”.

7. What usually causes #NUM! in =HEX2OCT?

A. If number is not a valid hexadecimal number, HEX2OCT returns the #NUM! error value. If HEX2OCT requires more than places characters, it returns the #NUM! error value. If places is negative, HEX2OCT returns the #NUM! error value. ✓
B. مقدار places غیرعددی است.
C. Only works in old versions
D. Text is always ignored

Explanation: If number is not a valid hexadecimal number, HEX2OCT returns the #NUM! error value. If HEX2OCT requires more than places characters, it returns the #NUM! error value. If places is negative, HEX2OCT returns the #NUM! error value. — Fix: Valid hex

8. Since which Excel version is =HEX2OCT available?

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

Explanation: Version: “All versions”.

9. What usually causes #VALUE! in =HEX2OCT?

A. Text is always ignored
B. Only works in old versions
C. عدد number هگزادسیمال معتبری نیست، یا نتیجه به بیش از places نویسه نیاز دارد، یا places منفی است.
D. If places is nonnumeric, HEX2OCT returns the #VALUE! error value. ✓

Explanation: If places is nonnumeric, HEX2OCT returns the #VALUE! error value. — Fix: برای places یک مقدار عددی وارد کنید.

10. Does =HEX2OCT return a dynamic array?

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

Explanation: HEX2OCT does not spill.