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.

  1. A.

    11 and 10

  2. B.

    9 and 10

  3. C.

    11 and 11

  4. D.

    10 and 10

Attempted by 9 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…