Absolute Cell Reference
In spreadsheet applications, a reference to a particular cell or group of cells that does not change, even if you change the shape or size of the spreadsheet, or copy the reference to another cell. For example, in Lotus 1-2-3 and other spreadsheet programs, the cell reference “$A$3” is an absolute cell reference that always points to the cell in the first column and third row. In contrast, the reference “A3” is a relative cell reference that initially points to the cell in the first column and third row, but may change if you copy the reference to another cell or change the shape and size of the spreadsheet in some other way. Absolute cell references are particularly useful for referencing constant values (i.e., values that never change).
Read Also:
- abstraction
The process of picking out (abstracting) common features of objects and procedures. A programmer would use abstraction, for example, to note that two functions perform almost the same task and can be combined into a single function. Abstraction is one of the most important techniques in software engineering and is closely related to two other […]
- academic retail software
Also called academic retail, in software distribution academic retail software is the term used to describe a full version of a software package that is sold at a discount to academic users. Academic retail software are in factory sealed retail boxes and the software can be registered with the software vendor for warranty and technical […]
- accelerator board
(1) Short for graphics accelerator. (2) A type of expansion board that makes a computer faster by adding a faster CPU or FPU. Most modern computers are designed to accept simpler upgrades. Built into the motherboard is a socket in which the CPU sits. It is usually possible simply to remove the CPU and replace […]
- accelerometer
An accelerometer is a device that measures non-gravitational accelerations. On the Apple iPhone there is a 3-way axis device which is used to determine the iPhone’s physical position. The accelerometer can tell when the iPhone is tilted, rotated, or moved.
- Access
(v.) (1) To use. For example, programs can access memory , which means they read data from or write data to main memory. A user can access files, directories, computers, or peripheral devices. (2) More specifically, access often means to read data from or write data to a mass storage device. The time it takes […]