Engineering =COMPLEX(real_num, i_num, [suffix])

Quiz =COMPLEX — 15 Questions

15 quiz questions about =COMPLEX — test syntax, arguments, examples & errors!

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

← COMPLEX ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the type of argument “i_num” in =COMPLEX?

Question 2 of 15 2/15

Is argument “suffix” required in =COMPLEX?

Question 3 of 15 3/15

In =COMPLEX, which is argument #3?

Question 4 of 15 4/15

Is =COMPLEX volatile?

Question 5 of 15 5/15

How many required arguments does =COMPLEX have?

Question 6 of 15 6/15

Since which Excel version is =COMPLEX available?

Question 7 of 15 7/15

Does =COMPLEX return a dynamic array?

Question 8 of 15 8/15

What usually causes #VALUE! in =COMPLEX?

Question 9 of 15 9/15

Which use case fits =COMPLEX?

Question 10 of 15 10/15

How many arguments does =COMPLEX have in total?

Question 11 of 15 11/15

Which category does =COMPLEX belong to?

Question 12 of 15 12/15

In =COMPLEX, which is argument #1?

Question 13 of 15 13/15

Which function is related to =COMPLEX?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

Which is the correct syntax of =COMPLEX?

Click a question to see the answer.

1. What is the type of argument “i_num” in =COMPLEX?

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

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

2. Is argument “suffix” required in =COMPLEX?

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

Explanation: “suffix” is optional.

3. In =COMPLEX, which is argument #3?

A. i_num
B. value
C. suffix ✓
D. lookup_value

Explanation: Argument #3 is “suffix”.

4. Is =COMPLEX volatile?

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

Explanation: COMPLEX is not volatile.

5. How many required arguments does =COMPLEX have?

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

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

6. Since which Excel version is =COMPLEX available?

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

Explanation: Version: “All versions”.

7. Does =COMPLEX return a dynamic array?

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

Explanation: COMPLEX does not spill.

8. What usually causes #VALUE! in =COMPLEX?

A. Requires add-in
B. If real_num is nonnumeric, COMPLEX returns the #VALUE! error value. If i_num is nonnumeric, COMPLEX returns the #VALUE! error value. If suffix is neither "i" nor "j", COMPLEX returns the #VALUE! error value. ✓
C. Output is always a dynamic array
D. Text is always ignored

Explanation: If real_num is nonnumeric, COMPLEX returns the #VALUE! error value. If i_num is nonnumeric, COMPLEX returns the #VALUE! error value. If suffix is neither "i" nor "j", COMPLEX returns the #VALUE! error value. — Fix: Enter "i" or "j"

9. Which use case fits =COMPLEX?

A. Scientific & Unit Conversion ✓
B. Error Handling
C. Reshape Tables
D. Comparation

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

10. How many arguments does =COMPLEX have in total?

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

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

11. Which category does =COMPLEX belong to?

A. Logical
B. Math & Trig
C. Cube
D. Engineering ✓

Explanation: Category is “Engineering”.

12. In =COMPLEX, which is argument #1?

A. criteria
B. i_num
C. real_num ✓
D. range

Explanation: Argument #1 is “real_num”.

13. Which function is related to =COMPLEX?

A. STDEV.P
B. SLOPE
C. CONVERT ✓
D. FLOOR.MATH

Explanation: “CONVERT” is related to COMPLEX.

14. What is the fix for #VALUE! in =COMPLEX?

A. Text is always ignored
B. Only works in old versions
C. Enter "i" or "j" ✓
D. Requires add-in

15. Which is the correct syntax of =COMPLEX?

A. =COMPLEX(real_num, i_num, [suffix], 0)
B. =COMPLEX(real_num, i_num, [suffix]) ✓
C. =CONVERT(real_num, i_num, [suffix])
D. COMPLEX(real_num, i_num, [suffix])

Explanation: Correct syntax: =COMPLEX(real_num, i_num, [suffix])