cell reference

cell reference

[′sel ‚ref·rəns]
(computer science)
The address of a cell that contains a value that is needed to solve a formula in a spreadsheet program.

cell reference

(spreadsheet)
A string identifying a particular cell in a spreadsheet, possibly relative to the cell containing the reference. A cell reference may be absolute (denoted by a "$" prefix in Excel) or relative (no prefix) in each dimension, thus, e.g. B$6 refers to the second cell across in the sixth row. The distinction between absolute and relative is only significant when the referring cell is copied, e.g. if cell A1, which refers to B$6, is copied to cell B1, then B1 will refer to C6.

If the reference is to a cell in a different sheet then it is prefixed with the target sheet's name and an exclamation mark. E.g. "Sheet 1!B3".
References in periodicals archive ?
Contract award: delivery cuvettes to hemoglobinometru hemocue hemocue cleaners camera, cell reference to the hemocue hematology analyzers.
For example, if we wanted to generate revenue with a mean of $15,000 and standard deviation of $1,000 (in other words, 67% of the values fall between $14,000 and $16,000), the formula would be = 15000 + (1000 * A1), where A1 is the cell reference for the standard normal deviate.
Cavium is continuously striving to offer lower-cost, power optimized small cell reference designs to our customers," said Raj Singh, General Manager of Cavium's Wireless Broadband Group.
The difference in labels prevents the use of clever lookup formulas such as VLOOKUE Instead, a typical approach would be to use a direct cell reference, such as=A1, to retrieve the value.
Currently, in volume commercial deployment, Cavium offers a complete manufacturable small cell reference design for the OCTEON Fusion family, which includes hardware design files, as well as integrated, royalty-free L1-L3 LTE software.
Features such as viewing all cells together and cell classes side-by-side; access to a cell reference library; the patient's historical images; and the ability for multiple users to collaborate in real-time from any location worktogether to reduce the inherent subjectivity of morphological analysis.
This is done by adding another cell reference to the output cell B7 as shown in cell F3 of Figure 6.
Similarly, the CD4+ T cell reference range in healthy adults from Turkey was from 437 to 2072 (mean 1095 and median 1055 cells/[micro]l) (57).
Just to the left of the formula bar where the formula =SUM(B104:B133) appears is the cell reference B134.
Lymphocyte, monocyte, and natural killer cell reference ranges in postpartal women.
83), where A is a cell reference containing the goal expectation for the whole game and B is a cell reference containing the proportion of the game remaining - after 30 minutes, for example, there would be 60/90 or 0.