Get ahead with a $300 test prep scholarship
| Enter to win by Tuesday 9/24
Excel - Chapter 2
Terms in this set (20)
Absolute cell reference
A designation that provides a permanent reference to a specific cell. When you copy a formula containing an absolute reference, the cell reference in the copied formula does not change, regardless of where you copy the formula. An absolute cell reference appears with a dollar sign before both the column letter and the row number, such as $B$4.
A variable or constant input, such as cell reference or value, needed to complete a function. The entire group of arguments for a function is enclosed in parentheses.
A statistical function that calculates the arithmetic mean, or average, of values in range.
A situation that occurs when a formula contains a direct or an indirect reference to the cell containing the formula.
A statistical function that tallies the number of cells in a range that contain values you can use in calculators, such as the numerical and date data, but excludes blank cells or text entries from the tally.
A logical function that evaluates condition and returns one value if the condition is true and different condition if the value is false.
An expression that evaluates to true or false; the first argument in an IF function.
A range that contains data for the basis of the lookup and data to be retrieved. In vertical lookup table, the first column contains a list of values to compare the lookup value. In a horizontal lookup table, the first row contains a list of values to compare the lookup value.
A statistical function that finds the highest value in range.
A statistical function that finds the midpoint value, which is the value that one half of the values in a list are above or below.
A statistical function that finds the lowest value in range.
Mixed cell reference
A designation that combines an absolute reference with a relative cell reference, such as $B4 or B$4.
A date & time function that uses the computer's clock to display the current date and time in a cell.
A financial function in Excel that calculates the periodic loan payment.
A word or string of characters assigned to one or more cells. It can be up to 255 letters, characters, or numbers but must start with a letter or underscore and have no spaces or special symbols.
Relative cell reference
A designation that indicates a cell's relative location within the worksheet using the column letter and row number, such as B5. When a formula containing a relative cell reference is copied, the cell reference is copied, the cell reference in the copied formula change relative to the position of the copied formula.
A statistical function that calculates the total values contained in two or more cells.
The rules that dictate the structure and components required to perform the necessary calculations in an equation or to evaluate expressions.
A date & time function that displays the current date in a cell.
A lookup & reference function that looks up a value and returns a related result from the lookup table.