You can set Excel in Automatic or Manual calculation mode. If it is in manual mode which key you will press to update the formula values?
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 |