Text =CONCAT(text1, [text2],…)

Quiz =CONCAT — 10 Questions

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

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

← CONCAT ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the type of argument “text1” in =CONCAT?

Question 2 of 10 2/10

Which function is related to =CONCAT?

Question 3 of 10 3/10

Which statement about =CONCAT is correct?

Question 4 of 10 4/10

How many required arguments does =CONCAT have?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Does =CONCAT return a dynamic array?

Question 7 of 10 7/10

Which is the correct syntax of =CONCAT?

Question 8 of 10 8/10

Which category does =CONCAT belong to?

Question 9 of 10 9/10

Is argument “text2” required in =CONCAT?

Question 10 of 10 10/10

What is the type of argument “text2” in =CONCAT?

Click a question to see the answer.

1. What is the type of argument “text1” in =CONCAT?

A. Logical
B. Mixed
C. Any type ✓
D. Number

Explanation: Type of “text1” is “Any type”.

2. Which function is related to =CONCAT?

A. UNICHAR
B. DMAX
C. TEXT ✓
D. ERFC

Explanation: “TEXT” is related to CONCAT.

3. Which statement about =CONCAT is correct?

A. Only works in old versions
B. Output is always a dynamic array
C. To include delimiters (such as spacing or ampersands (⁠&⁠)) between the text you want to combine, and to remove empty arguments you don't want to appear in the combined text result, you can use the TEXTJOIN function. ✓
D. Text is always ignored

Explanation: Correct: To include delimiters (such as spacing or ampersands (⁠&⁠)) between the text you want to combine, and to remove empty arguments you don't want to appear in the combined text result, you can use the TEXTJOIN function.

4. How many required arguments does =CONCAT have?

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

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

5. What is the fix for #VALUE! in =CONCAT?

A. Volatile and recalculates every time
B. Text is always ignored
C. Reduce the number of text strings ✓
D. Output is always a dynamic array

Explanation: If the resulting string exceeds 32767 characters (cell limit), CONCAT returns the #VALUE! error. — Fix: Reduce the number of text strings

6. Does =CONCAT return a dynamic array?

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

Explanation: CONCAT does not spill.

7. Which is the correct syntax of =CONCAT?

A. =CONCAT(text1, [text2],…, 0)
B. =CONCAT(text1, [text2],…) ✓
C. =TEXT(text1, [text2],…)
D. CONCAT(text1, [text2],…)

Explanation: Correct syntax: =CONCAT(text1, [text2],…)

8. Which category does =CONCAT belong to?

A. Compatibility
B. Financial
C. Date & Time
D. Text ✓

Explanation: Category is “Text”.

9. Is argument “text2” required in =CONCAT?

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

Explanation: “text2” is optional.

10. What is the type of argument “text2” in =CONCAT?

A. Any type ✓
B. Array
C. Date
D. Reference

Explanation: Type of “text2” is “Any type”.