USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
drag and drop
|
|
|
autofit
|
|
|
auto adjust
|
|
|
None of the above
|
Detailed explanation-1: -Changing the column width in Excel automatically You can quickly adjust the column width to accommodate the longest entry. Select any column from the worksheet. From the Cells group on the Home tab, choose Format. Select AutoFit Column Width to set that column to auto-fit the width depending on the contents.
Detailed explanation-2: -To fit the columns to the text (or page margins if cells are empty), click [AutoFit] > select “AutoFit Contents.” To fit the table to the text, click [AutoFit] > select “AutoFit Window.” To keep Word from automatically adjusting your column size, click [AutoFit] > select “Fixed Column Width."
Detailed explanation-3: -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.