Question

Which of these statements about cell references is NOT true?
A. You can enter a cell references in a formula by typing in the reference.
B. Cell references can only be entered in a formula by using the Formula Bar
C. You can enter a cell reference in a formula by clicking the cell location on the spreadsheet.
D. Cell references make it easy to use values from other cells in a formula.

Answer 1

Answer:

B. Cell references can only be entered in a formula by using the Formula Bar

Explanation:

A cell reference is the value of a different cell that can be in the same worksheet or in a different one that can be used in a formula. If you need to enter a cell reference in Excel you can do it by clicking the cell on the spreadsheet, by writing it and by using the formula bar. According to this, the statement that is not true is that cell references can only be entered in a formula by using the Formula Bar.