In the following spreadsheet, which of the formulae below would be best for…

PYQ UGC NET 2022

In the following spreadsheet, which of the formulae below would be best for cell C2? Note that the formula must be able to be copied down from C2 to both C3 and C4.

A

B

C

1

Lunch Cost (Rs.)

Dinner Cost (Rs.)

Total Cost (Rs.)

2

15

27

42

3

23

35

58

4

10

35

45

  1. A.

    = A$2 + $B2

  2. B.

    = $A$2 + B2

  3. C.

    = $A$2 + $B$2

  4. D.

    = $A2 + $B2

Attempted by 6 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…