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

Which use case fits =OCT2HEX?

Question 2 of 10 2/10

Since which Excel version is =OCT2HEX available?

Question 3 of 10 3/10

Which statement about =OCT2HEX is correct?

Question 4 of 10 4/10

In =OCT2HEX, which is argument #1?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Is argument “number” required in =OCT2HEX?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

How many arguments does =OCT2HEX have in total?

Question 9 of 10 9/10

Which category does =OCT2HEX belong to?

Question 10 of 10 10/10

How many required arguments does =OCT2HEX have?

Click a question to see the answer.

1. Which use case fits =OCT2HEX?

A. Scientific & Unit Conversion ✓
B. Loans & Installments
C. Dynamic Ranges & Dashboards
D. Reshape Tables

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

2. Since which Excel version is =OCT2HEX available?

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

Explanation: Version: “All versions”.

3. Which statement about =OCT2HEX is correct?

A. Text is always ignored
B. Volatile and recalculates every time
C. Requires add-in
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.

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

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

Explanation: Argument #1 is “number”.

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

A. Enter a valid octal number ✓
B. Output is always a dynamic array
C. Requires add-in
D. Select entire column for best performance

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

6. Is argument “number” required in =OCT2HEX?

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

Explanation: “number” is required.

7. What is the fix for #VALUE! in =OCT2HEX?

A. Only works in old versions
B. عدد number هشت‌هشتی معتبر نیست، نتیجه به بیش از places نویسه نیاز دارد، یا مقدار places منفی است.
C. Volatile and recalculates every time
D. برای places یک مقدار عددی وارد کنید. ✓

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

8. How many arguments does =OCT2HEX have in total?

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

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

9. Which category does =OCT2HEX belong to?

A. Cube
B. Engineering ✓
C. Date & Time
D. Text

Explanation: Category is “Engineering”.

10. How many required arguments does =OCT2HEX have?

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

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