Data
House Class Average of Final TesSum of Unit Test 2Sum of Unit Test 1
Agni 6 94 81 91
8 98 96 91
9 95.5 178 174
10 86.5 173 174
Agni Result 92.6666666666667 528 530
Bhoomi 81.25 322 306 This shape represents a
Jal 7 89 184 172 slicer. Slicers are
8 88 78 81 supported in Excel 2010
or later.
10 87 160 162
Jal Result 88 422 415 If the shape was modified
Vayu 5 91 83 82 in an earlier version of
6 92 90 88 Excel, or if the workbook
was saved in Excel 2003
8 92 176 171 or earlier, the slicer cannot
9 95 89 87 be used.
10 92 180 140
Vayu Result 92.2857142857143 618 568
Total Result 89.4090909090909 1890 1819
presents a
are
Excel 2010
was modified
version of
e workbook
Excel 2003
slicer cannot
pivot table
Name Gender Age Class House Unit Test 1Unit Test 2Final Test
AbhimanyuM 16 10 Bhoomi 84 79 81
Arjun M 11 5 Vayu 82 83 91
Champa F 15 8 Jal 81 78 88
Gopal M 14 8 Bhoomi 70 75 79
Gopi F 16 10 Agni 88 92 96
Hari M 16 10 Bhoomi 82 81 80
Indu F 14 8 Vayu 90 86 89
Keshav M 15 9 Agni 87 89 96
Lalita F 17 10 Vayu 70 90 92
Madhav M 12 7 Jal 86 92 89
Sam M 11 6 Agni 91 81 94
RNM M 16 10 Agni 86 81 77
Student1 M 15 9 Agni 87 89 95
Student8 F 15 8 Vayu 81 90 95
Student2 F 17 10 Vayu 70 90 92
Student4 F 12 7 Jal 86 92 89
Student5 F 16 10 Jal 81 80 87
Sudevi F 16 10 Jal 81 80 87
Varun M 15 9 Vayu 87 89 95
Vidya F 11 6 Vayu 88 90 92
Visakha F 16 10 Bhoomi 70 87 85
Vrinda F 14 8 Agni 91 96 98
161 161 161
161 252
161 322
