Home / Computer Fundamentals / MS Excel :: Discussion

Discussion :: MS Excel

  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?

  2. A.

     Custom List


     Auto Fill Options


     Fill Across Worksheet


     Fill Series

    View Answer


    Answer : Option A

    Explanation :

    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.

Be The First To Comment