USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Wrap Text
|
|
|
Merge and Center
|
|
|
Shrink to Fit
|
|
|
Number Formatting
|
Detailed explanation-1: -Merge Across: This option combines the selected cells in each row individually. Merge Cells: This option joins the selected cells into a single cell without entering the text in the cell. Merge and Center: This option enables us to merge the cell and align the text into the center.
Detailed explanation-2: -Select the range of cells over which you want to center text. Right-click the selected cells, and then click Format Cells. Click the Alignment tab. In the Horizontal list, click Center Across Selection.
Detailed explanation-3: -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-4: -Right click on the selected area and click Format Cells. Click the Alignment tab at the top of the pop-up menu. In the Alignment tab, open the Horizontal dropdown and select Center Across Selection. Click OK to finalize and the cells will appear merged.
Detailed explanation-5: -Merge Cells – Merges the range into a single cell, but will not horizontally center the content. Merge & Center – Merges the range of cells into one cell and horizontally centers the content. Merge Across – Merges each row in the selected range across the columns in the range.