eTool-Excel MURID 19 OGOS 2021.xlsx

	A	B	C	D	E	F
1	Guide 1. Question is written in cell A20.
2	Guide 2. There are letters and numbers from cell A5 to cell E17.
3	Guide 3. You should write your answer using given function.
4
5	Name	Stick	Loop	Ribbon	Ball	Sum
6	Ali	13.77	13.55	16.83	12.8
7	Abu	13.57	16.5	13.25	17.25
8	Adnan	16.32	15.25	16.42	15.7
9	Aminah	17.65	16.44	15.73	16.22
10	Aziz	14.44	14.87	16.5	14.4
11	Budin	14.78	16.73	15.62	16.12
12	Badrul	15.77	14.63	13.98	16.22
13	Dahlan	14.75	16.4	17.25	17.05
14	Dahlia	16.5	15.55	15.73	16.05
15	Kamal	13.22	15.98	13.35	15.44
16	Halim	13.5	14.05	15.13	15.77
17	Zainab	16.7	17.03	15.78	14.77
18
19
20	Q1. Get SUM scores of each players and round it off to two decimal places (make use of ROUND, SUM function and input result in the cell F6-F17)
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