FORMULAS AND FUNCTIONS Flashcards
FORMULAS AND FUNCTIONS
SUM
AVERAGE
COUNT
MAX
MIN
This function adds all the values of the cells in the argument
SUM
This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument
AVERAGE
This function counts the number of cells with numerical data in the argument. This function is useful for quickly counting items in a cell range
COUNT
This function determines the highest cell value included in the argument
MAX
This function determines the lowest cell value included in the argument
MIN
is an expression which calculates the value of a cell
Formula
are predefined formulas, and are already available in Excel
Functions
to count cells based on one criteria
COUNTIF
to count cells based on multiple criteria
COUNTIFS
to sum a range of cells
SUM
to sum cells based on one criteria
SUMIF
to sum cells based on multiple criteria
SUMIFS
checks whether a condition is met, and returns one value if TRUE and another value if FALSE
IF
returns TRUE if all conditions are true and return FLASE if any of the conditions are false
AND
returns TRUE if any of the conditions are TRUE and returns FALSE if all conditions are false
OR
to calculate the average of range of cells
AVERAGE
to average cells based on one criteria
AVERAGEIF
to find the median
MEDIAN
to find the most frequently occuring number
MODE
to calculate the standard deviation
STDEV
to find the minimum value
MIN
to find the maximum value
MAX
to find the third largest number
LARGE
to find the second smallest function
SMALL
Parts of a function
Equal sign
Function name
Argument-
can refer to both individual cells and cell ranges and must be enclosed within parentheses
Argument
