Which Excel 365 feature allows filtering a range with multiple conditions?
Answer: Option C
FILTER function lets you extract data based on dynamic conditions.
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 |