160k views
1 vote
Cell address A4 in a formula means it is a _________Mixed cell reference

A. Relative cell reference

B. Mixed cell reference

C. Absolute cell reference

D. All of the above



User Sibiraj
by
7.8k points

1 Answer

4 votes

Answer:

A. Relative cell reference.

Step-by-step explanation:

A relative cell reference is like a pointer to a cell or range of cell in Excel. In Excel all cell references, by default, are relative cell references.

In the given instance, the cell address A4 in a formula means it is a relative cell reference. If there would have been a $ sign before A4, then it will be an absolute cell reference. But since, it is without dollar sign, it is a relative cell reference.

Therefore, option A is correct.

User Mike Meyers
by
7.2k points