asked 27.8k views
5 votes
If the EXCEL formula =A3+B2 is copied from one cell to another cell located 3 rows down and two columns to the right, the resulting formula will be ...

asked
User AvinashK
by
8.2k points

1 Answer

3 votes

Final answer:

The EXCEL formula =A3+B2, when copied three rows down and two columns to the right, becomes =C6+D5 due to relative cell referencing.

Step-by-step explanation:

If the EXCEL formula =A3+B2 is copied from one cell to another cell located 3 rows down and two columns to the right, the resulting formula will be =C6+D5. This occurs because Excel uses relative cell referencing by default. When a formula is copied and pasted, the cell references are adjusted relative to the position they have been moved to.

answered
User Mes
by
8.3k points