USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You have data in 3 cells that are selected and then you click the “Merge and Center” button. What happens next?
|
|
The 3 cells merge and you lose the data except for the 1st cell.
|
|
|
The cells won’t merge with the data in more than 1 cell.
|
|
|
The 3 cells merge and data in the last 2 cells are placed in adjacent cells.
|
|
|
The 3 cells merge and data in all 3 cells are combined in 1 cell.
|
Explanation:
Detailed explanation-1: -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-2: -Click on the “Merge & Center” in Excel to combine the data into one cell. Once you click “Merge & Center, ” selected cells get combined into one cell, and the text comes in centered like the above screenshot.
There is 1 question to complete.