Question

Pick the correct statements regarding cell references.



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.

Answer 1

Answer

2) An absolute reference has a dollar sign before both rows and columns values

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.

Answer 2

Answer:

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

Explanation: