Ask 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"

+1
Answers (1)
  1. 6 September, 14:08
    0
    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.
Know the Answer?
Not Sure About the Answer?
Find an answer to your 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 ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers