Consider the following MS-EXCEL spreadsheet:
| A | B | C | D | E | |
| 1 | Item | Quantity | Price | Revenue | |
| 2 | A - 11 | 12 | 5 | 60 | |
| 3 | B - 32 | 31 | 9 | 279 | |
| 4 | C - 44 | 24 | 12 | 288 |
If the formula = $B$2 * $C$2 is entered into cell E2, and the formula is then copied to cells E3 and E4, then the values in cells E2, E3 and E4 will be
1
60, 60 and 60, respectively.
2
60, 279 and 288, respectively
3
0, 0 and 0, respectively
4
60, 40 and 36, respectively