SarkariPYQ

SSC CHSL 2023 PYQ — Question 127

SSC CHSL Tier II - 02 Nov 2023 - Shift 1 • Computer • Q127

Back to paper

In MS-Excel 365, you can use, _______ when you want to change a cell reference within a formula without changing the formula itself.

Show answer & explanation

Correct answer: D

Explanation

The correct answer is option 4 i.e, INDIRECT.

  • In Microsoft Excel, the INDIRECT function is indeed used when you want to change a cell reference within a formula without directly changing the formula itself.
  • The INDIRECT function allows you to create a cell reference indirectly by using a text string that contains the address of the cell you want to refer to. This can be particularly useful when you need to dynamically reference cells based on certain conditions or criteria.