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 retur...

SSC SSC CGL Tier 2 Easy Windows OS Basics MCQ

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?

Only Q

All P, Q, R

Only P and R

Only P and Q

match functionms excelexcel functionsfunction syntaxoptional arguments

Get instant feedback with detailed step-by-step solution