Consider the following MS-EXCEL function entered in cell C1: =IF(A1>B1, 1,…
PYQ UGC NET 2024
Consider the following MS-EXCEL function entered in cell C1:
=IF(A1>B1, 1, IF(A1=10, 2, IF(A1<B1, 3, 4)))
The above function will return a value of 4 in cell C1 if the values in cell A1 and cell B1 are ______ respectively.
- A.
11 and 10
- B.
9 and 10
- C.
11 and 11
- D.
10 and 10
Attempted by 9 students.
Sign up free to check your answer
Sign up freeLoading lesson…

