Question

Cell address cannot be used in formula is true or false

Answer 1

Answer:

There are TRUE and FALSE functions in Excel as well. For instance, if you type “=TRUE()” into a cell, it will return the value TRUE. If you type “=FALSE()” it will return FALSE. There is no need to use these functions in standard situations.

Explanation:

Answer 2

Cell address can be used in formula

Explanation:

• When you create a simple formula that uses a function, you can prefer to data in worksheet cells by incorporating cell address in the bar of formula arguments.

• For example, when you select or enter the cell address D2, the formula uses the value of that cell to compute the result.

• You can also refer range of cells.

• So we can use the cell address in formula which is contradiction to the given statement in question.

Hence the given statement i.e. "Cell address cannot be used in formula" is a false statement.