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

Answer: Option A

Solution(By Examveda Team)

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.

Join The Discussion

Related Questions on MS Excel