USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Merge and Center
|
|
|
Wrap Text
|
|
|
Orientation
|
|
|
Border
|
Detailed explanation-1: -> Format Cell Alignment. Under Orientation on the right side, in the Degrees box, use the up or down arrow to set the exact number of degrees that you want to rotate the selected cell text.
Detailed explanation-2: -Explanation: In MS Excel, the ‘Orientation’ feature is used to rotate the text diagonally or vertically of the selected cells.
Detailed explanation-3: -Rotate Text Using Ribbon Alignment Options Select all the cells (that has the headers) Click the Home tab. In the Alignment group, click the ‘Orientation’ icon. In the options that show up, click on the ‘Angle Counterclockwise’ option.
Detailed explanation-4: -In other words, you can choose the location of the text i.e towards the center, right, left, top, or bottom of the cell. Let’s see how. First, select the cell→Home→Alignment→Orientation→Format Cell Alignment. Now you have 2 options Horizontal & Vertical and click on the little drop-down arrow.