Summary and Exercise- Entering Calculations
You should now be able to:
- Enter calculations into a cell
- Link to cells
- Use the SUM function, and
- Previously you learnt how to copy and paste
In this example you are going to use your new knowledge of creating calculations, using SUM and Copy/ Paste to do the following:
- In C9 to H9 create a formula that multiplies the units sold with the selling price
- In C11 to H11, create a simple link to the answers in C9 to H9
- In C13 to H13, create a calculation that uses the percentage in row 12 and multiplies it against the sales in row 11
- In C15 to H15 work out the Gross Profit by subtracting Cost of Sales from Sales
- In D17 to H17, just link the cell to the previous cell, so D17 should link to C17 etc
- In C19 to H19, calculate the net profit by subtracting fixed expenses from gross profit
- In C23 to H23 create a calculation that takes the net profit and multiplies it with the tax rate in B21
- In C25 to H25, calculate the net profit after tax by subtracting Tax from Net Profit
- In J7 and the rest of the column, create a total for that row using the SUM function.
- In L7 and the rest of the column, use the AVERAGE function (same logic as the SUM function) to average the 6 months.
In the grey cells do the following:
- In E10 create a Difference calculation showing the difference between actual and projected costs
- In C20 use a SUM to add up the projected costs
- In H9 add up the monthly income
- In H17 calculate the % Actual Costs (cell D20) make up of Actual income (cell H15)
- In H20 add the 10.5% to the actual cost in D20.
To see the full course contents click here.