If cell B1 has the formula =A1*$c$1 and the formula is copied to cell B2, then which of these will be the formula in B2?
A A2*$C$1
B A2*$C1
C A2*C$1
D None of these
Answers
Answered by
2
Answer:
Relative references
By default, all cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2. Relative references are especially convenient whenever you need to repeat the same calculation across multiple rows or columns.
Hopefully this helps you
Similar questions
Computer Science,
3 hours ago
Science,
3 hours ago
Math,
5 hours ago
Math,
5 hours ago
Hindi,
7 months ago