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