USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
18Z
|
|
|
Z18
|
|
|
Y18
|
|
|
None
|
Detailed explanation-1: -3. Write cell reference for the following: (a) Cell formed by intersection of row 18, and column Z. Answer : Z18 (b) The right most cell in row 32 in a worksheet. Answer : AMJ32 (c) If you select on entire worksheet, which range of cells gets selected.
Detailed explanation-2: -(b) Absolute reference formed by 45 and column Z is referenced as R45. (c) Relative Reference formed by row 19 and column AB is referenced as R19.
Detailed explanation-3: -To refer to a cell, type the column letter followed by the row number. For example, D50 refers to the cell at the intersection of column D and row 50.
Detailed explanation-4: -Expert-Verified Answer (d) Reference (Fixed Column and relative row) formed by row 134 and column BD is $BD134.