Question

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​

Answer 1

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