Question

37. If a formula should not be adjusted after it is copied, use
O
(A) Absolute cell references
O (B) Mixed cell references
O
(C) Relative cell references
O (D) None of these​

Answer 1

Absolute cell references

Answer 2

Absolute cell references

Explanation:

Using Absolute Cell References

1. When you need a method to constantly confer with a selected cell, even in case you replica or circulate the method someplace else at the worksheet, you want to apply an absolute cell reference.
2. An absolute cell reference is a cell deal with that incorporates a dollar sign within side the row or column coordinate, or both. When you input a cell reference in a method, Excel assumes it is a relative reference until you exchange it to an absolute reference.
3. If you need a part of a method to stay a relative reference, eliminate the dollar sign that looks earlier than the column letter or row number.

Absolute cell reference should be used to adjust formulae.