SOB 125 [Typical]
Open Excel and copy the following data into a spreadsheet:
| Year |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
24 |
25 |
| Profit/Loss |
4353 |
111 |
-1898 |
3447 |
-232 |
-1000 |
287 |
2186 |
-1481 |
5769 |
-1543 |
1928 |
8720 |
2727 |
2406 |
5714 |
1680 |
-167 |
-1014 |
1453 |
932 |
720 |
6549 |
9868 |
8465 |
Now use conditional formatting to make the cells containing negative numbers appear red.
Your tutor will check you have done this correctly.