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

Quiz =TEXTJOIN — 15 Questions

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

Question 1 of 15 1/15

Is =TEXTJOIN volatile?

Question 2 of 15 2/15

Which is the correct syntax of =TEXTJOIN?

Question 3 of 15 3/15

What usually causes #VALUE! in =TEXTJOIN?

Question 4 of 15 4/15

In =TEXTJOIN, which is argument #1?

Question 5 of 15 5/15

In =TEXTJOIN, which is argument #3?

Question 6 of 15 6/15

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

Question 7 of 15 7/15

Is argument “delimiter” required in =TEXTJOIN?

Question 8 of 15 8/15

Which category does =TEXTJOIN belong to?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

Since which Excel version is =TEXTJOIN available?

Question 11 of 15 11/15

Which function is NOT related to =TEXTJOIN?

Question 12 of 15 12/15

In =TEXTJOIN, which is argument #2?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

How many required arguments does =TEXTJOIN have?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Is =TEXTJOIN volatile?

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

Explanation: TEXTJOIN is not volatile.

2. Which is the correct syntax of =TEXTJOIN?

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

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

3. What usually causes #VALUE! in =TEXTJOIN?

A. If the resulting string exceeds 32767 characters (cell limit), TEXTJOIN returns the #VALUE! error. ✓
B. Select entire column for best performance
C. Only works in old versions
D. Volatile and recalculates every time

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

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

A. ignore_empty
B. text2
C. delimiter ✓
D. range

Explanation: Argument #1 is “delimiter”.

5. In =TEXTJOIN, which is argument #3?

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

Explanation: Argument #3 is “text1”.

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

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

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

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

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

Explanation: “delimiter” is required.

8. Which category does =TEXTJOIN belong to?

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

Explanation: Category is “Text”.

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

A. Text
B. Number
C. Array
D. Any type ✓

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

10. Since which Excel version is =TEXTJOIN available?

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

Explanation: Version: “Excel 2019”.

11. Which function is NOT related to =TEXTJOIN?

A. ARRAYTOTEXT
B. NORMINV ✓
C. UNIQUE
D. FILTER

Explanation: “NORMINV” is not related to TEXTJOIN.

12. In =TEXTJOIN, which is argument #2?

A. ignore_empty ✓
B. lookup_value
C. value
D. delimiter

Explanation: Argument #2 is “ignore_empty”.

13. What is the type of argument “text2” in =TEXTJOIN?

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

Explanation: Type of “text2” is “Text”.

14. How many required arguments does =TEXTJOIN have?

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

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

15. What is the type of argument “ignore_empty” in =TEXTJOIN?

A. Mixed
B. Logical ✓
C. Date
D. Array

Explanation: Type of “ignore_empty” is “Logical”.