Question

How do you freeze the total cell so that it doesn't change when copied?

a) put a # in front of the letter and number that represents the cell position.
b) put a $ behind the letter and number that represents the cell position.
c) put a $ in front of the letter and number that represents the cell position.
d) you don't do anything, they are already frozen in Excel"

Answer 1

Answer:

c) put a $ in front of the letter and number that represents the cell position.

Explanation:

Dollar sign ($) is used to lock the formula in the cell. This is called absolute reference. In this type of referencing, A dollar sign is place in front of the letter and number to lock that cell. Whenever we copy that cell, the formula will be copied in other cell without changing its reference number.

As

Example 1

C1 = A1 + B1

if we copy this formula in C2 then it becomes

C2= A2 + B2

there both reference of A and B has been changed.

Example 2

If we put $ sign as

C1= $A$1 + $B$1

now of we copy C1 and into C2

C2= $A$1 + $B$1

There reference of cell is not changed.