state gov Beltron Data Entry Operator - DEO Mock Test Series 2024 Computer Awareness Microsoft Office
Match the following MS Excel formula:
| Excel Function/Operation | Output |
| a. =LEFT("Microsoft Excel", 6) | i) 26 |
| b. =LOWER("HELLO WORLD") | ii) 123.46 |
| c. =SUM(10, 5, 11) | iii) hello world |
| d. =AVERAGE(100, 120, 150) | iv) Micros |
1
a - iv, b - iii, c - ii, d - i
2
a - iv, b - i, c - iii, d - ii
3
a - iii, b - iv, c - i, d - ii
4
a - iv, b - iii, c - i, d - ii