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, 1:2, 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, 1:2, 2) | ||||||||
5 | Amit | 85 | |||||||||
6 | Varun | 35 | |||||||||
7 | Anita | 20 | |||||||||
8 | Harish | 10 |
- A.
A, C, E, G and F, respectively
- B.
B, C, E, G and U, respectively
- C.
A, C, E, F and U, respectively
- D.
B, A, C, E and G, respectively
Attempted by 5 students.
Sign up free to check your answer
Sign up freeLoading lesson…

