Question

Mixed reference (relative colomn and fixed row) formed by row 95 and 20colomn p

Answer 1

a) Cell formed by intersection of row 18, and column Z is Z18.

(b) The right most cell in row 32 in a worksheet is AMJ32.

(c) If you select on entire worksheet, A1:AMJ1048576 gets selected.

(d) Reference (Fixed Column and relative row) formed by row 134 and column BD is $BD134.

(e) Mixed Reference (Relative column and Fixed row) formed by row 120 and column IA is IA$120.

(f) Absolute reference formed by 45 and column Z is $Z$45.

(g) Relative Reference formed by row 19 and column AB is AB19