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

Since which Excel version is =CONCAT available?

Question 2 of 10 2/10

Which formula is a valid example of =CONCAT?

Question 3 of 10 3/10

Which is the correct syntax of =CONCAT?

Question 4 of 10 4/10

Which category does =CONCAT belong to?

Question 5 of 10 5/10

Which statement about =CONCAT is correct?

Question 6 of 10 6/10

What is the output type of =CONCAT?

Question 7 of 10 7/10

Does =CONCAT return a dynamic array?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

In =CONCAT, which is argument #2?

Question 10 of 10 10/10

Is argument “text2” required in =CONCAT?

Click a question to see the answer.

1. Since which Excel version is =CONCAT available?

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

Explanation: Version: “Excel 2019”.

2. Which formula is a valid example of =CONCAT?

A. =CONCAT(B:B, C:C) ✓
B. =CONCAT(B:B, C:C, 0)
C. CONCAT(B:B, C:C)
D. =TEXT(B:B, C:C)

Explanation: Correct example: =CONCAT(B:B, C:C)

3. Which is the correct syntax of =CONCAT?

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

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

4. Which category does =CONCAT belong to?

A. Lookup & Reference
B. Logical
C. Database
D. Text ✓

Explanation: Category is “Text”.

5. Which statement about =CONCAT is correct?

A. Text is always ignored
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. Requires add-in

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.

6. What is the output type of =CONCAT?

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

Explanation: Output is “Text”.

7. Does =CONCAT return a dynamic array?

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

Explanation: CONCAT does not spill.

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

A. Reduce the number of text strings ✓
B. Volatile and recalculates every time
C. Requires add-in
D. Only works in old versions

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

9. In =CONCAT, which is argument #2?

A. range
B. value
C. text1
D. text2 ✓

Explanation: Argument #2 is “text2”.

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

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

Explanation: “text2” is optional.