Course contents · Problem book

Formulas without functions

Open the practice in the trainer →

The topics of this module follow D. Zlatopolsky’s problem book “1700 Exercises in MS Excel”. Here you calculate with operators only: + - * / ^ and brackets.

Tasks in the trainer

  1. Rectangles: in C2:C6 calculate the perimeter.
  2. In D2:D6 — the area.
  3. In E2:E6 — the length of the diagonal (Pythagoras).
  4. In H2:H4 convert °C to °F: F = C × 9/5 + 32.
  5. In L2 calculate the average speed.

Solve the tasks in the trainer →