chapter 2 Flashcards
relative cell reference
copied references are updated to new locations
absolute cell reference
copied references do not change
what is the shortcut for an absolute cell reference
F4 key
mixed cell reference
only the row or column will change when copied
3D cell reference
a cell located in another worksheet(it can be absolute, mixed, or relative)
trace precedents
displays lines with arrows to identify all cells referenced in the formula in the active cell
trace dependents
display lines with arrows to all cells that use the active cell directly or indirectly in a formula
COUNT (count numbers)
counts the cells that contain values with a range
COUNTA
counts the cells that contain any data type within a range
COUNTBLANK
counts empty cells in a range
COUNTIF
counts the cells that meet the criteria argument within a range
COUNTIFS
counts the cells in one or more criteria ranges that meet respective criteria arguments
PMT function
calculates a constant loan payment amount for a period of time at a stated interest rate
What are the five arguments of the PMT function?
- Rate: yearly
- Nper: total number of periods till repayment
- Pv: present value
- Fv: any amount still owed at end of the loan
- Type: payment at beg. or end of a period?
IF function
logical_test, value_if_true, value_if_false
VLOOKUP function
displays a piece of data from a range of cells in another part of the workbook
what are the four arguments of a VLOOPUP function?
- lookup_value: the data to be found or matched
- table_array: a range of cells
- col_index_num: sets which column in the table_array contains the data to display in the result
what are the four arguments of an HLOOKUP function?
- lookup_value: the data to be found or matched
- table_array: a range of cells
- row_index_num: sets which row in the table_array contains the data to display in the result
what are the two arguments of the round function?
- number: cell or value to be adjusted
- num_digits: # of decimal places for rounding
what are the three arguments of a SUMIF function?
- range: the range of cells to be evaluated
- criteria: argument defines which cells from the range should be included in the sum
SUMPRODUCT function
it multiplies the cell identified in its array arguments and then it totals those individual products
what is the syntax for a SUMPRODUCT function?
=SUMPRODUCT(array 1, array 2)
