Consider the following statements about the 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?

Question

Consider the following statements about the 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?

Accepted Answer

**Solution:**

1. Statement P is correct because the MATCH function searches for a specified item in a range of cells and returns the relative position of that item within the range.

2. Statement Q is correct as the syntax of the MATCH function is:
   $$	ext{MATCH}(	ext{lookup_value}, 	ext{lookup_array}, [	ext{match_type}])$$
   Here, the square brackets indicate that the third argument, *match_type*, is optional.

3. Statement R is incorrect because not all arguments are required. Specifically, the *match_type* argument is optional.

**Answer:** Only P and Q

Answer

Answer

Answer