SarkariPYQ

SSC CGL 2023 PYQ — Question 148

SSC CGL Tier II - 7 March 2023 - Shift 1 • Computer • Q148

Back to paper

What will the function given below return in MS-Excel 2010?
=MATCH(12,{10,13,30,40,60},1)

Show answer & explanation

Correct answer: B

Explanation

The correct answer is 1 i.e.

  • The function you've provided in MS-Excel 2010 is the MATCH function, which is used to search for a specified value in a range of cells and return the relative position of that item within the range.
  • In this case, the function: =MATCH(12, {10, 13, 30, 40, 60}, 1) It will return the result of 3.
  • The number 12 is being searched for in the array {10, 13, 30, 40, 60}, and the third item in the array is the first item that is greater than or equal to 12. Therefore, the function returns 3, indicating that 12 is found at the third position in the array.
  • The "1" in the function specifies that the array should be in ascending order