8.4 5. Formulas - Exercise - Unsolved.xlsx.xlsx

	B	D	J
1
2	Formulas		Section 02/11
3	Formulas		Section 02/11
4
5	1	Assuming that Gross Profit = Net Sales - Cost of Goods Sold (CoGS), insert a formula in D2 that will reflect this to the information provided in cells B2 and C2.
6	1
7
8
9	2	Replicate the same task for cells D3, D4, D5 and D6.
10	2	Replicate the same task for cells D3, D4, D5 and D6.
11
12	Hint: Actually, you can insert the formula only once in cell D2 and then drag it down to D6. If you are a bit "lazy", you might want to opt for this trick.
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