Discussion
In MS Excel, what does the Wrap Text option do?
Answer: A
Correct answer: Displays long text on several lines within the same cell
Wrap Text makes long content display on several lines inside its own cell, increasing the row height to fit. The cell’s value is unchanged; only its display is affected. Without it, text that overflows spills across neighbouring cells if they are empty, and is cut off at the boundary if they are not. That behaviour is often mistaken for data loss, when the content is in fact intact and merely hidden. Alt + Enter inserts a line break at a chosen point within a cell, which gives control over where the text divides rather than leaving it to the column width. The neighbouring option, Shrink to fit in the Format Cells dialogue, is the third answer here: it reduces the displayed font size instead of wrapping. Orientation, on the Home tab, rotates text and is the fourth. Merge and Centre sits beside Wrap Text and is best avoided in data ranges, since merged cells break sorting, filtering and many formulas.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development