Question
Select the correct text in the passage.
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.
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.
Answers
GPT-4o mini
Here are the correct statements regarding cell references from the passage:
1. An absolute address has a $ sign before both the row and the column values. (Correct)
2. The address 7B is invalid. (Correct)
The statements about relative references and mixed cell references are incorrect. A relative reference does not retain its references when copied; it adjusts based on the position of the cell it is moved to. Additionally, =A1 + $B$2 is not a mixed cell reference; it is a formula that combines an absolute reference ($B$2) with a relative reference (A1). A mixed reference would have either the column or the row fixed, but not both.
1. An absolute address has a $ sign before both the row and the column values. (Correct)
2. The address 7B is invalid. (Correct)
The statements about relative references and mixed cell references are incorrect. A relative reference does not retain its references when copied; it adjusts based on the position of the cell it is moved to. Additionally, =A1 + $B$2 is not a mixed cell reference; it is a formula that combines an absolute reference ($B$2) with a relative reference (A1). A mixed reference would have either the column or the row fixed, but not both.