"Intech Copy Standards"
Formulas to the Rescue! A spreadsheet formula is a set of instructions that looks like and calculates like a mathematical equation. In fact, spreadsheet formulas begin with an equal sign (=). The = sign tells the spreadsheet to perform the mathematical operations that follow. When writing formulas for Excel, you will want to use the formula toolbar. From the menu bar, choose View> Formula Bar. You can create formulas that use cell references. For example, if you wanted to create a formula that would give results based on the value of a specific cell, you can include the “cell address” in the formula. Changing the values in one cell is easier than rewriting the formula in another cell every time a change is made. + means add - means subtract * means multiply / means divide Practice writing formulas by using the numbers provided below: Complete the spreadsheet by writing the formulas with cell references as follows: A. In C1, enter a formula to multiply cell A1 by B1. B. In C2, enter a formula adding cell A2 to B2. C. In C3, enter a formula subtracting cell A3 from B3. D. In C4, enter a formula dividing cell A4 by B4. Complete your calculation by clicking on the checkmark in the formula bar or pressing return. Page 1 of 1 KCS.SR 02.16.05v.1.0.1