ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
2
FunctionsSection 02/12
3
4
5
1Open 'Sheet 2'. Take a quick look at the table that is there. In column E and cells E7-E9, you must insert the same IF function three times, once in each cell. The idea is to compare whether the Net Profit of the company was higher or lower in 2006 when compared to 2005. Use the Insert Function option just next to the formula bar to solve this problem.
6
7
8
Hint: This relates to both tasks. While operating with the Insert Function window, look at the formula bar to see how the same functions could be written manually instead of using the Insert Function command.
9
2In Row number 10, namely in cells C10 and D10, insert the SUM function. It has to add the numbers from C7 to C9 and from D7 to D9 respectively.
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100