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
