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. fest
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
Show answer & explanation
Correct answer: D
Explanation
The correct answer is Option 4 i.e. Only P and Q
- The correct statements about the MATCH() function in MS-Excel 2010 are:
- 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 not required.
- So, two statements P and Q are true. The MATCH() function is used to find the relative position of an item in a range, and it requires three arguments: lookup_value, lookup_array, and an optional match_type