the formula in cell a2 is =b1+10. the formula...
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 =a1+10 b =b1+21 c =a4+10 last saved 8:16:08 am
Answer
# Explanation:
## Step1: Understand relative - cell referencing
In Excel, when a formula with relative - cell references is copy - pasted, the cell references adjust relative to the new location. When the formula in cell A2 ($=B1 + 10$) is copy - pasted down to cell A3, the row number in the cell references will change. The column remains the same for the relative reference of B1. Since we are moving down one row, the row number of the referenced cell (B1) will also increase by 1.
## Step2: Determine the new formula
The new formula in cell A3 will be $=B2+10$. But among the given options, when we consider the relative - cell reference concept in a simple way of moving down one row, if we assume a simple pattern of relative reference movement, the formula in A3 will adjust the row number of the first cell reference. Since we moved from A2 to A3 (down one row), the row number in the reference will also move down one row. So the formula in A3 will be $=B2 + 10$ which is equivalent to $=A1+10$ if we consider the relative position change in a more general sense of relative - cell referencing in a simple linear row - based movement.
# Answer:
A. =A1+10