A cell that remains the same when it is copied or filled to other cells is a(n) ________.
A) relative cell reference
B) constant cell reference
C) fixed cell reference
D) absolute cell reference

Question

Quizplus · Accepted Answer

An absolute cell reference remains the same when it is copied or filled to other cells. This is denoted by adding a dollar sign before the column letter and row number ($A$1). Relative cell references, on the other hand, change when they are copied or filled to other cells. Constant cell references and fixed cell references are not commonly used terms in Excel.

A Cell That Remains the Same When It Is Copied