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 ?
Learn some basic functions and formulas and how to use absolute cell reference. Other things discussed include Tables and PowerPivot Tables.
Starting at the upper left-hand cell of the covariance matrix, enter the cell reference for the standard deviation for that investment (from the column data) times the cell reference for the standard deviation for that investment (from the row data) times the cell reference for the correlation of that asset with itself.
By naming the assumption cell, you can also reference the cell name when creating formulas instead of typing the cell reference. This can make the formula easier to write and review.
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.
Lymphocyte, monocyte, and natural killer cell reference ranges in postpartal women.