Order of precedence - answerSet of predefined rules used to determine sequence in which operators are applied in a calculation conditional format - answerapplies formatting to a cell when its value meets a specified condition Dynamic format - answerthe formatting can change when the cell's value changes four conditional formats - answerData bars Highlighting Color scales Icon sets Syntax - answera set of rules that specifies how the function should be written what-if analysis - answerlets you explore the impact that changing input values has on the calculated values in the workbook absolute reference - answerone that always references the same cell no matter where it is moved relative reference - answercell reference that adjusts to a new location when copied or moved mixed reference - answera cell reference that contains both relative and absolute references IF function syntax - answerIF(logical_test, [value_if_true,] [value_if_false]) VLOOKUP function syntax - answerVLOOKUP(lookup_value, table_array, col_index_num[, range_lookup=TRUE]) PMT function - answercan be used to calculate the installment payment and payment schedule required to completely repay a loan FV function - answercalculates the future value of an investment NPER function - answercalculates the number of periods required to pay off a loan or an investment NPV function - answer IRR function - answer RATE function - answercalculates the interest rate of a loan or an investment based on periodic, constant payments PPMT function - answercalculates the amount of the loan payment devoted to paying off the principal of a loan IPMT function - answercalculates the amount of a loan payment devoted to paying the loan interest Logical functions - answerIF, AND, and OR The VLOOKUP function always searches for a value in the first ______ of the lookup table - answercolumn