USING MICROSOFT EXCEL
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: -Merging helps combine the data strings of two or more cells. In the process, a single large cell is created from multiple smaller cells. The goal of merging is to improve the presentation of the worksheet.
Detailed explanation-3: -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.