Assertion (A): In MS Excel, the VLOOKUP function can be used to find and retrieve data from a specific column in a table.
Reason (R): VLOOKUP is an abbreviation of 'Vertical Lookup.'
1
Both (A) and (R) are true, and (R) is the correct explanation of (A)
2
Both (A) and (R) are true, but (R) is not the correct explanation of (A).
3
(A) is true, but (R) is false.
4
(A) is false, but (R) is true.