select all the correct answers. which two statements about cell references are true? in a cell address, the…

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.

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.