You want to set such that when you type ‘Baishakh’ and drag the fill handle,…
2019
You want to set such that when you type ‘Baishakh’ and drag the fill handle, Excel should produce ‘Jaistha, 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
- E.
None of these
Attempted by 482 students.
Show answer & explanation
Correct answer: A
To generate a sequence like 'Baishakh, Jaistha, Aashadh' when dragging the fill handle in Excel, you need to set up a Custom List. First, go to the 'File' menu, select 'Options', then 'Advanced', and click on 'Edit Custom Lists'. In the Custom Lists dialog, enter the month names in the desired order (e.g., Baishakh, Jaistha, Aashadh, etc.). Click 'Add' to save the list. After this, when you type 'Baishakh' in a cell and drag the fill handle, Excel will automatically fill the subsequent cells with the next months in the sequence.