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
Correct Answer: Custom List
Use a Custom list to sort or fill in a user-defined order. Excel provides day-of-the-week and month-of-the year built-in lists, but we can also create your own custom list.For Excel 2010 and later, click File > Options > Advanced > General > Edit Custom Lists.
For Excel 2007, click the Microsoft Office Button Office button > Excel Options > Popular >Top options for working with Excel > Edit Custom Lists.