**About Formulas **

1. * Formulas* are equations that perform calculations on values in your worksheet.

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*. A function may look like this:

2.

=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

2. From the Editing group, select the

3. The AutoSum will add the numbers