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 |
-19 |
1461 |
22 |
6520 |
1728 |
1079 |
8690 |
8107 |
9132 |
1364 |
-1202 |
6975 |
6626 |
8598 |
4947 |
6374 |
5086 |
8076 |
79 |
7411 |
-1515 |
3040 |
1720 |
720 |
6886 |
Now use conditional formatting to make the cells containing negative numbers appear blue.
Your tutor will check you have done this correctly.