When a user copies a formula in an Excel spreadsheet and the cell references change in response, the process is called "relative addressing."When a user copies a formula into another cell and the cell reference does not change, the process is called "absolute addressing." Relative addressing (the most commonly used) is particularly good for totaling column or row numbers in a table, whereas absolute addressing might be necessary when the user needs entries in...
When a user copies a formula in an Excel spreadsheet and the cell references change in response, the process is called "relative addressing."
When a user copies a formula into another cell and the cell reference does not change, the process is called "absolute addressing."
Relative addressing (the most commonly used) is particularly good for totaling column or row numbers in a table, whereas absolute addressing might be necessary when the user needs entries in a given row and/or column to remain unaffected. Note: in order to make references absolute, the addition of a dollar sign ($) to the address is necessary. Absolute addressing is useful when calculating sales tax, projected sales, or gross pay for multiple employees with an hourly wage.
No comments:
Post a Comment