USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The text is cut off when the adjacent cell is used.
|
|
|
The text automatically wraps.
|
|
|
The cell will automatically widen.
|
|
|
The cell will show “#” signs.
|
Detailed explanation-1: -When long text doesn’t fit on one page in a cell, its adjacent cell text is clipped. It is expected that “Max Height” text renders in a left cell. Instead there is nothing. This happens only when large cell spand more than one page.
Detailed explanation-2: -By default, when you create a new workbook in Excel, the row height and column width for all cells are set to the same value. If the text you enter in a spreadsheet cell is too long and the next column has data, it either spills over into the next blank cell or is truncated by the data in the adjacent cells.
Detailed explanation-3: -To enable the row to adjust automatically and show all wrapped text, on the Format menu, point to Row, and then click AutoFit.
Detailed explanation-4: -You can select the cells > Home > click Wrap Text, the text in the selected cell wraps to fit the column width. When you change the column width, text wrapping adjusts automatically.