difference between relative and mixed referencing in computer
Answers
Answered by
8
Relative cell references
This is the standard type of reference. Look at the following examples:
Example 1:
If cell A1 contains value 2, and cell B1 contains formula =A1+2 (referring to cell A1), then the formula B1 contains value 4. If you change the value in cell A1 to 5, then the value in cell B1 automatically changes to 7.
Example 2:
If cell B1 refers to cell A1, then after copying cell B1 to cell D2, the cell starts to refer to cell C2. In other words, cell reference has been moved by the same distance as the copied cell.
Example 3:
Look at the following example. Here, you can find the names of employees of a fictional company.
If you want to merge the first name with the last name and place them in column D, you don't have to enter them manually, but you can merge them by using the relative references, instead.
In this case, enter the formula =B2&" "&C2 into cell D2. It will merge cell B2,space, and cell C2. Now you can use AutoFill to fill the remaining cells.
You can display formulas instead of values by using the Ctrl + ` (the key that is located below the ESC key) keyboard shortcut.
As you can see, only the formula in cell D2 refers to cells B2 and C2. References in the next cells have been shifted accordingly.
Mixed cell references
A mixed reference is a reference that refer to a specific row or column. For example, $A1 or A$1. If you want to create a mixed reference- press the F4key on the formula bar two or three times depending on whether you want to refer to row or column. Press F4 one more time to go back to the relative cell reference.
This is the standard type of reference. Look at the following examples:
Example 1:
If cell A1 contains value 2, and cell B1 contains formula =A1+2 (referring to cell A1), then the formula B1 contains value 4. If you change the value in cell A1 to 5, then the value in cell B1 automatically changes to 7.
Example 2:
If cell B1 refers to cell A1, then after copying cell B1 to cell D2, the cell starts to refer to cell C2. In other words, cell reference has been moved by the same distance as the copied cell.
Example 3:
Look at the following example. Here, you can find the names of employees of a fictional company.
If you want to merge the first name with the last name and place them in column D, you don't have to enter them manually, but you can merge them by using the relative references, instead.
In this case, enter the formula =B2&" "&C2 into cell D2. It will merge cell B2,space, and cell C2. Now you can use AutoFill to fill the remaining cells.
You can display formulas instead of values by using the Ctrl + ` (the key that is located below the ESC key) keyboard shortcut.
As you can see, only the formula in cell D2 refers to cells B2 and C2. References in the next cells have been shifted accordingly.
Mixed cell references
A mixed reference is a reference that refer to a specific row or column. For example, $A1 or A$1. If you want to create a mixed reference- press the F4key on the formula bar two or three times depending on whether you want to refer to row or column. Press F4 one more time to go back to the relative cell reference.
shivam718:
very good
Answered by
18
If the mixture, the cell reference address of the formula function we copy, its cell address will not change (absolute).
While relative, means to change. This is closely related to copying a formula. This relative cell address will change according to the intended position.
I hope this help :3-Fona
While relative, means to change. This is closely related to copying a formula. This relative cell address will change according to the intended position.
I hope this help :3-Fona
Similar questions