It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

# Microsoft Office 2010: Functions & Formulas

1. Formulas are equations that perform calculations on values in your worksheet. A formula starts with an equal sign (=). For example the following formula multiplies 2 by 3 and then adds 5 to the result:

Simple Formula: =A5+B2*C3; =A2/B3
1. Refer to the cell itself when creating formulas (which will pull the values   contained within the cell). That way, if a value changes in a cell, the answer to the formula changes with it.

 + means Add e.g. A2+C2 Add the value (number) in cell A2 to the value (number) in cell C2 - means Subtract e.g. A2-C2 Subtract the value (number) in cell C2 from the value (number) in cell A2 * means Multiply e.g. A2*4 Multiply the value (number) in cell A2 by 4 / means divide e.g. A2/3 Divide the value (number) in cell A2 by 3

Source: webjunction.org Functions
1. Functions are used for working with long lists of numbers and are ready-made formulas. A function may look like this: =SUM(A3:A30); =AVERAGE(A3:A30); =PRODUCT(A3:A30)
2. The colon : separates the first cell in the list from the last cell in the list.

 =SUM(B3:B9) Adds the list of values from cell B3 to cell B9 =AVERAGE (B3:B9) Averages the values from cell B3 to cell B9
 SUM adds the numbers in the list AVERAGE averages the numbers in a list PRODUCT multiplies the numbers in a list MAX indentifies the highest number in the list MIN identifies the lowest number in the list COUNT counts the number of numerical items in a list AutoSum
1. Navigate to Home Tab within your Excel workbook and then to the Editing group
2. From the Editing group, select the icon for AutoSum (sigma icon) 3. The AutoSum will add the numbers in a list within a single row or column