Multiple choice technology

which of the following statement is true?

  1. indirect function is like a pointer, which returns the value of its address

  2. indirect function indirectly refers the CPU memmory

  3. Indirect function directly referes the CPU memmory

  4. Indirect function refers the CPU and Server Memmory
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The INDIRECT function returns the value specified by a reference string, acting like a pointer to a cell address. For example, INDIRECT("A1") returns the value in cell A1. Options B, C, and D incorrectly mention CPU memory - INDIRECT works with spreadsheet cell references, not system memory.

Keep practicing — related questions