Free Microsoft MO-211 Actual Exam Questions - Question 15 Discussion

What about thinking of CONCATENATE as joining words side-by-side? That rules out everything but B.

It’s definitely B. The function’s name itself hints at joining or linking things together, which fits combining text strings perfectly. A, C, and D don’t really relate to what CONCATENATE is known for—no calculations or sheet creation involved here. So no need to overthink it.

Makes sense to skip A, C, and D since CONCATENATE clearly deals with text, not numbers or sheets. B fits perfectly as it joins multiple text strings. So, B it is.

B The CONCATENATE function is all about joining text, so it can’t be about averages or sheets. That rules out pretty much everything except B.

B/D? D doesn’t make sense since adding sheets is unrelated, and A and C are about calculations, not text. So it's definitely B, combining text strings.

Besides the obvious link between CONCATENATE and joining text, I’d also rule out A, C, and D because none of those deal with text manipulation. Conditional fill, averages, and creating worksheets are totally unrelated to what CONCATENATE does. So it’s got to be about combining text strings. But is the question testing knowledge on the old function name or the updated Excel functions?

It’s B because CONCATENATE literally means joining text pieces together, so it can’t be about averages or sheets. Options A, C, and D don’t match the idea of combining strings at all.

Maybe B, since CONCATENATE is known for joining text strings. The other options don’t really fit what CONCATENATE does in any Excel version.

Maybe D can be ruled out right away since CONCATENATE definitely doesn’t create new sheets. And C’s about averages, so no. Between A and B, B clearly matches the idea of joining text strings, which is what CONCATENATE does. The other options don’t really fit what that function is known for. So yeah, B makes the most sense here.

B, it joins text pieces but you gotta list each cell separately, no ranges.

B. It’s definitely about joining text, not about calculations or worksheet management. A and D are clearly off since they don’t relate to text at all. CONCATENATE doesn’t handle ranges like a sum or average function; it merges individual strings or cell contents into one continuous string.

B - It’s all about merging texts, not calculations or sheets.

Definitely B. CONCATENATE joins text strings together into one cell.