Q1. If I changed cell D3 to 400, then what number would appear in cell E3?
£4, 000.00
Q2 If I changed the ticket price to £12 then what number would appear in cell E3?
£4, 800
Now that you understand the basics of a multiplication formula then It’s time to work out a few for yourself.
The next screenshot just shows that at our club in fact some people got in on the guest list, some of the guests got in for a pound and some got in for half price.
Considering this screen shot:
Q3. What formula would be entered into cell E3?
=C3*D3
Q4. What formula would be entered into cell E4?
=C4*D4
Q5. If the entry in cell C3 was changed, what other cell would change as a result?
E3
Q6. If the entry in cell D4 was changed, what other cell would change as a result?
E4
Now you don’t need to be a business studies student to realise that when you are running a night-club you are going to make more money then just from the tickets that you sell. You will sell drinks from the bar and maybe even charge people to have a table where they can sell clothing and other things. So in fact what we would have is a list of money coming in something like the worksheet below.
As we can see from the spreadsheet on the previous page we can see that the income from lager, cider and bottles is worked out in the same way as the guest list – it’s a simple multiplication just like before. So in that case answer the following question.
Q7 What formula would be in cells E4, E5 and E6?
=C4*D4 , =C5*D5, =C6*D6 .
Now from the previous screenshot we can see that the total money made at the bar was £5,210 and this can be shown in cell F6.
To work this total out all that happened is that the figures in cells E4, E5 and E6 were added together. So the formula in cell F6 would look like the one below
=E4+E5+E6
Q8 What formula should be entered into cell F11?
=E9+E10+E11
Q9 What formula should be entered into cell F14?
=F6+F11
Now I am sure that it doesn’t require you to study business or economics to realise that companies don’t just have money coming in. To run their business there is plenty of money going out as well. The next screenshot shows the entire records of all the money in and out on the night.
So we start with all our income at the top of the spreadsheet but of course we then have to list all of our costs and take them away.
Let’s focus on cell G23 where we can see that the costs (except drinks) for the night. Certainly if we add them all up one by one then we could end up with the formula
=F18+F19+F20+F21+F22+F23
As you can see this is getting a bit long winded and it’s pretty easy to make a mistake as you go along. This formula can be re-written as
=SUM(F18:F23)
In other words add up all the cells from F18 through to F23 inclusive.
In that case to finish off this section.
Q10 Using the SUM function write the formulae for cells G6, G11 and G28.
=sum(G6+G11+G28)
Q11 What formulae would be in cells G30 and G33?
=G27+G33