MO-211 practice question 15 of 35

What is the function of the CONCATENATE function in Excel?

Full set: 355 questions

Domain Insert tables, charts, SmartArt, 3D models, and media

Answer options
A: It performs a conditional fill.
B: It combines two or more text strings into one. Correct answer
C: It calculates the average of a range of numbers.
D: It creates a new worksheet.
Correct Answer:
B. It combines two or more text strings into one.
Explanation

The CONCATENATE function in Microsoft Excel is a text function used to join two or more text strings into a single string. The items to be joined can be text strings, numbers, or cell references. While this function is still available for backward compatibility, Microsoft recommends using the CONCAT function or the ampersand (&) operator for newer versions of Excel, as they offer more flexibility. The primary purpose remains the same: combining separate pieces of text into one.

Why Incorrect

A. Conditional fill is managed through Conditional Formatting rules, which change a cell's appearance based on specified criteria, not by the CONCATENATE function.
C. The AVERAGE function is used to calculate the arithmetic mean of a range of numbers, a completely different operation from text manipulation.
D. Creating a new worksheet is a user interface action or a task performed via VBA (Visual Basic for Applications), not a result of a cell formula like CONCATENATE.

References

1. Microsoft Corporation. (n.d.). CONCATENATE function. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/concatenate-function-8f8ae884-2ca8-4f7a-b093-75d702bea31d (Refer to the "Description" section, which states, "The CONCATENATE function joins up to 255 text strings into one text string.")

2. University of California, Berkeley Library. (n.d.). Excel: Formulas & Functions. LibGuides. Retrieved from https://guides.lib.berkeley.edu/excel/formulas-functions (Under the "Text Functions" section, CONCATENATE is defined as: "Joins several text strings into one text string.")

3. Indiana University. (2023, October 10). Combine text from two or more cells into one cell in Excel. University Information Technology Services (UITS) Knowledge Base. Retrieved from https://kb.iu.edu/d/aifc (This document explicitly describes using the CONCATENATE function and the & operator to "combine text from multiple cells into one cell.")

Scroll to Top