Ask Question
19 October, 01:47

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

+2
Answers (1)
  1. 19 October, 02:00
    0
    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.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers