Create
Learn
Share

Excel

rename
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 orderBEDMAS
BBrackets
EExponents
DDivision
MMultiplication
AAddition
SSubtraction
memorize

Functions

Question Answer
Averageshow average of values
Sumshow sum of values
Ifchoose one of two values
CountIfcounts number of cells in range that meet a criteria
Minshows smallest value in a range
Maxshows 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