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

Quiz =COMPLEX — 10 Questions

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

Question 1 of 10 1/10

Which formula is a valid example of =COMPLEX?

Question 2 of 10 2/10

Does =COMPLEX return a dynamic array?

Question 3 of 10 3/10

Which function is NOT related to =COMPLEX?

Question 4 of 10 4/10

What is the output type of =COMPLEX?

Question 5 of 10 5/10

Which function is related to =COMPLEX?

Question 6 of 10 6/10

Which category does =COMPLEX belong to?

Question 7 of 10 7/10

How many required arguments does =COMPLEX have?

Question 8 of 10 8/10

How many arguments does =COMPLEX have in total?

Question 9 of 10 9/10

What usually causes #VALUE! in =COMPLEX?

Question 10 of 10 10/10

Is argument “real_num” required in =COMPLEX?

Click a question to see the answer.

1. Which formula is a valid example of =COMPLEX?

A. =COMPLEX(3,4, 0)
B. COMPLEX(3,4)
C. =CONVERT(3,4)
D. =COMPLEX(3,4) ✓

Explanation: Correct example: =COMPLEX(3,4)

2. Does =COMPLEX return a dynamic array?

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

Explanation: COMPLEX does not spill.

3. Which function is NOT related to =COMPLEX?

A. COMPLEX_X
B. —
C. CONVERT
D. SORTBY ✓

Explanation: “SORTBY” is not related to COMPLEX.

4. What is the output type of =COMPLEX?

A. Logical
B. Array
C. Mixed
D. Number/Text ✓

Explanation: Output is “Number/Text”.

5. Which function is related to =COMPLEX?

A. CONVERT ✓
B. T.INV.2T
C. VARP
D. ASC

Explanation: “CONVERT” is related to COMPLEX.

6. Which category does =COMPLEX belong to?

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

Explanation: Category is “Engineering”.

7. How many required arguments does =COMPLEX have?

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

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

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

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

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

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

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

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"

10. Is argument “real_num” required in =COMPLEX?

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

Explanation: “real_num” is required.