USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
+
|
|
|
:
|
|
|
$
|
|
|
&
|
Detailed explanation-1: -You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.
Detailed explanation-2: -Select the cells to merge. Select Merge & Center. Important: When you merge multiple cells, the contents of only one cell (the upper-left cell for left-to-right languages, or the upper-right cell for right-to-left languages) appear in the merged cell. The contents of the other cells that you merge are deleted.
Detailed explanation-3: -Use CONCATENATE, one of the text functions, to join two or more text strings into one string.
Detailed explanation-4: -You can combine two or more cells in the same row or column into a single cell. For example, you can merge several cells horizontally to create a table heading that spans several columns.