FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
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?
A
Custom List
B
Auto Fill Options
C
Fill Across Worksheet
D
Fill Series
Explanation: 

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: -Fill Handle is a feature in Excel that enables you to auto-complete a list in a row/column by simply dragging it using your mouse.

There is 1 question to complete.