FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The correct answer is Option (4). Key PointsThe wrap text feature in Excel can help you fully display longer text in a cell without it overflowing to other cells. “Wrapping text” means displaying the cell contents on multiple lines, rather than one long line.

Detailed explanation-2: -In a worksheet, select the cells that you want to format. On the Home tab, in the Alignment group, click Wrap Text. (On Excel for desktop, you can also select the cell, and then press Alt + H + W.)

Detailed explanation-3: -To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break. Double-click the cell in which you want to insert a line break (or select the cell and then press F2). Click the location inside the selected cell where you want to break the line.

Detailed explanation-4: -Select a cell and enter text; press and hold Alt. Press Enter and release Alt. For more than two lines of text, press Alt+Enter at each line’s end. Wrap existing text: Select the cell, press F2, place the cursor where you want the line broken.

Detailed explanation-5: -Formatting Cell as Wrap Text We can put multiple lines in a cell by formatting it as Wrap Text. This feature adjusts the width of the cell to make all content visible within a cell by displaying it on multiple lines.