What does the `CONCAT` function do in Excel?
A
Calculates sum of numbers
B
Joins two or more text strings
D
Returns the length of a string
Analysis & Theory
`CONCAT` is used to **combine multiple text strings** into one string.
Which of the following formulas will return `HelloWorld`?
A
=CONCAT("Hello", " World")
B
=CONCAT("Hello", "World")
C
=CONCAT("Hello" + "World")
D
=CONCATENATE("Hello", "-World")
Analysis & Theory
`=CONCAT("Hello", "World")` returns `HelloWorld`. The space is not included unless explicitly added.
Which function replaces the `CONCATENATE` function in Excel 2016 and later?
Analysis & Theory
`CONCAT` is the newer and improved version of `CONCATENATE` in modern Excel versions.
What will be the result of `=CONCAT("Good", " ", "Morning")`?
Analysis & Theory
The formula includes a space between the words, so it returns `Good Morning`.
Which of the following is TRUE about `CONCAT` vs `TEXTJOIN`?
A
`TEXTJOIN` cannot use delimiters
B
`CONCAT` ignores empty cells
C
`TEXTJOIN` can handle delimiters and ignore empty cells
D
`CONCAT` can only combine 2 strings
Analysis & Theory
`TEXTJOIN` allows a delimiter and can optionally skip empty cells, making it more flexible than `CONCAT`.
Which Excel formula joins cells A1, B1, and C1 with spaces in between?
B
=TEXTJOIN(" ", TRUE, A1, B1, C1)
Analysis & Theory
`TEXTJOIN(" ", TRUE, A1, B1, C1)` joins with a space and ignores blanks.
Which of the following is NOT a valid argument type for `CONCAT`?
Analysis & Theory
`CONCAT` does not support delimiters or skipping blanks — use `TEXTJOIN` for that.
If cell A1 = 'Excel' and B1 = 'Rocks', what does `=CONCAT(A1," ",B1)` return?
Analysis & Theory
It inserts a space between `A1` and `B1`, resulting in `Excel Rocks`.
How many arguments can the `CONCAT` function take?
Analysis & Theory
Unlike `CONCATENATE` (which was limited to 255), `CONCAT` can handle **more than 255** arguments.
What happens if a referenced cell is empty in `CONCAT`?
C
It skips the cell with no warning
D
It includes it as a blank
Analysis & Theory
`CONCAT` includes the empty cell as a blank in the result.