Absolute references: fixing rows
A reference can also be partially absolute, where only the column or the row is fixed. This means that the reference will remain unchanged when copied in one direction, but will change when copied in the other direction.
In this exercise, you'll use partial absolute references with fixed rows to quickly populate the Relative Area
column by copying the references from the Relative Population
column. This will essentially let you reuse the formulas in D2:D11
, and avoid unnecessary typing.
Este exercício faz parte do curso
Introdução ao Google Sheets
Instruções de exercício
- Change the formulas in
D2:D11
so that only the row is locked in the absolute reference to cellB12
. - Copy the references from
D2:D11
intoE2:E11
.
Exercício interativo prático
Transforme a teoria em ação com um de nossos exercícios interativos
