MCQ
Q.
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?
Correct Answer: A
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.
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.