# FUNDAMENTALS OF COMPUTER

## 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.
 A True B False C Either A or B D 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.