differentiate absolute and relative cell addressing
Answers
Answered by
31
There are two major types of references used in Microsoft Excel which is an Absolute Reference and a Relative Reference. On a day-to-day basis, the relative and absolute reference doesn't really affect the operations of your spreadsheet. Where it does become a noticeable issue is when you start copying formulas from one cell to another.
Lets investigate the difference between the two …
A Relative Reference is one that when copied from one position to another will adjust the formula cell address to suit the position it is in. For example if you have a formula in cell address C4 that was =B4*C1 and then copied the formula into say C5 what you will notice is that the cell addresses of the formula will change to =B5 * C2. The reason this has occurred is that the cell addresses are in fact relative addresses. That is the cell address is relative to its current position.
To change a cell address from being relative to being absolute we simply add dollars signs to the cell address in this way - $C$5. What this address is now saying to us is that we must absolutely refer to column C and absolutely refer to Row 5. This means that if we apply the dollar symbols to our previous formula in cell C4 which is =$B$4 * $C$4 and then copy our formula to cell address C5 you will notice this time round that the cell addresses didn't change. The reason is that by adding the $ symbols to the cell address we are telling the formula that regardless of where you place the formula you must absolutely refer to Column B and Row four thus we have $B$4.
There are many reasons why you may use Relative References over Absolute references and vice versa. One of the most common one for using absolute references is when you have a specific value you want to refer to in a formula. For example, lets say you are building a mortgage calculator and you need to refer to an Interest Rate. To ensure you are always referring to the right cell that has the interest rate value you may set an absolute value.
In Microsoft Excel there is also a reference called a mixed reference. Essentially what this means is that only either the Column or the Row has the dollar symbol, for example $C3. What this is telling us is that in the formula you must absolutely refer to column C but the value in the row is relative to the position of the formula.
There are a number of ways that you can enter Relative and Absolute values into a formula. One technique is that you can simply type the $ symbols next to the Row or the Column. However there is an alternative. Once you have typed in the Cell address like C4 you can move back into the cell address and then use the F4 key to toggle the cell reference from Relative to Absolute to a Mixed References.
Lets investigate the difference between the two …
A Relative Reference is one that when copied from one position to another will adjust the formula cell address to suit the position it is in. For example if you have a formula in cell address C4 that was =B4*C1 and then copied the formula into say C5 what you will notice is that the cell addresses of the formula will change to =B5 * C2. The reason this has occurred is that the cell addresses are in fact relative addresses. That is the cell address is relative to its current position.
To change a cell address from being relative to being absolute we simply add dollars signs to the cell address in this way - $C$5. What this address is now saying to us is that we must absolutely refer to column C and absolutely refer to Row 5. This means that if we apply the dollar symbols to our previous formula in cell C4 which is =$B$4 * $C$4 and then copy our formula to cell address C5 you will notice this time round that the cell addresses didn't change. The reason is that by adding the $ symbols to the cell address we are telling the formula that regardless of where you place the formula you must absolutely refer to Column B and Row four thus we have $B$4.
There are many reasons why you may use Relative References over Absolute references and vice versa. One of the most common one for using absolute references is when you have a specific value you want to refer to in a formula. For example, lets say you are building a mortgage calculator and you need to refer to an Interest Rate. To ensure you are always referring to the right cell that has the interest rate value you may set an absolute value.
In Microsoft Excel there is also a reference called a mixed reference. Essentially what this means is that only either the Column or the Row has the dollar symbol, for example $C3. What this is telling us is that in the formula you must absolutely refer to column C but the value in the row is relative to the position of the formula.
There are a number of ways that you can enter Relative and Absolute values into a formula. One technique is that you can simply type the $ symbols next to the Row or the Column. However there is an alternative. Once you have typed in the Cell address like C4 you can move back into the cell address and then use the F4 key to toggle the cell reference from Relative to Absolute to a Mixed References.
Answered by
7
Relative and absolute references behave differently when copied and filled to other cells.
Explanation:
- Relative address means an address specified by indicating its distance from another address, called the base address. Relative references change when a formula is copied to another cell.
- A cell reference or relative cell reference describes how far away a cell or group of cells is from another cell in the same spreadsheet.
- Absolute references, on the other hand, remain constant, no matter where they are copied. An absolute cell reference is a cell address that contains a dollar sign ($) in the row or column coordinate, or both.
- An absolute cell reference is a cell reference in a spreadsheet application that remains constant even if the shape or size of the spreadsheet is changed, or the reference is copied or moved to another cell or sheet. Absolute cell references are important when referring to constant values in a spreadsheet.
Learn more!
https://brainly.in/question/1589544
https://brainly.in/question/1563275
Similar questions