176k views
3 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 Brianda
by
8.0k points

1 Answer

2 votes

Final answer:

When the formula =A3+$B$2 is copied to a cell two rows down and three columns to the right, the resulting formula will be =D5+$B$2.

Step-by-step explanation:

When the 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 =D5+$B$2. The value in cell A3 will be updated to D5 because we moved three columns to the right, and the absolute reference $B$2 will remain the same because it is locked with the dollar signs. So, the resulting formula will add the value in D5 to the value in $B$2.

User James Mitchell
by
8.4k points