Question

mention two ways of entering a cell reference in a formula .explain there differences​

Answer 1

Answer:

Explanation:

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. For example, we can type the formula "=B7+D6" directly.

Notice that you don't need to worry about case. When Excel sees a valid cell reference, it will automatically convert the reference to upper case.

Excel has a nice way of showing you what cells are being referenced in a formula. As you type each cell reference, Excel will highlight the cells being referenced in a special bounding box with 4 prominent handles.

Each reference that appears in the formula is color-coded to match the color used to highlight the cells being referenced.

Another way to enter cell references in Excel is to click in the worksheet as you type the formula. Start typing the formula normally, and click to add references as you go.

Notice that when you select a cell that contains a formula, the formula is displayed in the formula bar, but the cell references are not color coded or highlighted in the worksheet.

To see the highlighting again, just double click or click F2.

You can also click into the formula bar.

Answer 2

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.