222k views
2 votes
5. What are Excel cell references by default?

Relative references
Absolute references
Mixed references
Cell references must be assigned

1 Answer

3 votes

Answer: relative references

Step-by-step explanation:

By default, all cell references are RELATIVE REFERENCES. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.

User JohnD
by
8.8k points

No related questions found

Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.