DATABASE FUNDAMENTALS
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: -An absolute reference in Excel is a cell address with the dollar sign ($) in the row or column coordinates, like $A$1.
Detailed explanation-4: -Answer. Answer: The row and column portions of a relative reference are not preceded by a “$” – for example, A1 is a relative reference to cell A1. If moved or copied, the reference changes by the same number of rows and coulmns as it was moved.
There is 1 question to complete.