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.
This site uses cookies to store information on your computer. Some of these cookies are essential, while others help us to improve your experience by providing insights into how the site is being used.