Question

what is the difference between relative referencing and absolute referencing
​

Answer 1

Answer:

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.

Explanation:

mark me as a brainlist and follow me

Answer 2

Answer:

Relative and absolute cell is that relative cell referencing move when you copy them, but absolute referencing do not absolute referencing are noted  by a dollar sign in front to the cell refrerence.

Relative referencing change when a formula is copied to another cell. absolute referencing, on the other hand, remain constant, no matter where they are copied.

        RELATIVE REFERENCING

By default, all cell referencing are relative referencing. when copied across multiple cells, they change based on the relative position of rows and columns. for example= A1+B1 from row 1 to row 2, the formula will become= A2+B2, relative referencing are especially convenient whenever you need to repeat the same calculation across multiple rows or columns.

       ABSOLUTE REFERENCING

They may times when you do not want a cell reference to change when filling cells. unlike relative referencing, absolute referencing do not change when copied or filled. You can use an absolute referencing to keep a row and/or column constant.

An absolute referencing is designated in a formula by the addition of a dollar sign ($) before the column and the row. If it precedes the column or row (but not both), it's known as a mixed referencing.

             $A$2   The column and the row do not change when copied.

             A$2      The row does not change when copied.

             $A2      The column does not change when copied.

* You will use the relative (A2) and the ($A$2) formats in most formulas.

            Mixed referencing are used less frequently.

When writting a formula in microsoft excel, you can press the f 4key on your keboard to switch between relative, absolute, and mixed cell referencing, absolute in the video below. this is an easy way to quickly insert an absolute referencing.  

Explanation: