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?
Answer: Option A
1
Which Excel function is used to combine text from multiple cells with a delimiter?
2
What does the SORTBY function do?
3
Which function returns a dynamic array of random numbers between 0 and 1?
4
Which function helps link to another workbook in Excel?
5
Which tab in Excel contains the 'Get & Transform Data' tools?
| MS Excel MCQs | Computers and IT |
| Computer Fundamentals MCQ | Operating System MCQs |
| MS Word MCQs | C Programming MCQs |
| Database MCQs | Data Structures & Algorithms MCQs |
| Computer Networking MCQs |