Question

The formula in cell A2 is =B1 ✕ 10. If the formula is copy-pasted to cell A3, what will A3's formula be?

a) =B2 ✕ 10
b) =A2 ✕ 10
c) =B1 ✕ 10
d) =A3 ✕ 10

Answer 1

The formula in cell A3 after copying from A2 with the formula '=B1 × 10' will be '=B2 × 10' due to relative referencing.

Step-by-step explanation:

When you copy a formula from one cell to another in a spreadsheet, the references within the formula will often change based on a feature called relative referencing. This means that if the original formula in cell A2 is =B1 × 10, and you copy and paste it into cell A3, the formula will adjust so that the cell references move down one row, mirroring how the formula itself has moved down one row. Therefore, the formula in cell A3 will become =B2 × 10, reflecting the new position one row below the original. This option corresponds to answer choice a) =B2 × 10.

Answer 2

The correct formula in cell A3 after copy-pasting =B1 × 10 from cell A2 will be =B2 × 10.

Step-by-step explanation:

The formula in cell A2 is =B1 × 10. If this formula is copy-pasted to cell A3, the formula will automatically adjust based on relative cell references. This means that the row number will change relativistically from row 1 to row 2, since we are moving the formula down one row. Therefore, the correct formula in cell A3 after pasting will be =B2 × 10, which is answer option a).