What are Excel cell references by default?1 pointCell references must be assigned Relative referencesAbsolute referencesMixed references

Understanding Cell References in Excel

Excel utilizes different types of cell references to provide users with flexibility in how they work with formulas and data. By default, Excel cell references are categorized into three types: Relative references, Absolute references, and Mixed references.

1. Relative References: When you copy a formula containing relative references, the references adjust automatically based on the position of the cell where you paste the formula. For instance, if you have a formula in cell A1 that references B1, and you copy that formula to cell A2, the reference will adjust to B2.

2. Absolute References: These are fixed and do not change when you copy the formula to another cell. Absolute references are denoted by a dollar sign. For example, if you have a formula referencing $B$1, and you copy it to another cell, it will still point to B1.

3. Mixed References: These combine both relative and absolute references. For instance, $B1 or B$1, where either the column or row is fixed while the other adjusts when the formula is copied.

Conclusion

By default, Excel uses Relative references. This allows for efficient formula replication across multiple cells without needing to manually adjust each reference. Thus, the answer to your question is Relative references.