Class 6 Exam  >  Class 6 Questions  >  You want to set such that when you type Baish... Start Learning for Free
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
Correct answer is option 'A'. Can you explain this answer?
Most Upvoted Answer
You want to set such that when you type Baishakh and drag the fill han...
Custom List
1. Create a Custom List: In Excel, you can create a custom list to specify the order in which values should be filled when using the fill handle.
2. Access Custom Lists: Go to File > Options > Advanced. Scroll down to the General section and click on "Edit Custom Lists".
3. Enter Values: In the Custom Lists dialog box, enter the values Baishakh, Jestha, Aashadh, and so on in the List entries box.
4. Save the List: Click on "Add" to save the custom list.
5. Using the Custom List: Now, when you type Baishakh in a cell and drag the fill handle, Excel will automatically fill in Jestha, Aashadh, and the rest of the values from your custom list.
By creating a custom list in Excel, you can easily fill in a series of values in a specific order without having to manually type each value. This can save time and ensure accuracy when working with data that follows a specific sequence.
Free Test
Community Answer
You want to set such that when you type Baishakh and drag the fill han...
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.
Explore Courses for Class 6 exam
Question Description
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 Listb)Auto Fill Optionsc)Fill Across Worksheetd)Fill SeriesCorrect answer is option 'A'. Can you explain this answer? for Class 6 2025 is part of Class 6 preparation. The Question and answers have been prepared according to the Class 6 exam syllabus. Information about 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 Listb)Auto Fill Optionsc)Fill Across Worksheetd)Fill SeriesCorrect answer is option 'A'. Can you explain this answer? covers all topics & solutions for Class 6 2025 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for 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 Listb)Auto Fill Optionsc)Fill Across Worksheetd)Fill SeriesCorrect answer is option 'A'. Can you explain this answer?.
Solutions for 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 Listb)Auto Fill Optionsc)Fill Across Worksheetd)Fill SeriesCorrect answer is option 'A'. Can you explain this answer? in English & in Hindi are available as part of our courses for Class 6. Download more important topics, notes, lectures and mock test series for Class 6 Exam by signing up for free.
Here you can find the meaning of 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 Listb)Auto Fill Optionsc)Fill Across Worksheetd)Fill SeriesCorrect answer is option 'A'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of 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 Listb)Auto Fill Optionsc)Fill Across Worksheetd)Fill SeriesCorrect answer is option 'A'. Can you explain this answer?, a detailed solution for 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 Listb)Auto Fill Optionsc)Fill Across Worksheetd)Fill SeriesCorrect answer is option 'A'. Can you explain this answer? has been provided alongside types of 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 Listb)Auto Fill Optionsc)Fill Across Worksheetd)Fill SeriesCorrect answer is option 'A'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice 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 Listb)Auto Fill Optionsc)Fill Across Worksheetd)Fill SeriesCorrect answer is option 'A'. Can you explain this answer? tests, examples and also practice Class 6 tests.
Explore Courses for Class 6 exam
Signup to solve all Doubts
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev