Suppose you want to copy a formula while keeping one of the cell references locked on the same cell.
Which of the following would you use?
(a) Relative Reference (b) Absolute Reference
Answers
Answer:
Abe tu ladka h terse puch kon ra h
Answer:
To copy a formula while keeping one of the cell references locked on the same cell, you would use an Absolute Reference.
Explanation:
An absolute reference is denoted by a "$" symbol placed before the column and/or row reference in the formula. For example, if you have a formula in cell A1 that references cell B1, and you want to copy the formula to cell A2 while keeping the reference to cell B1, the formula in cell A2 would be written as "$B$1".
The "$" symbol ensures that the reference to cell B1 does not change when the formula is copied to another cell. On the other hand, a relative reference automatically updates based on the new location of the formula when it is copied.
More questions and answers
https://brainly.in/question/37653714?referrer=searchResults
https://brainly.in/question/32712310?referrer=searchResults
#SPJ2