Question

question 17 the formula in cell a2 is =b1+10. the formula is copy - pasted to cell a3, so a3s formula will be which of the following? a =b1+21 b =a1+10 c =a4+10 d =b2+10 3 points

Explanation:

Step1: Understand relative - referencing in spreadsheets

In a spreadsheet, when a formula is copied down a column, the row references change relative to the new position while the column references remain the same (in relative - referencing). The formula in cell A2 is =B1 + 10. When copied to cell A3, the row number for the cell references in the formula will increase by 1.

Step2: Adjust the formula

The B1 in the original formula will become B2 (as the row number increases by 1), and the constant 10 remains the same. So the new formula in A3 is =B2+10.

Answer:

D. =B2+10