which of the following is a relative cell reference?

The relative cell reference is any reference without dollar signs, for example: A1.

Quick Scoop: Relative Cell Reference

• A relative cell reference changes when you copy the formula to another cell.

• In Excel or Google Sheets, something like A1, B3, or C5 is a relative reference.

• References like $A$1, $A1, or A$1 are not purely relative; they are absolute or mixed.

So, if the options look like this:

• A1
• $A$1
• $A1
• A$1

…the correct answer to “which of the following is a relative cell reference?” is A1.

Relative reference = no $ signs; it adjusts automatically when copied.

TL;DR: Choose the option that looks like A1 (no dollar signs) as the relative cell reference.

Information gathered from public forums or data available on the internet and portrayed here.