USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
B$4 is an example of a relative cell reference.
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Hence, we conclude that Addressing a cell as $A$4 is called Absolute Addressing.
Detailed explanation-2: -D7 is a relative reference. If you write formula =D7 in cell A1, then copy and paste to cell A2 the formula in A2 will be =D8. $D$7 is an absolute reference. Copy and paste it anywhere you like.
Detailed explanation-3: -The $ sign causes the cell column or row or both in a formula to be fixed. That is, if you drag the formula cell horizontally or vertically in order to copy the formula, Excel will not adjust this value. For example : Cell Formula A0 =$B4.
Detailed explanation-4: -An absolute reference in Excel is a cell address with the dollar sign ($) in the row or column coordinates, like $A$1.
There is 1 question to complete.