Microsoft Excel Cheat Sheet
Error Codes
1. #VALUE! – Wrong type of data.
2. #NAME? – Incorrect function name.
3. #NUM – Problem with one of the numbers you’re using.
4. #REF! – Incorrect cell reference.
5. ##### - Formula cannot be displayed in the cell using the current number format.
Math and Statistical Functions
1. ROUND( number to round, #of digits)
a) (3.987, 2) = 3.99
b) (3.987, 0) = 4
c) (34655.7, -2) = 34,700
2. ROUNDDOWN
a) (1.1, 0) = 2
3. ROUNDDOWN
a) (1.9, 0) = 1
4. MROUND (number to round, multiple)
a) (653, 5) = 655
5. COUNT – Find out how many items there are in a list.
6. COUNTBLANK – Counts the number of empty cells in a specified range of cells.
7. RANK – Returns the rank of a number in a list of numbers: its size relative to the other
values in the list.
8. REPT – Repeats text a given number of times.
9. SQRT – Returns the square root of a number.
10.STDEV – Estimates the standard deviation of a sample.
11.PERMUT – Returns the number of permutations for a given number of objects that can
be selected from the total objects.
12. COMBIN – Returns the number of combinations for a given number of items.
13.WEEKDAY – The WEEKDAY function takes a date, and returns a number that
represents which day of the week that date falls on. For example, if the date occurs on
Sunday, the number’s 1, on Monday it’s 2, right up to Saturday, which is 7.
a. WEEKDAY( date, (return-type)
I. (DATE (2007, 1, 6) = 7.
14.MAX ( ), MIN ( ) – “ pick the largest or smallest value out of a series of cells.
15. LARGE, SMALL – (range, position)
1. #VALUE! – Wrong type of data.
2. #NAME? – Incorrect function name.
3. #NUM – Problem with one of the numbers you’re using.
4. #REF! – Incorrect cell reference.
5. ##### - Formula cannot be displayed in the cell using the current number format.
Math and Statistical Functions
1. ROUND( number to round, #of digits)
a) (3.987, 2) = 3.99
b) (3.987, 0) = 4
c) (34655.7, -2) = 34,700
2. ROUNDDOWN
a) (1.1, 0) = 2
3. ROUNDDOWN
a) (1.9, 0) = 1
4. MROUND (number to round, multiple)
a) (653, 5) = 655
5. COUNT – Find out how many items there are in a list.
6. COUNTBLANK – Counts the number of empty cells in a specified range of cells.
7. RANK – Returns the rank of a number in a list of numbers: its size relative to the other
values in the list.
8. REPT – Repeats text a given number of times.
9. SQRT – Returns the square root of a number.
10.STDEV – Estimates the standard deviation of a sample.
11.PERMUT – Returns the number of permutations for a given number of objects that can
be selected from the total objects.
12. COMBIN – Returns the number of combinations for a given number of items.
13.WEEKDAY – The WEEKDAY function takes a date, and returns a number that
represents which day of the week that date falls on. For example, if the date occurs on
Sunday, the number’s 1, on Monday it’s 2, right up to Saturday, which is 7.
a. WEEKDAY( date, (return-type)
I. (DATE (2007, 1, 6) = 7.
14.MAX ( ), MIN ( ) – “ pick the largest or smallest value out of a series of cells.
15. LARGE, SMALL – (range, position)
