Processing data on a spreadsheet
Unlock This Video Now for FREE
This video is normally available to paying customers.
You may unlock this video for FREE. Enter your email address for instant access AND to receive ongoing updates and special discounts related to this topic.
Now what we are going to do now is just a brief look at a very simple calculation you can do on a spreadsheet. So we are back to the test doc we had, and we use this to look at what... Make a spreadsheet to create the exchange rates. So in order to do that, we have got some fields on here, this 1.3 is just a normal number field, something we can add and edit. The amount of pounds we want to do is also an edit field and we can add and change those fields, but this is a field, which is something that is doing the actual sums, so any figure that you put inbox... The box where there is 1.3 and the box in 654 pounds, will calculate this.
Let us have a look at that in a bit more detail. If we click on it, you see at the top here it's got the actual calculation. So what this sum is, we use the equal symbol to start with, so equals means, and the spreadsheet knows that is actually a calculation. The word sum, because we want to calculate something and then we put it into brackets, so we have got C7 times C5. So what this is doing is it's saying to the spreadsheet, we want to know the sum, what it equals, of these two fields, C7 and C7 was the amount of pounds we want to convert, and C5 was the exchange rate. So we want to know what the calculation is between C7 times... That is what this asterisk sign here is the C5. That is pretty much what it's doing. So if we just pop back to the spreadsheet, you will see the sum in there, so we have got C7, which is this box here, 654 pounds, times C5, 1.3. And because it's in brackets, the system knows to keep those. That is just the sum we want, and that is pretty much a very simple calculation.
Now we could change that as well, say we had that sum and it was calculating a price of something you wanted to add the VAT onto it, we can add to the end of that calculation again, the times 1.2, which would then add VAT onto the amount. So there are lots you can do with these sums and these sums could be very, very complicated, but what we are showing you there is a very simple calculation of times in one field by another field on a spreadsheet.
- EDSQ Unit 2 LO 8.3