Question

A(n) ________ refers to a cell by its fixed position in the worksheet.

1) data marker
2) 3-D cell reference
3) relative cell reference
4) absolute cell reference

Answer 1

An absolute cell reference refers to a cell's fixed position in a worksheet and does not change when the formula is copied. It is denoted by dollar signs, as in $A$1.

Step-by-step explanation:

A cell reference that refers to a cell by its fixed position in a worksheet is known as an absolute cell reference. This means that no matter where in the worksheet you copy or use the formula that contains an absolute cell reference, the cell being referred to will not change. It is generally indicated by the use of dollar signs before the column letter and row number, like $A$1. In contrast, a relative cell reference changes when the formula is copied to another cell because it refers to a cell's position relative to the position of the formula.