Question

A spreadsheet developer enters the formula "=$B$9*$B$10" into cell C1. If this formula is copied and then pasted into cell C2, what will the formula in cell C2 be?

Answer 1

Answer:

Explanation:

In this Excel example we add the example formula in the cell C1, then we copy and paste in the cell C2, in this case, the formula doesn't change because these symbols $ were implemented in the formula, if we remove these symbols the formula changes, for example in the cell C8 would be next formula: =B15*B16.