USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
format cell
|
|
|
merge & center
|
|
|
wrap text
|
|
|
format as table
|
|
|
number
|
Detailed explanation-1: -Step 1: Highlight all the cells you want to merge within the row. Step 2: Under the Home tab, click the ‘Merge’ icon and choose ‘Merge Across. ‘ Step 3: The cells merge across the entire highlighted area.
Detailed explanation-2: -You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.
Detailed explanation-3: -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-4: -The fastest and easiest way to combine two or more cells in Excel is to use the built-in Merge and Center option. The whole process takes only 2 quick steps: Select the contiguous cells you want to combine. On the Home tab > Alignment group, click the Merge & Center.