What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it

Question

Karo-lina-s [1.5K]

4 years ago

13

What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it

to the
destination area?
A Unconditional
OB. Relative
C. Mixed
D. Absolute

Computers and Technology

1 answer:

Lelu [443] · Answer 1 · 2021-12-09T06:50:58+03:00

Absolute type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area.

D. Absolute

<u>Explanation:</u>

Absolute references stay consistent regardless of where they are replicated. As a matter of course, all cell references are relative references. Snap the cell with the equation to choose it. Press Ctrl + C to duplicate the equation. Select a cell or a scope of cells where you need to glue the equation (to choose non-nearby ranges, press and hold the Ctrl key).

Press Ctrl + V to glue the equation. When replicated over different cells, they change dependent on the overall situation of lines and sections. For Example, on the off chance that you duplicate the equation =A1+B1 from push 1 to push 2, the recipe will become =A2+B2.