You created a spreadsheet and entered the following formulas in cells A1, A2, and A3.

A1:=A2+2
A2:=A1−1
A3:=A1×3
What’s wrong with these entries?

Responses

Two cells (A1 and A2) refer to each other and therefore cannot be resolved.
Two cells (A1 and A2) refer to each other and therefore cannot be resolved.

You cannot have two cells (A2 and A3) both refer to the same cell (A1).
You cannot have two cells (A2 and A3) both refer to the same cell (A1).

Column A is reserved for text and cannot be used for formulas.
Column A is reserved for text and cannot be used for formulas.

The three formulas are not proper expressions because they do not include functions.
The three formulas are not proper expressions because they do not include functions.

Q&A Education