Text =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

Quiz =TEXTJOIN — 10 Questions

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

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

← TEXTJOIN ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is argument “text2” required in =TEXTJOIN?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

What is the type of argument “delimiter” in =TEXTJOIN?

Question 4 of 10 4/10

In =TEXTJOIN, which is argument #1?

Question 5 of 10 5/10

Which category does =TEXTJOIN belong to?

Question 6 of 10 6/10

Which is the correct syntax of =TEXTJOIN?

Question 7 of 10 7/10

Is argument “ignore_empty” required in =TEXTJOIN?

Question 8 of 10 8/10

Since which Excel version is =TEXTJOIN available?

Question 9 of 10 9/10

How many arguments does =TEXTJOIN have in total?

Question 10 of 10 10/10

Which formula is a valid example of =TEXTJOIN?

Click a question to see the answer.

1. Is argument “text2” required in =TEXTJOIN?

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

Explanation: “text2” is optional.

2. What is the fix for #VALUE! in =TEXTJOIN?

A. Reduce the number of text strings ✓
B. Output is always a dynamic array
C. Volatile and recalculates every time
D. Requires add-in

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

3. What is the type of argument “delimiter” in =TEXTJOIN?

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

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

4. In =TEXTJOIN, which is argument #1?

A. range
B. delimiter ✓
C. value
D. criteria

Explanation: Argument #1 is “delimiter”.

5. Which category does =TEXTJOIN belong to?

A. Information
B. Cube
C. Text ✓
D. Statistical

Explanation: Category is “Text”.

6. Which is the correct syntax of =TEXTJOIN?

A. =FILTER(delimiter, ignore_empty, text1, [text2], …)
B. TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
C. =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) ✓
D. =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …, 0)

Explanation: Correct syntax: =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

7. Is argument “ignore_empty” required in =TEXTJOIN?

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

Explanation: “ignore_empty” is required.

8. Since which Excel version is =TEXTJOIN available?

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

Explanation: Version: “Excel 2019”.

9. How many arguments does =TEXTJOIN have in total?

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

Explanation: =TEXTJOIN has 3 required, 1 optional (4 total).

10. Which formula is a valid example of =TEXTJOIN?

A. =TEXTJOIN(", ", TRUE, A2:A10, 0)
B. =FILTER(", ", TRUE, A2:A10)
C. =TEXTJOIN(", ", TRUE, A2:A10) ✓
D. TEXTJOIN(", ", TRUE, A2:A10)

Explanation: Correct example: =TEXTJOIN(", ", TRUE, A2:A10)