Question

6. A formula using the
cell reference keeps the cell reference constant
​

Answer 1

ϙᴜᴇsᴛɪᴏɴ:

A formula using the cell reference keeps the cell reference constant.

ᴀɴsᴡᴇʀ:

To keep cell reference constant in formula, you just need to add the $ symbol to the cell reference with pressing the F4 key. Please do as follows.

1. Select the cell with the formula you want to make it constant.

2. In the Formula Bar, put the cursor in the cell which you want to make it constant, then press the F4 key.

In this case, I don't want the cell

reference A1 to be adjusted with the

formula moving, so I put the cursor on A1

in the formula, and then press F4.

Hope It'll Helps!