Pick the correct statements regarding cell references. a relative reference will retain its references when copied to another cell. an absolute address has a $ sign before both the row and the column values. = a1 + $b$2 is an example of a mixed cell reference. the address 7b is invalid.

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.