Question

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 ...

Answer 1

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.