SarkariPYQ

SSC CGL 2023 PYQ — Question 143

SSC CGL Tier II - 2 March 2023 - Shift 1 • Computer • Q143

Back to paper

Which of the following is correct option in MS-Excel 365, if a value in a cell of column A and row 10 is to be referred in a function or formula?

Show answer & explanation

Correct answer: C

Explanation

The correct answer is option 3 i.e. A10.

  • To refer to a value in a cell in MS Excel 365, if you want to reference a value in a cell located in column A and row 10, you should use the following format in a function or formula: =A10
  • This notation specifies that you are referencing the value in cell A10, where 'A' represents the column and '10' represents the row.
  • You can replace 'A' and '10' with the appropriate column and row identifiers for the cell you want to refer to in your formula.