Answer :
The references remain fixed in Microsoft Excel as:
- Absolute
- Relative
What is the references?
In Microsoft Excel, references means using cell addresses in formulas and functions. There are two kinds of references: relative references and absolute references.
Relative references are used in formulas or functions to automatically adjust cell references when they are copied or filled to other cells. For instance, if a formula in cell A2 uses cell B2 in the calculation as "=B2+1", when you copy the formula to cell A3, it will change to "=B3+1" because the reference moves relative to the formula's new position.
Read more about Microsoft Excel here:
https://brainly.com/question/24749457
#SPJ1
