Review tasks (1)
When turning a mathematical expression into a formula, write * for multiplication, use ^ for powers, SQRT for the square root and a cell address in place of x: the expression 5x² + 3√x – 4 becomes =5*A1^2+3*SQRT(A1)-4. Testing divisibility: =IF(MOD(A3; 4)=0; "divisible"; "not divisible"). The largest number in several blocks: =MAX(B2:B6; E2:E4). In text, REPLACE("computer"; 4; 3; "XYZ") replaces 3 characters from the 4th and gives "comXYZer". To check whether an equality is an identity, for example (x+3)^2 = x^2+6x+9, we calculate both sides for several values and compare them with IF; with decimals apply ROUND before comparing, because the computer stores fractions approximately. Compound interest: an amount B at M per cent a year after A years is =B*(1+M/100)^A. After writing a formula, test it with edge values.
| Expression | Formula |
|---|---|
| 5x² + 3√x – 4 | =5*A1^2+3*SQRT(A1)-4 |
| B · (1 + M/100)ᴬ | =B*(1+M/100)^A |
The teacher said, “Double the number and add 3.” The pupils wrote this as “x·2+3” and also tried it on two other numbers.
Programmers and engineers turn a rule given in words into a formula.
Write an everyday rule, such as “triple the number and subtract 2”, as a formula and test it with 3 numbers.
“Formula translators”: groups write a mathematical expression in a notebook, another group turns it into a sheet formula; then they compare values by hand and in the sheet.