If you enter a formula using Point mode and click a cell that has an assigned name,then Excel will insert the name of the cell rather than the cell reference.

Name: If you enter a formula using Point mode and click a cell that has an assigned name,then Excel will insert the name of the cell rather than the cell reference.
Brand: Quizplus
Rating: 4.7 (32 reviews)

Question

Quizplus · Accepted Answer

This is true. If you click a cell that has an assigned name, Excel will insert the name of the cell in the formula instead of the cell reference.

If You Enter a Formula Using Point Mode and Click