General Intelligence · Computer Awareness
Consider the following statements about the MATCH() function in Microsoft Excel: 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 syntax is MATCH(lookup_value, lookup_array, [match_type]). R: All the arguments in a MATCH() function are mandatory. Which of the statement(s) given above is/are true?
- 1Only P and Q✓
- 2Only P and R
- 3All P, Q, and R
- 4Only Q
Correct answer
Only P and Q
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Preparing for General Intelligence?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on Computer Awareness?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in General Intelligence · Computer Awareness