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)

Popular posts from this blog

History of Labor Day

-
Casting a glance back on Labor Day history is essentially about commemorating and celebrating the American Labor Movement. It is all about knowing the share that the American laborers had in building up the nation with its richness and its many achievements. The Labor Day, usually held on the first Monday in September, inspires this sense of the togetherness that workers need to feel and share in respecting their own contribution to the history of America . Labor Day is an annual recognition of all those dedicated American workers whose achievements, both socially and economically, deserve to be honored. On every Labor Day, Americans pay their tributes to those workers of strength and perseverance whose selfless efforts have added to the growth and prosperity of the American nation. Even after a century-long celebration, there is no one consistent theory about the Labor Day history. The prominent amongst these attributes the Labor Day to one Peter J. McGuire. He is the one who is cr
Read more

Relationships Ruined by the Internet

-
10 Relationships Ruined by the Internet The wife who found pictures of her husband's wedding to another woman at Facebook Lynn France, a wife who suspected her husband was having an affair, found he was actually married to another woman through a simple Facebook search. All she had to do was type in the name of the woman she believed her husband, John, was seeing. The pair had been married at Disney World , no less, with France's husband dressed as Prince Charming , and his new bride as Sleeping Beauty . There was like an album of 200 pictures there. Their whole wedding. She had grown suspicious when her husband began taking frequent business trips, even leaving the day the couple's newborn son came home from the hospital. Once, she found his passport at home when he was supposed to be in China for business. She once caught her husband with another woman in a hotel so a girlfriend recommended checking the woman's Facebook page, where France
Read more