DATABASE FUNDAMENTALS
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: -On a new worksheet, the default width of all columns is 8.43 characters, which corresponds to 64 pixels.