Question

Pick the correct statements regarding cell references.

Answer 1

Statement two and three is correct.

Statement 1 is incorrect. A relative reference changes when a formula is copied to another cell while Absolute references remain constant. However, it is safe to say that an absolute address can be preceded by a $ sign before both the row and the column values. It is designated by the addition of a dollar sign either before the column reference, the row reference, or both. Statement C is also correct. A mixed reference is a combination of relative and absolute reference and the formula (= A1 + $B$2) is an example of a mixed cell reference.

Answer 2

Answer:

1) A relative reference will retain its references when copied to another cell.

2) An absolute address has a $ sign before both the row and the column values.

3) = A1 + $B$2 is an example of a mixed cell reference.

4) The address 7B is invalid.

Explanation:

We know that a call by reference method can be defined as a method of providing different  arguments to a function and then that function copies the address of an argument into the formal pattern.