Which function helps to spill array results across cells?
Answer: Option D
All these functions can return arrays and cause spilling in dynamic array enabled Excel versions.
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 |