DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Combine and centre the content of the selected cell
|
|
|
Combine and centre the content of the current row
|
|
|
Concatenate the text of the two cells and returns the text
|
|
|
None of the above
|
Detailed explanation-1: -Excel has a unique button called “Merge & Center, ” which is used to merge two or more different cells. When data is inserted into any merged cells, it is in the center position; thus, the name “Merge & Center.” On re-clicking on the button, it unmerges the cells.
Detailed explanation-2: -On the Home tab, in the Editing group, click Fill > Justify. This will move the contents of the selected cells to the top-most cell. Click Merge and Center or Merge Cells, depending on whether you want the merged text to be centered or not.
Detailed explanation-3: -To merge a group of cells: To merge a group of cells and center the text, you can also use the Merge and Center button on the Excel tool bar. Again, this will only preserve the text in the upper-leftmost cell. Highlight or select a range of cells.
Detailed explanation-4: -Right-click the selected cells and click Merge Cells.