Which of the following statement is incorrect regarding cell reference in MS-Excel 2007?
1
C$5 and $C5 are examples of mixed cell references.
2
C$5 is an example of a relative cell reference.
3
$C$5 is an example of an absolute cell reference.
4
A cell reference identifies the location of a cell that can be used in a formula, function, or other Excel command.
5
None of the above