FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To automatically wrap the text (multiple lines) into the cell as soon as it reaches its end, use the command:
A
Format as Table
B
Format Painter
C
Wrap Text
D
Merge & Center
Explanation: 

Detailed explanation-1: -Wrap text automatically 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.) Notes: Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically.

Detailed explanation-2: -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-3: -The correct answer is Word Wrap. Word Wrap is the tool used to wrap text to the next line as it reaches the right margin in MS Word. When the right margin is reached while typing, a word processor’s Word Wrap feature will automatically force content to a new line.

Detailed explanation-4: -Explanation: In MS Excel, ‘Wrap Text’ feature is used to wrap extra-long text into multiple lines so that you can see all text.

There is 1 question to complete.