Cell C3 of the spreadsheet contains the following formula:
=A1-$A$2
Which of the following statement is true?
1
If the contents of cell A2 are changed, the output displayed in cell C3 will also change.
2
If the contents of cell A2 are changed, the output displayed in cell C3 will not change.
3
If the contents of class A1 are changed, the output displayed in cell C3 will not change.
4
The contents of cell A2 cannot be changed.