FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which dialog box in Microsoft Excel is used to set the rotation of text in a cell to a specific degree?
A
Alignment
B
Format Cells
C
Format Text
D
Orientation
Explanation: 

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. Positive numbers rotate the text upward.

Detailed explanation-2: -On the Home tab, in the Alignment group, click Orientation. You can also find this option by right-clicking the selected cell or cells and selecting Format Cells from the drop-down menu. Then, in the Alignment tab, click Orientation. From the drop-down menu, select the angle at which you want to rotate the text.

Detailed explanation-3: -Alignment Tab. You can position text and numbers, change the orientation and specify text control in cells by using the Alignment tab in the Format Cells dialog box.

Detailed explanation-4: -For example, if you want to rotate text counterclockwise, press O. Likewise, if you want to rotate the text clockwise, press L. Thus, the shortcut to rotate text in Excel is Alt+H and then F, Q, and O (Alt+H+F+Q+O).

Detailed explanation-5: -The Format Cells dialog box is where you set the formatting options for your report objects. You can format the number, font, alignment, border, and pattern for a row or column header and the values.

There is 1 question to complete.