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 of the assay reagent kits wr, aso, rf, ph waaler rose, mononucleosis and reagents, cell reference, control materials, consumables and supplies for performing assays in the field of serology transfuzjologicznej, along with the lease of two automated analyzers, a manual system as a back up and system including a program of hiv and blood bank - 2 packages.
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.