DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
the best width for a column
|
|
|
the best height for a row
|
|
|
either the best width for a column or best height for a row
|
|
|
the best height for a column
|
Detailed explanation-1: -AutoFit Column Width-changes the column width to hold the largest value in the column. AutoFit Row Height-adjusts the column width to match the largest value in the row. This option expands the row vertically to hold multi-line or extra-tall text.
Detailed explanation-2: -On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Row Height. Tip: To quickly autofit all rows on the worksheet, click the Select All button, and then double-click the boundary below one of the row headings.
Detailed explanation-3: -AutoFit is a feature in Excel that allows you to quickly adjust the row height or column width to fit the text completely (so that there is no spilling over to other cells). Also, AutoFit means that you don’t have to manually specify the column width or row height (or manually drag and adjust the column width).