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.