Which Excel function is used to combine text from multiple cells into one cell?

Microsoft Word (38) Microsoft Excel (22) Microsoft PowerPoint (23) Microsoft Access (5) HTML (61) Comptuer Hardware (37) Operating System (25) TSC (50) Software Engineering (4) Computer Network (11)

Microsoft Excel

Which Excel function is used to combine text from multiple cells into one cell?

CONCATENATE()
SUM()
AVERAGE()
MAX()

304

Answer : A) CONCATENATE()

The CONCATENATE() function is used to combine (concatenate) text from multiple cells into a single cell

Join Discussion

Comment *

Please Login to Post a Comment

Sign in with Google

RELATED MCQS

Which Excel function is used to find the position of a specific value within a range?

In Excel, which formula is used to calculate the average of a range of cells that meet specific criteria?

What is the keyboard shortcut to insert a new worksheet in Excel?

What is the purpose of the "Transpose" option in Excel?

What is the keyboard shortcut to create a default chart from the selected data in Excel?

What is the purpose of the Excel function "VLOOKUP"?

Which Excel function can be used to find the largest value in a specified range while ignoring any text values?