Excel Chapter 2 Flashcards
syntax
a set of rules that governs the structure and components for properly entering a function
TODAY function
displays the current date
absolute cell reference
indicates a cell’s specific location; the cell reference does not change when you copy the formula
argument
an input, such as a cell reference or value, needed to complete a function
MAX function
identifies the highest value in a range
COUNT function
tallies the number of cells in a range that contains values
VLOOKUP function
looks up a value in a vertical lookup table and returns a related result from the lookup table
lookup table
a range that contains data for the basis of the lookup and data to be retrieved
AVERAGE function
calculates the arithmetic mean, or average, or values in a range
MEDIAN function
identifies the midpoint value in a set of values
NOW function
displays the current date and time
IF function
evaluates a condition and returns one value if the condition is true and a different value if the condition is false
SUM function
calculates the total values contained in one or more cells
PMT function
calculates the periodic payment for a loan with a fixed interest rate and fixed term
relative cell reference
indicates a cell’s location from the cell containing the formula; the cell reference changes when the formula is copied
mixed cell reference
contains both an absolute and relative cell reference in a formula; the absolute part does not change but the relative part does when you copy the formula
logical test
an expression that evaluates to true or false
MIN function
displays the lowest value in a range
