5. Which statement about financial functions is NOT accurate? A. When the value in a separate input cell changes, any formula that refers to that input cell automatically updates. B. The Type argument shows when payments are due (beginning or end of a period). C. Use a financial function to determine how long it will take to pay off a debt, such as a car loan. D. In financial functions, payments are considered negative values. 6. Match each financial function argument to its description. FUNCTIONS A. Nper www B. Pmt C. Pv D. Fv 7. What is a data table? DESCRIPTIONS 1. The original loan or investment amount 2. The total number of payments made over the life of the loan 3. The ending balance of a loan (0) or the investment maturity 4. The amount invested each period of the investment A. An analysis tool that allows you to examine multiple input values simultaneously B. The table type to create when you know you'll need to sort and filter the data C. Where you enter the variables in a goal seek D. A container for the function arguments 8. Identify the accurate statement regarding one-variable data tables. A. There can be only one input row, but there's no limit to the number of columns. B. A total row is required at the bottom of the column. C. The formula argument must be a cell reference and not an actual value. D. The formula must be positioned in the upper-left cell of the table.