Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 4/7

Add, subtract, multiply, divide

Exercise 1 of 4

In B3, add the sales of shop A and shop B.

About this lesson

Formulas start with =. Here you use +, -, * and / to add, subtract, multiply and divide the numbers in the sheet.

In this lesson

  1. In B3, add the sales of shop A and shop B.
  2. In B3, work out how much of the budget is left.
  3. In D2, work out the total for the pens: price times quantity.
  4. Four friends share a bill. In B3, work out how much each person pays.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in B3 and press Enter to check.