USING MICROSOFT EXCEL
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: -Select the column or columns that you want to change. 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: -Select a column or a range of columns. On the Home tab, select Format > Column Width (or Column Height). Type the column width and select OK.
Detailed explanation-4: -Once you have the columns selected, simply press Alt + O, C to autofit the column widths. Excel will automatically adjust the width of each column so that all the data fits within the cells. You can also use this shortcut to adjust the row height in Excel.