DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -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-2: -Excel Autofit Function: Change Column Width Automatically In the “Format” box from earlier, there is a built-in “Autofit Column Width” option to pick from in the cell size group.
Detailed explanation-3: -Which of the following is true about changing worksheet column width? In Normal view, the Column Width dialog box lets you set the exact number of characters that will fit in the column.
Detailed explanation-4: -Excel’s AutoFit feature is designed to automatically resize cells in a worksheet to accommodate different sized data without having to manually change the column width and row height. AutoFit Column Width-changes the column width to hold the largest value in the column.