Question

what are the two ways of entering a cell reference in an Excel formula define both ways​

Answer 1

Answer:

To enter a formula that contains cell references, you have two choices. You can type cell references directly, or you can point and click to cells to pick up their addresses. The most basic way to enter cell references in a formula is to just type in the references as you need them.

Explanation:

thank you

Answer 2

Answer:

To enter a formula that contains cell references, you have two choices. You can type cell references directly, or you can point and click to cells to pick up their addresses. The most basic way to enter cell references in a formula is to just type in the references as you need them.

★Click the cell in which you want to enter the formula.

★Type the equal sign (=).

★Do one of the following: Type the reference directly in the cell or in the formula bar, or.

★Click the cell you want to refer to.

*Type the rest of the formula and press the Enter key to complete it.