Read the following spreadsheet (MS-EXCELL):
EXCEL Spreadsheet
| A | B | C | |
| 1 | 10 | 16 | |
| 2 | 20 | ||
| 3 | 8 | ||
| 4 | 12 | ||
| 5 | 0 |
The equation in cell B2 is = A2 + B1.
This equation is then copied and pasted to cells B3, B4 and B5. What should be the value in B5?
1
36
2
24
3
44
4
56
Read the following spreadsheet (MS-EXCELL):
EXCEL Spreadsheet
| A | B | C | |
| 1 | 10 | 16 | |
| 2 | 20 | ||
| 3 | 8 | ||
| 4 | 12 | ||
| 5 | 0 |
The equation in cell B2 is = A2 + B1.
This equation is then copied and pasted to cells B3, B4 and B5. What should be the value in B5?