-
A predefined formula that performs calculations by using specific values in particular order or structure
Function
-
Excel functions such as AVERAGE that are useful to analyze agroup of masurements
Statistical Functions
-
A predefined formula that adds all the number in a seelected range
SUM Function
-
A function that adds a group of values, and then divides the result by the number of values in the group
AVERAGE Function
-
A function that finds the middle value that has as manyvalues above it in the group as are below it
MEDIAN Function
-
A function that determines the smallest value in a range
MIN Function
-
A function that determines the largest value in a range
MAX Function
-
The action of moving a selection by dragging it to a new location
Drag and Drop
-
A group of functions that tests for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false.
Logical Functions
-
Conditions that you specify in a logical function
Criteria
-
A statistical function that counts the number of cells within a range that meet the given condition and which has two arguments--the range of cells to check and the criteria
COUNTIF Function
-
Any value or expressin that can be evaluated as being true or false
Logical Test
-
A function that uses a logical test to check whether a condition is met, and then returns one value if true, and another value if false
IF Function
-
Symbols that evaluate each value to determine if it is the same, greater than, less than, or in between a range of values as specified by the criteria
Comparison Operators
-
A format that changes the appearance of a cell based on a condition
Conditional Format
|
|