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 “text2” in =CONCAT?

Question 2 of 10 2/10

Is argument “text1” required in =CONCAT?

Question 3 of 10 3/10

How many optional arguments does =CONCAT have?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Which use case fits =CONCAT?

Question 7 of 10 7/10

Which is the correct syntax of =CONCAT?

Question 8 of 10 8/10

What usually causes #VALUE! in =CONCAT?

Question 9 of 10 9/10

Which statement about =CONCAT is correct?

Question 10 of 10 10/10

In =CONCAT, which is argument #1?

Click a question to see the answer.

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

A. Text
B. Reference
C. Value
D. Any type ✓

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

2. Is argument “text1” required in =CONCAT?

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

Explanation: “text1” is required.

3. How many optional arguments does =CONCAT have?

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

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

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

A. Any type ✓
B. Date
C. Value
D. Text

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

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

A. Volatile and recalculates every time
B. Only works in old versions
C. Text is always ignored
D. Reduce the number of text strings ✓

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

6. Which use case fits =CONCAT?

A. Daily Tasks ✓
B. Advanced Formulas
C. Loans & Installments
D. Rounding & Numeric

Explanation: Use case “Daily Tasks” fits CONCAT.

7. Which is the correct syntax of =CONCAT?

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

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

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

A. If the resulting string exceeds 32767 characters (cell limit), CONCAT returns the #VALUE! error. ✓
B. Select entire column for best performance
C. Output is always a dynamic array
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. Which statement about =CONCAT is correct?

A. Volatile and recalculates every time
B. Only works in old versions
C. Select entire column for best performance
D. 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. ✓

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.

10. In =CONCAT, which is argument #1?

A. text2
B. criteria
C. lookup_value
D. text1 ✓

Explanation: Argument #1 is “text1”.