DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
AutoCorrect
|
|
|
AutoFit
|
|
|
Format
|
|
|
Format as Table
|
Detailed explanation-1: -Double-clicking the right edge of a column heading activates the auto size feature which automatically re-sizes the column to accommodate the widest entry in the column.
Detailed explanation-2: -To quickly adjust the row height or column width, use a double-click shortcut. Double-click to adjust the height of all the selected rows.
Detailed explanation-3: -There are several easy ways to adjust column width. The first way is by double-clicking the column border. This automatically modifies the column to fit the text it contains.
Detailed explanation-4: -To AutoFit column width: The AutoFit feature will allow you to set a column’s width to fit its content automatically. Position the mouse over the column line in the column heading so the cursor becomes a double arrow. Double-click the mouse. The column width will be changed automatically to fit the content.
Detailed explanation-5: -Select one or more columns that you wish to resize. To select all columns, press Ctrl + A or click the Select All button. On the Home tab, in the Cells group, click Format > Column Width. In the Column width box, type the desired number, and click OK.