Consider the worksheet below: A B C D E F 1 Data Result 2 -4 3 4 If a user…

PYQ UGC NET 2022

Consider the worksheet below:

A

B

C

D

E

F

1

Data

Result

2

-4

3

4

If a user wants to do the following:

(i) Print 'Within Budget' in cell B3 if the value in cell A2 is less than or equal to 100.

(ii) Print 'Over Budget' in cell B3 if the value in cell A2 is greater than 100; then what formula would the user have to type in order to achieve the above stated goals?

  1. A.

    =IF(A2<100, "Within Budget", "Over Budget")

  2. B.

    =IF(A2=100, "Over Budget", "Within Budget")

  3. C.

    =IF(A2<=100, "Over Budget", "Within Budget")

  4. D.

    =IF(A2<=100, "Within Budget", "Over Budget")

Attempted by 3 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…