MCQ
Which function joins text with a delimiter?
Microsoft Excel
A
TEXTJOIN
B
CONCAT
C
JOIN
D
MERGE
Explanation
TEXTJOIN combines values with a separator.
Related MCQs
Which function multiplies corresponding arrays and sums the results?
Microsoft Excel
View
Which error appears when a number is divided by zero in Excel?
Microsoft Excel
View
Which tab contains the Remove Duplicates command?
Microsoft Excel
View
What operator does a single space between two ranges represent in Excel?
Microsoft Excel
View
Which chart type best shows parts of a whole?
Microsoft Excel
View
Which shortcut selects an entire row?
Microsoft Excel
View