Ask Question
6 September, 12:53

Braydon is working with a partner building a spreadsheet. The partner uses the cell reference $B7 in one of his formulas. What would not change in the formula cell if it is copied and moved by Braydon?

+4
Answers (1)
  1. 6 September, 14:03
    0
    The column position B will not change for the referenced cell $B7. This is known as mixed referencing.

    Explanation:

    In spreadsheet, the dollar sign is used in signifying locked entry which is either the row or the column or both of them. We have three main ways by which cell position are referenced, which are as follows:

    1. Mixed referencing: this is a referencing type that either locks the row or the column position, but not both. This means that if the column is locked as we had in the question above, $B7, the dollar sign in-front of the B signifies that the column position will not change during the use of the formula, which means it will remain permanently at column B, while the position of the row could change as the execution of the formula progresses. We can also have a situation that is vice-versa, meaning, the position of the row might be locked, while that of the column might be the one changing. An example of this is, B$7. The dollar sign in-front of the figure "7", signifies that the 7 is locked.

    2. Absolute referencing: this is a referencing type in which both the position of both the column and row are locked. Locking them means preventing them from moving to other cell position while fixing them to that same location for the use of their value. Examples of absolute reference is; $C$5, meaning both the row and the column positions are locked to that single location or position.

    3. Relative referencing: this is the referencing type that is the default, as it does not need the dollar sign in specifying it. An example is, B7. This type of referencing transfers control progressively to other cell locations during operations such as auto-fill and the likes.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “Braydon is working with a partner building a spreadsheet. The partner uses the cell reference $B7 in one of his formulas. What would not ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers