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 of the folowing is used to write multiple lines in a cell?
A
Shrink to fit
B
Wrap text
C
Merge Cells
D
Orientation
Explanation: 

Detailed explanation-1: -Press Alt + Enter to add another line to the cell. Tip. Keep pressing Alt + Enter until the cursor is where you would like to type your next line of text. Type the next line of text you would like in the cell.

Detailed explanation-2: -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-3: -1. In Microsoft Excel and other spreadsheet programs, Wrap Text is a feature that shows all information in a cell, even if it overflows the cell boundary.

Detailed explanation-4: -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.

There is 1 question to complete.