ENTREPRENEURSHIP AND THE GLOBAL ECONOMY
EXPORTING AND IMPORTING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
moves them over one cell
|
|
|
combines multiple cells into one
|
|
|
adds a cell in the middle of a row
|
|
|
adds the cell contents
|
Detailed explanation-1: -Select the cell where you want to put the combined data. Type =CONCAT(. Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text. Close the formula with a parenthesis and press Enter.
Detailed explanation-2: -Select the cells you want to merge together. Click the Merge list arrow. Select a merge option.
Detailed explanation-3: -You can combine two or more table cells located 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. Select the cells that you want to merge. Under Table Tools, on the Layout tab, in the Merge group, click Merge Cells.
Detailed explanation-4: -Merge Cells in Excel Without Losing the Data If you don’t want any separator, you can simply leave it out and use the formula =CONCATENATE(A1, B1). Alternatively, you can use any other separator such as comma or semi-colon. This result of the CONCATENATE function is in a different cell (in C1).