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 |
8635 |
934 |
1079 |
7008 |
-1563 |
2547 |
6275 |
230 |
1732 |
9521 |
8460 |
8208 |
4278 |
3769 |
-566 |
4444 |
8456 |
5068 |
6884 |
1098 |
2625 |
-1429 |
3543 |
6093 |
2578 |
Now use conditional formatting to make the cells containing negative numbers appear green.
Your tutor will check you have done this correctly.