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 ?
Using the mouse or arrow keys will insert =GETPIVOT DATAO functions instead of the cell reference.
By naming the assumption cell, you can also reference the cell name when creating formulas instead of typing the cell reference.
Tenders are invited for support specialized collaboratory that will adopt scalable technology platforms and streamlined workflows to generate a comprehensive 3d brain cell reference atlas encompassing molecular, anatomical, and physiological annotations of brain cell types in mouse, and incorporate additional genetic and other advanced cell-specific targeting approaches and tools to facilitate this goal.
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.
Over the past 2 years Tata Elxsi emerged as the market leading provider of LTE small cell reference design and protocol software for L2/L3 and L1 optimized to market leading processors.
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).
Enter relative references for flow and absolute roughness and absolute references (using the F4 key after the cell reference is entered) for the global inputs for design static, kinematic viscosity and specific volume.
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.