DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Custom List
|
|
|
Auto Fill Options
|
|
|
Fill Across Worksheet
|
|
|
Fill Series
|
Detailed explanation-1: -You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that? Use a Custom list to sort or fill in a user-defined order.
Detailed explanation-2: -Click File > Options. In the Advanced category, under Editing options, select or clear the Enable fill handle and cell drag-and-drop check box.
Detailed explanation-3: -You can quickly copy formulas into adjacent cells by using the fill handle. When you drag the handle to other cells, Excel will show different results for each cell.
Detailed explanation-4: -In Microsoft Excel, a fill handle is a feature to extend (and fill) several numbers, dates, or even text to other cells. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom-right corner, as shown in the image.