Updated
20100804 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)

