Respuesta :
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:
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.