Engineering =HEX2OCT(number, [places])

Quiz =HEX2OCT — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

How many required arguments does =HEX2OCT have?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

What is the output type of =HEX2OCT?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

Since which Excel version is =HEX2OCT available?

Question 6 of 15 6/15

Does =HEX2OCT return a dynamic array?

Question 7 of 15 7/15

How many arguments does =HEX2OCT have in total?

Question 8 of 15 8/15

In =HEX2OCT, which is argument #1?

Question 9 of 15 9/15

Which formula is a valid example of =HEX2OCT?

Question 10 of 15 10/15

Is argument “places” required in =HEX2OCT?

Question 11 of 15 11/15

Which statement about =HEX2OCT is correct?

Question 12 of 15 12/15

Is argument “number” required in =HEX2OCT?

Question 13 of 15 13/15

What usually causes #VALUE! in =HEX2OCT?

Question 14 of 15 14/15

Which category does =HEX2OCT belong to?

Question 15 of 15 15/15

In =HEX2OCT, which is argument #2?

Click a question to see the answer.

1. How many required arguments does =HEX2OCT have?

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

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

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

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

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

3. What is the output type of =HEX2OCT?

A. Number
B. Number/Text ✓
C. Reference
D. Value

Explanation: Output is “Number/Text”.

4. What is the fix for #VALUE! in =HEX2OCT?

A. Output is always a dynamic array
B. برای places یک مقدار عددی وارد کنید. ✓
C. Only works in old versions
D. عدد number هگزادسیمال معتبری نیست، یا نتیجه به بیش از places نویسه نیاز دارد، یا places منفی است.

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

5. Since which Excel version is =HEX2OCT available?

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

Explanation: Version: “All versions”.

6. Does =HEX2OCT return a dynamic array?

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

Explanation: HEX2OCT does not spill.

7. How many arguments does =HEX2OCT have in total?

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

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

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

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

Explanation: Argument #1 is “number”.

9. Which formula is a valid example of =HEX2OCT?

A. =CONVERT("F", 3)
B. HEX2OCT("F", 3)
C. =HEX2OCT("F", 3) ✓
D. =HEX2OCT("F", 3, 0)

Explanation: Correct example: =HEX2OCT("F", 3)

10. Is argument “places” required in =HEX2OCT?

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

Explanation: “places” is optional.

11. Which statement about =HEX2OCT is correct?

A. If number is negative, it cannot be less than FFE0000000, and if number is positive, it cannot be greater than 1FFFFFFF.
B. If number is negative, HEX2OCT ignores places and returns a 10-character octal number. ✓
C. Output is always a dynamic array
D. Volatile and recalculates every time

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

12. Is argument “number” required in =HEX2OCT?

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

Explanation: “number” is required.

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

A. If places is nonnumeric, HEX2OCT returns the #VALUE! error value. ✓
B. Select entire column for best performance
C. Requires add-in
D. عدد number هگزادسیمال معتبری نیست، یا نتیجه به بیش از places نویسه نیاز دارد، یا places منفی است.

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

14. Which category does =HEX2OCT belong to?

A. Information
B. Lookup & Reference
C. Engineering ✓
D. Web

Explanation: Category is “Engineering”.

15. In =HEX2OCT, which is argument #2?

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

Explanation: Argument #2 is “places”.