92.8k views
0 votes
If the EXCEL formula =$A3+B$2 is copied from one cell to another cell located two rows down and three columns to the right, the resulting formula will be ...

User Jdgregson
by
7.9k points

1 Answer

5 votes

Final answer:

The resulting formula will be =C5+D4.

Step-by-step explanation:

When the =A3+B2 formula is copied two rows down and three columns to the right, the resulting formula will be =C5+D4. The letters and numbers in the formula update based on the new position. In the original formula, A3 means the cell in column A, row 3, and B2 means the cell in column B, row 2. When copied, the formula adjusts to C5+D4, representing the cell in column C, row 5, added to the cell in column D, row 4.

User Arian Motamedi
by
8.4k points