Copying references
Referencing becomes especially useful if you start copying the references around. When you copy formulas containing references to neighboring cells, the references will shift along by the corresponding amount.
Cet exercice fait partie du cours
<cours>Introduction à Google Sheets</cours>Instructions de l’exercice
- In
E2, create a cell reference toC2. - Copy the cell reference in
E2to populateE2:E11with thePopulationvalues. - Populate
F2:F11with theLand Area (km2)values by copying references.
Exercice interactif pratique
Transformez la théorie en action avec l’un de nos exercices interactifs
Commencer l’exercice