Format the data in cell B4 as follows to display all of the text:

Question

8. Merge the cells in the range B4:B14.

b. Rotate the text up in the merged cell so that the text reads from bottom to top.

C. Middle-align and center the text.

d. Remove the border from the merged cell.

e. Resize column B to a width of 6.00.

Answer 1

1. Select the range B4:B14 by clicking and dragging from B4 to B14.

2. Right-click on the selected range and click on "Merge cells".

3. With the merged cell selected, go to the "Alignment" section in the toolbar.

4. Click on the button with two arrows pointing up and down to rotate the text.

5. Click on the button with lines and arrows pointing towards the center to middle-align and center the text.

6. Click on the "Borders" dropdown menu in the toolbar and select "No border" to remove the border from the merged cell.

7. Right-click on the column header for column B (or click and drag to select the header) and click on "Resize column" in the dropdown menu.

8. In the "Resize column" dialog box, change the width value to 6.00 and click "OK" to resize column B.