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

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

Explanation:

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.