Question

The function of Wrap Text icon in MS Excel is
used to
(A) Join selected cells into one larger cell
(B) Rotate text to a diagonal angle
(C) Make all content visible within a cell by
displaying it on multiple lines
(D) Highlight interesting cells​

Answer 1

Option (D) Highlight interesting cells​

The function of Wrap Text icon in MS Excel is used to Highlight interesting cells​.

1. Choose the cells you want to apply conditional formatting to, the table, or the entire sheet.
2. Click Conditional Formatting on the Home tab.
3. Select Text that Contains, then point to Highlight Cells Rules.
4. Click OK after entering the text you want to highlight.

• Before assigning your rule, use "Ctrl-A" to apply an If-Then rule to all cells. When values from coloured cells are copied and pasted into uncolored cells, the uncolored cells take on the colour of the copied cell.

#SPJ3

Answer 2

Answer:

The answer is option [D]

Highlight interesting cells​

Explanation:

Wrap Text is a feature in Microsoft Excel as well as other spreadsheets programmes that displays all the data in a cell, even if it extends beyond the cell boundary. For instance, the graphic demonstrates that text in cell G2 is truncated since text is present in adjacent cell H2. To force the text to move onto the next line if entire words couldn't be read, cell G3's Wrap Text function is enabled.

Select the cells and then choose the Wrap Text item on the menu in the Layout area of the Home tab of the menu bar to wrap text in one or more Excel cells.

By highlighting the cell and pressing the Wrap Text icon once more, the function can be disabled. You can make a cell larger to display all text if you don't like how text wrapped around it looks. Change the width and height of a spreadsheets column or row for assistance with changing a cell's size.

Word wrap and other text that moves to the next line without clicking the Enter key are also examples of wrap text.

#SPJ2