USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
^A^1
|
|
|
$A#1
|
|
|
@A@1@
|
|
|
A$1
|
Detailed explanation-1: -Answer: A mixed reference is a reference that refers to a specific row or column. For example, $A1 or A$1. If you want to create a mixed reference-press the F4 key on the formula bar two or three times depending on whether you want to refer to row or column.
Detailed explanation-2: -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.
Detailed explanation-3: -These are called “relative” cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a “$” before the column letter if you want that to always stay the same.
Detailed explanation-4: -Hence, we conclude that Addressing a cell as $A$4 is called Absolute Addressing.
Detailed explanation-5: -Answer. Answer: The answer is False.