• Basic Arithmetic in a cell - Addition, subtraction, multiplication, and exponentiation are done with +, 1 , *, /, and ^. The variable is replaced by a cell reference. Multiplication needs to be explicit. (We need x*y) rather than xy.) Raising to a power of e is done with the EXP() function.
One feture to remember is that Excel uses a slightly different order of operations compared to what is used in all math classes. Excel interprets -5^2 as (-5)^2 rather than -(5^2).
• Relative and absolute references - When Copying formulae from one cell to another, either with copy and paste, or with quickfil, it is important to understand relative and absolute cell references. Suppose we are moving a formula from cell A1 to cell B3. (We are going one column over and two rows down.) A relative reference changes with the formula location. =F5 becomes =G7. An absolute reference stays the same and has dollar signs, $, to fix an index. For the same move, =$F$5 stays =$F$5. We can also fix either the rows or columns by using dollar signs, $. Moving from cell A1 to cell B3, the formula =F$5 becomes =G$5 and =$F5 becomes =$F7