Consider the following statement about MATCH() function of MS -Excel 2010:
P: It searches for a specified item in a range of cells, and then returns the relative position of that item in the range.
Q: The MATCH function syntax is MATCH(lookup_value, lookup_array, [match_type])
R: All the arguments in a MATCH() function are required.
Which of the following statement(s) is/are true
1.Only Q
2.All P, Q, R
3.Only P and R
4.Only P and Q
Correct Answer : 4
Solution :
The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range. For example, if the range A1:A3 contains the values 5, 25, and 38, then the formula =MATCH(25,A1:A3,0) returns the number 2, because 25 is the second item in the range
SSC CGL Tier II Previous Year Papers
Attempt SSC CGL Tier II PYPs, get detailed solutions
SSC CGL Tier II New Pattern Mock Test
Attempt SSC CGL Tier II Mocks in Latest Pattern
Create a free Oliveboard account to access all PYQs with solutions & video explanations
Study Notes
Category
