Get premium membership and access questions with answers, video lessons as well as revision papers.

Differentiate between relative and absolute cell reference as used in Ms-excel.

      

Differentiate between relative and absolute cell reference as used in Ms-excel.

  

Answers


Kavungya
Relative cell referencing means the referencing means that the references of cell used in a formula are relative to the location of the cell where the formula is placed, e.g. E3= C3* D3. this tells Excel to multiply the contents of C3 by D3 which have been defined in relation to E3.
Absolute cell addressing means reference is made to one or more cells in a way which doesn’t vary(change) according to circumstances.
Kavungya answered the question on June 6, 2019 at 09:34


Next: The fist column in the table below contains formulas as entered into cell D46. In the second column, enter the formulas as they would appear...
Previous: a) A formula to add the contents of B5 and C4 was entered in Cell F5. what will it become when it is copied to Cell...

View More Computer Studies Questions and Answers | Return to Questions Index


Learn High School English on YouTube

Related Questions