Question 8 . Question : ( TCO 2 ) The _____ number is the number of the column in the lookup table that contains the return values . lookup value column index lookup table random
Question 9 . Question : ( TCO 2 ) Arithmetic operations , cell references , and _____ can be used in Excel formulas . constants macros programs procedures
Question 10 . Question : ( TCO 2 ) To simplify entering ranges in formulas , you can use _____. range names a cell ' s relative location both an absolute and a relative cell reference a cell ' s specific location
Question 11 . Question : ( TCO 2 ) When calculating a PMT function , the RATE would be described best by which of the following ? It is the periodic interest rate , such as a monthly interest rate . It is the total number of payment periods . It is a word or a string of characters that represent one or more cells . It is the present value of the loan .
Question 12 . Question : ( TCO 7 ) A _____ helps to ensure consistency and standardization for similar workbooks , such as detailed income statements for all 12 months in a year . template macro web query function