Paper 1 · ICT
UGC NET December 2023 (11.12.2023) Shift-I
Which VLOOKUP formula in MS-Excel, when entered into cell L2 and then dragged to cell L5, returns the average number of calls for the representative IDs listed in column J?
A= VLOOKUP(A2, J2:L5, 1, FALSE)
B= VLOOKUP(J2, A$2:C$7, 1, FALSE)
C= VLOOKUP(J2, A$2:C$7, 3, FALSE) ✓ Correct
D= VLOOKUP(J2, A2:C7, 3, FALSE)
Correct answer: (C) = VLOOKUP(J2, A$2:C$7, 3, FALSE) — The correct formula is VLOOKUP of J2 in A$2:C$7, column 3, FALSE, so that is the answer.
Explanation
★The correct formula is VLOOKUP of J2 in A$2:C$7, column 3, FALSE, so that is the answer.
★VLOOKUP searches for a value down the first column of a range.
★The lookup value is the representative ID in J2.
★The table range A$2 to C$7 is fixed with dollar signs so it does not shift when dragged.
★The average number of calls sits in the third column of that range.
★FALSE requires an exact match, so the formula returns the correct average.
Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.
Shared by Mcqkart · via Mcqkart.in