In Microsoft Excel, what is a characteristic of an “absolute reference”?
- the reference changes depending on the relative position of the cell
- it is indicated by preceding a cell reference in a formula with a $ meaning the cell reference will not change when the formula is copied to a new location
- it requires no parenthesis and brackets when used in the formula
- it is used to automatically summarize, analyze, explore, and present data
| Answers Explanation & Hints:
Cell and range references can have either a relative or absolute attribute. The relative reference changes depending on the relative position of the cell, so if the formula is copied to a new location, the cell location in the formula will change. An absolute reference (indicated by a $ preceding the location in the formula), will not change when the formula is copied to a new location. |