A teacher has created a spreadsheet of test marks of five students. She has…

PYQ UGC NET 2022

A teacher has created a spreadsheet of test marks of five students. She has written a formula =HLOOKUP(B4, DD1:KK2, 2) in cell C4 and copies this formula from cell C4 to the range C5:C8. What values will be returned by the formulae in the range C4:C8?

A

B

C

D

E

F

G

H

I

J

K

1

0

9

14

19

27

33

40

47

2

U

G

F

E

D

C

B

A

3

Name

Marks

4

Anil

43

=HLOOKUP(B4, DD1:KK2, 2)

5

Amit

85

6

Varun

35

7

Anita

20

8

Harish

10

  1. A.

    A, C, E, G and F, respectively

  2. B.

    B, C, E, G and U, respectively

  3. C.

    A, C, E, F and U, respectively

  4. D.

    B, A, C, E and G, respectively

Attempted by 5 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…