CBSE Class 9 Computer Applications
Question 38 of 53
Spreadsheet Tool : OO Calc I — Question 10
Back to all questions 10
Question Question 10
Write cell references for the following :
(i) Cell formed by intersection of row 18, and column Z.
(ii) The right most cell in row 32 in a worksheet.
(iii) If you select an entire worksheet, which range of cells gets selected.
(iv) Reference (Fixed Column and Relative row) formed by row 134 and column BD.
(v) Mixed Reference (Relative column and Fixed row) formed by row 120 and column IA
(vi) Absolute Reference formed by 45 and column Z.
(vii) Relative Reference formed by row 19 and column AB.
(i) Z18
(ii) ZZ32 (If ZZ is the last column)
(iii) All the cells get selected.
(iv) $BD134
(v) IA$120
(vi) $Z$45
(vii) AB19