MO-211 practice question 15 of 35
What is the function of the CONCATENATE function in Excel?
Full set: 355 questionsDomain Insert tables, charts, SmartArt, 3D models, and media
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.
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.
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.")
Keep practicing
Take the free MO-211 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MO-211 practice questions
- Question 1What formula can be used to calculate the sum of a range of cells in Excel?
- Question 2Which chart type is best used to display trends over time?
- Question 3What is the formula used in Excel to calculate the percentage change between two numbers?
- Question 4What is a slicer in Excel?
- Question 5What is the shortcut key to insert a new worksheet in Excel?
- Question 6What is the shortcut key for copying a formula in Excel?
