Choose exam board for KS4 Computer Science (GCSE)
Choose exam board for KS4 English
Choose exam board for KS4 French
Choose exam board for KS4 Geography
Choose exam board for KS4 German
Choose exam board for KS4 History
Choose tier for KS4 Maths
Choose exam board for KS4 Music
Choose exam board for KS4 Physical education (GCSE)
Choose exam board for KS4 Religious education (GCSE)
Choose exam board for KS4 Spanish

Loading...

Using spreadsheet functions
  • Key Stage 2
  • Year 6
  • Computing
In this clip, I'm gonna show you how to use spreadsheet functions and the SUM function first. So I want to work out the sum and the total of game 2. So in cell B6, I'm gonna type =SUM, open brackets, and then my cell range, which is B2 to B5. I'm gonna close my bracket and then press enter. So the total of my game 2 scores is 176. Let's repeat that for the average. So let's say I want to work out the average of all of the game 1 and all of the game 2 scores in cell B6. I'm gonna type =AVERAGE and my cell range is different this time. It's A2 to B5. Close bracket and press enter. So my average score is 53. 375. Let's say I want to use the COUNT function, count how many scores I've got in total in cell B6. I'll type =COUNT. And then my cell range, open bracket, B, sorry, A2 to B5, close bracket and press enter. You can see there's eight scores in total.
Using spreadsheet functions
  • Key Stage 2
  • Year 6
  • Computing
In this clip, I'm gonna show you how to use spreadsheet functions and the SUM function first. So I want to work out the sum and the total of game 2. So in cell B6, I'm gonna type =SUM, open brackets, and then my cell range, which is B2 to B5. I'm gonna close my bracket and then press enter. So the total of my game 2 scores is 176. Let's repeat that for the average. So let's say I want to work out the average of all of the game 1 and all of the game 2 scores in cell B6. I'm gonna type =AVERAGE and my cell range is different this time. It's A2 to B5. Close bracket and press enter. So my average score is 53. 375. Let's say I want to use the COUNT function, count how many scores I've got in total in cell B6. I'll type =COUNT. And then my cell range, open bracket, B, sorry, A2 to B5, close bracket and press enter. You can see there's eight scores in total.