Basic Math Operations
Basic Math Operators+ Addition
- Subtraction
/ Division
* Multiplication
^ Exponent
( ) Parenthesis, as need, follows algebraic precedence
Selecting Ranges
Use mouse to drag from top to bottom, or side to side
Select rectangular area by dragging to diagonal corners or using [shift] key
Select disconnected columns/rows by using [ctrl] key
Select a long row/column by using [ctrl][shift][end] key sequence
Basic Math Functions
SQRT(x) -returns the square root of a number ABS(x) -returns the absolute value of a number MAX(range) - returns the largest number in a set of values MIN(range) -returns the smallest number in a set of values COUNT(range) -counts the number of cells in a range
that contain numbers COUNTA(range)-counts the number of cells in a range that are
not empty STDEV(range) -estimates the standard deviation based
on a sample
Trigonometry Functions
Excel uses Radians by default in all trig functions Use RADIANS and DEGREES functions to
convert RADIANS(x) -converts degrees to radians where x
is given in degrees
DEGREES(x) -converts radians to degrees where x is given in radians
Trigonometry Functions
SIN(x) - returns the sine of an angle where x is in given in radians
COS(x) - returns the cosine of an angle where x is given in radians
TAN(x) - returns the tangent of an angle where x is given in radians
ASIN(x) - returns the arcsine of a number in radians, in the range –pi/2 to pi/2
ACOS(x) - returns the arccosine of a number in radians, in the range 0 to pi
ATAN(x) -returns the arctangent of a number in radians, in the range –pi/2 to pi/2
Logical Operators
IF(logical test, value if true, value if false) -checks if a condition is met, returns one value if True, another value if False
AND(logical1,logical2,…) -returns True if all arguments are true, otherwise returns False
OR(logical1,logical2,…) -returns True if any argument is true, returns False only if all arguments are False
NOT(logical) -returns True if argument is False, returns False if argument is True