Guide To Writing An Effective Apush Essay

Microsoft Excel Cheat Sheet Error Codes 1. 2. 3. 4. 5.

#VALUE! – Wrong type of data. #NAME? – Incorrect function name. #NUM – Problem with one of the numbers you’re using. #REF! – Incorrect cell reference. ##### - 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)