please find the following its urgent .
1.
2.the rightmost cell in row 32 in a worksheet .
3. if you select on entire worksheet which range of cells get selected .
4. reference (fixed column and relative Row )formed by row 134 and column BD .
5. mixed reference (relative column and fixed row) formed by show 120 and column IA.
write cell reference for the following ?????
Answers
(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.
cell references for the following
1. Cell formed by intersection of row 18 and columns Z. : Z18
2. the rightmost cell in the row 32 in a worksheet. : XFD32
3. if you select on entire worksheet which range of cells get selected.
Visible Top most Row & Left most Column combination
4. mixed reference (relative column and fixed row) formed by row 120 and column IA. IA120