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.
