Pasta B 5 4 = = = % Formatting Table Styles B1 Xfx Apply Basic Functions (SUM/COUNT/AVERAGE/MIN/MAX/countif) to the Score in the Table: D A B Q1 Apply Bask Functions (SUM/COUNT/AVERAGE/MIN/MAX/countif) to the Score in the Table: 1 2 3 4 5 ID Term 6 1 SP 2017-18 7 2 SP 2017-18 8 3 SP 2017-18 9 4 SP 2017-18 10 5 SP 2017-18 11 6 SP 2017-18 12 7 SP 2017-18 13 8 SP 2017-18 14 9 SP 2017-18 15 10 SP 2017-18 16 11 SP 2017-18 17 12 SP 2017-18 18 13 SP 2017-18 19 14 SP 2017-18 20 15 SP 2017-18 21 16 SP 2017-18 22 17 SP 2017-18 23 24 Function 25 Calculate the Total Scores 26 Calculate the average Score 27 Count the number the number of scores 28 The lowest score 29 The Highest Score 30 Count the Scores that are more than 16 31 32 Score 16 16.25 16.5 16.75 17.75 17.75 17.75 18.25 18.5 18.75 18.75 18.75 18.75 14 14 14.25 14.75 Result 01 OZ 09 & 04