Which Excel function is used to combine text from multiple cells with a delimiter?
Answer: Option B
TEXTJOIN combines text with a specified delimiter and can ignore empty cells.
1
What does the SORTBY function do?
2
Which function returns a dynamic array of random numbers between 0 and 1?
3
Which function helps link to another workbook in Excel?
4
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 |