DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -To change the width of columns to fit the contents, select the column or columns that you want to change, and then double-click the boundary to the right of a selected column heading. To change the width of all columns on the worksheet, click the Select All button, and then drag the boundary of any column heading.
Detailed explanation-2: -Change All Column Widths in a Worksheet Using the Mouse Select the double-headed arrow and drag to the right to widen all columns in the worksheet or to the left to make all columns narrower.
Detailed explanation-3: -You can also use this shortcut to adjust the width of multiple columns at once. 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: -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).