Menu
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
    B.

     Auto Fill Options
    C.

     Fill Across Worksheet
    D.

     Fill Series

    View Answer

    Workspace

    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.

Write your comments here:

Be The First To Comment