Question
In Microsoft Excel, what does the function VLOOKUP
do?Solution
VLOOKUP searches for a value in a specified column and returns a corresponding value from another column. It is commonly used for looking up information in tables.
Direction: Which of the following will replace ‘?’ in the given question?
342, ‘?’, 420, 462, 506, 552, 60
There are three series given below which are following with the same pattern.
Series I: 1, 12, 38, 193, 1355
Series II: 6, B, C, D, E
...640Â Â Â Â 322Â Â Â Â Â 164Â Â Â Â Â Â 86Â Â Â Â Â 48Â Â Â Â Â ?
...10                          15                          ?                    �...
Choose the correct alternative
21: 3 ∷ 574: ?
35    57    101    189    ?     717
23   27    54    ?       195    231
...800 400 600 1500 ? 23625
...13Â Â Â Â Â Â Â Â Â Â 182Â Â Â Â Â Â Â Â 303Â Â Â Â Â Â Â Â 384Â Â Â Â Â Â Â Â 433Â Â Â Â Â Â Â Â ?
...6 16 ? 244 1,245 7,506 52,591