USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=$B4
|
|
|
=B$4
|
|
|
=$B$4
|
|
|
=B4
|
Detailed explanation-1: -The cell reference is automatically made absolute by Excel! Excel will cycle through each possible absolute reference by pressing F4 repeatedly.
Detailed explanation-2: -Absolute references are used when you want to fix a cell location. These cell references are preceded by a dollar sign. By doing this, you are fixing the value of a particular cell reference. For example, if you type the formula = A1+A2 into A3 and copy it to another location: B3, the formula will change to = B1+B2.
Detailed explanation-3: -Laptop keyboards are smaller than stationary ones so typically, the F-keys (like F4) are used for something else. This is easily fixed! Just hold down the Fn key before you press F4 and it’ll work. Now, you’re ready to use absolute references in your formulas.