ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions
2
Get the "Bonus" using the following equation:
3
Bonus = Salary * Bonus % in cell L2
4
Get the "Total Salary" using the following equation:
5
Total Salary = Sum of the Salary, the Bonus and the Rewards
6
Get the allowance using the following equation:
7
Allowance = Salary * Allawance % (Use the allawance% table)
8
Get the taxes using the following equation:
9
Taxes = Salary * Tax% (Use the Tax% table)
10
For the Statistics Table - Answer all the questions.
11
For the "Table 1" - Find the (Total Salary, Number of Employees and Average of Salary) according to the Job.
12
For the "Table 2" - Find the (Total Salary, Number of Employees and Average of Salary) according to the Job and the Department.
13
For the "Table 3" - Find the (Total Salary, Number of Employees and Average of Salary) according to the Job and the Department.
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