#
The domain Memorize.com is for sale!

contact: craig AT memorize.com

Updated
2010-08-04 19:59

## Summary

This page helps you to remember the basic operations and functions etc. of

*Microsoft Excel*.

## Operators

Question | Answer |

add | + |

subtract | - |

multiply | * |

divide by | / |

exponent | ^ (caret) |

= | Not equal to |

<> | Not equal to |

| memorize |

## Order of precedence

Question | Answer |

Acronym to help remember order | BEDMAS |

B | Brackets |

E | Exponents |

D | Division |

M | Multiplication |

A | Addition |

S | Subtraction |

| memorize |

## Functions

Question | Answer |

Average | show average of values |

Sum | show sum of values |

If | choose one of two values |

CountIf | counts number of cells in range that meet a criteria |

Min | shows smallest value in a range |

Max | shows largest value in a range |

| memorize |

### Examples

Question | Answer |

Average | =AVERAGE(A2:A7) |

Sum | =SUM(A2:A7) |

If | =IF(A4 > A5, "A4 is larger", "A5 is larger") |

CountIf | =CountIf(A2:A7, ">=2001") |

Min | =Min(A2:A7) |

Max | =Max(A2:A7) |

| memorize |

## Pages linking here (main versions)