DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Double click on the line between the column headings.
|
|
|
Wrap text
|
|
|
Merge cells
|
|
|
None of the answers
|
Detailed explanation-1: -On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Column Width. Note: To quickly autofit all columns on the worksheet, click the Select All button, and then double-click any boundary between two column headings.
Detailed explanation-2: -AutoFit columns and rows with a double-click The easiest way to auto fit in Excel is by double-clicking the column or row border: To autofit one column, position the mouse pointer over the right border of the column heading until the double-headed arrow appears, and then double click the border.
Detailed explanation-3: -Simply select the column(s) you want to adjust, then press Alt + O, W. This shortcut will automatically adjust the width of the selected column(s) so that all the data fits within the cells.
Detailed explanation-4: -To check this, go to File > Options > Advanced. Scroll down to the “Editing options” section and make sure “Enable automatic resizing of cells” is checked. If it’s not, check it and try double-clicking on a column header again.