select all the correct answers. which two sta...
select all the correct answers. which two statements about cell references are true? in a cell address, the first value is the row and the second value is the column. a relative cell reference does not change when you copy the formula to other cells. the formula =$b4*$c4*e$2 uses a mixed cell reference. an absolute address has a $ sign before both the row and the column values. =$b$2 is an example of a relative cell reference.
Answer
# Brief Explanations:
1. In a cell address, the first value is the column and the second is the row, so the first statement is false.
2. A relative cell reference changes when copied to other cells, so the second statement is false.
3. In the formula =$B4*$C4*E$2, the $ before column in $B4 and $C4 and $ before row in E$2 make it a mixed - cell reference, so the third statement is true.
4. An absolute address has a $ sign before both the row and the column values (e.g., $A$1), so the fourth statement is true.
5. =$B$2 is an absolute cell reference, not a relative one, so the fifth statement is false.
# Answer:
C. The formula =$B4*$C4*E$2 uses a mixed cell reference.
D. An absolute address has a $ sign before both the row and the column values.