DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Align Left
|
|
|
Align Right
|
|
|
Merge and Center
|
|
|
Justify
|
|
|
Center
|
Detailed explanation-1: -Hit H to select the Home tab. Press M to switch to Merge & Center. Press one of the following keys: C to merge and center the selected cells.
Detailed explanation-2: -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-3: -Merge and Center Cells Step 1: Select the cells that need to merge. Step 2: On the “Home” ribbon, locate the “Merge & Center” menu and select “Merge & Center” from the dropdown list. Select Merge & Center from the dropdown list. Step 3: The selected cells will merge, and the data will be placed in the center.