The topics of this module follow D. Zlatopolsky’s problem book “1700 Exercises in MS Excel”. Here you calculate with operators only: + - * / ^ and brackets.
- The order of operations is the same as in maths:
^first, then*and/, then+and-. Brackets change the order. - A square root is the power ½:
=(A2^2+B2^2)^0.5(or theSQRTfunction). - Write the formula for the first row once and copy it down.