Summary and Exercise- Entering Calculations

Please purchase the course before starting the lesson.

Summary

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

Exercises

Example 1

In this example you are going to use your new knowledge of creating calculations, using SUM and Copy/ Paste to do the following:

  1. In C9 to H9 create a formula that multiplies the units sold with the selling price
  2. In C11 to H11, create a simple link to the answers in C9 to H9
  3. In C13 to H13, create a calculation that uses the percentage in row 12 and multiplies  it against the sales in row 11
  4. In C15 to H15 work out the Gross Profit by subtracting Cost of Sales from Sales
  5. In D17 to H17, just link the cell to the previous cell, so D17 should link to C17 etc
  6. In C19 to H19, calculate the net profit by subtracting fixed expenses from gross profit
  7. In C23 to H23 create a calculation that takes the net profit and multiplies it with the tax rate in B21
  8. In C25 to H25, calculate the net profit after tax by subtracting Tax from Net Profit
  9. In J7 and the rest of the column, create a total for that row using the SUM function.
  10. In L7 and the rest of the column, use the AVERAGE function (same logic as the SUM function) to average the 6 months.

Example 2

In the grey cells do the following:

  1. In E10 create a Difference calculation showing the difference between actual and projected costs
  2. In C20 use a SUM to add up the projected costs
  3. In H9 add up the monthly income
  4. In H17 calculate the % Actual Costs (cell D20) make up of Actual income (cell H15)
  5. In H20 add the 10.5% to the actual cost in D20.

To see the full course contents click here.

Back to: Beginner Excel Course > Calculations in Excel