Sorting changes what a reference points at
40%
A reference points at a position, not at a value. =C2 means "whatever is in C2", and after a sort that is a different record entirely.
Used deliberately that is useful: sort descending and C2 is reliably the highest figure. Used carelessly it is how a report ends up quoting last quarter's worst performer as this quarter's best.
Sort the table by Revenue, largest first. Then in F2 refer to the top revenue cell, and in F3 refer to the bottom one.
The grid for this exercise is part of the paid half.
Everything above is yours to read either way. 46 exercises stay free with a profile.