USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Absolute
|
|
|
Relative
|
|
|
Mixed
|
|
|
Proper
|
Detailed explanation-1: -This is an absolute reference. In less frequent cases, you may want to make a cell reference “mixed” by preceding either the column or the row value with a dollar sign to “lock” either the column or the row (for example, $A2 or B$3).
Detailed explanation-2: -What is a mixed reference? Mixed reference Excel definition: A mixed reference is made up of both an absolute reference and relative reference. This means that part of the reference is fixed, either the row or the column, and the other part is relative.
Detailed explanation-3: -Hence, we conclude that Addressing a cell as $A$4 is called Absolute Addressing.
Detailed explanation-4: -A mixed reference in Excel is a type of cell reference different from the other two absolute and relative. We only refer to the cell’s column or row in the mixed cell reference. So, for example, in cell A1 if we want to refer to only the A column, the mixed reference would be $A1.