DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which formula below contains a relative cell reference?
|
|
=$A$1+$B$2
|
|
|
=A$1+$B$2
|
|
|
=$A$3+$B$3 $
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Relative cell references are basic cell references that adjust and change when copied or when using AutoFill. Example: =SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell.
Detailed explanation-2: -Hence, we conclude that Addressing a cell as $A$4 is called Absolute Addressing.
Detailed explanation-3: -In an absolute reference, each part of the reference (the letter that refers to the row and the number that refers to the column) is preceded by a “$” – for example, $A$1 is an absolute reference to cell A1. Wherever the formula is copied or moved, it always refers to cell A1.
There is 1 question to complete.