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

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

Step-by-step explanation:

Answer 2

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

Step-by-step 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.