| A | B |
|---|
| Operand | Number or cell references used in a formula |
| Order of evaluation (operations) | Parantheses, Exponent, Multiplication/Division, and Addition/Subraction |
| Operations inside partheneses | Occur berfoe outside operations |
| Movement of absolute cell references | Changes when the formula is copied or moved |
| Manual calculations | F9 |
| Operator with highest priority | Exponents |
| Highest operator in the formula =sum(c1+b2)-(C6+C7) | Parantheses |
| Cell reference that adjusts to its new location when copied or moved | Relative |
| Formula example of mixed cell reference | $N2+l$5 |
| Example of an absolute cell reference | $b$5*$b$6 |
| Display the formula view | Ctrl+~ |
| Adds A3 and A4 | =A3+A4 |
| Subtracts A4 from A3 | =A3-A4 |
| Multiplies A3 times 27 | =A3*27 |
| Divides the value in A3 by 27 | =A3/27 |
| Raises the value in A3 to the 27th power | =A3^27 |
| Divides the value in A3 by 27 and then adds the value in A4 | =A3/27+A4 |
| Divides the value in A3 by the results of 27 plus the value in A4 | =A3/(27+A4) |
| Multiplies the value in A3 times 27 and then divides the product by the value in A4 | =(A3*27)/A4 |
| Divides 27 by the value in A4, and then multiplies the result by the value in A3 | -A3*(27/A4) |
| Raises the value in A3 to the 27th power, and then divides the results by the value in A4 | =A3^27/A4 |
