All of the following statements are TRUE regarding the INDIRECT function EXCEPT:
A)The INDIRECT function can change a text string within a cell to a cell reference.
B)The INDIRECT function has three arguments.
C)The INDIRECT function's first argument is usually a cell reference or a text string.
D)The cell reference in the INDIRECT function reroutes to a new reference.

Question

Quizplus · Accepted Answer

The INDIRECT function can have one to three arguments. If only one argument is given, it should be a text string that represents a cell reference. The second and third arguments are optional and are used to specify the type of reference and whether to use the current sheet or not. The cell reference in the INDIRECT function does reroute to a new reference, but this is not unique to the INDIRECT function and applies to all cell references in Excel.

All of the Following Statements Are TRUE Regarding the INDIRECT