answer multiple choice questions

A client who is purchasing a car knows the purchase price, interest rate on financing the car, and number of payments. She asks you to calculate monthly payments. The payment (PMT) function can be found in: (Select all that apply). Please add checkmark next to the correct answer(s). 1 A. Formulas-Function Library-Financial. 2 B. Home-Editing-Dropdown at Auto Sum (frequently used functions)-More Functions-Search for a Function. 3 C. Insert-Function. 4 D. Data-Payments. 5 E. View-PMT. 6 F. Help-PMT. * 72A The NPER function from the Financial Function Library is used to calculate number of periods in a time value of money problem. Yes No When using the PV financial function, typing =PV( into a cell will bring up the arguments to be input into the function. What does [type] refer to? Please add checkmark next to the correct answer(s), 1 A. Whether the interest rate is fixed or variable. 2 B. A payment made by check or cash. 3 C. Whether a payment is paid (or received) at the beginning of the month or the end of the month. 4 D. Whether the number of periods are months or years. 74A The following arguments in the present value (PV) function are needed to solve a problem about a single sum of money to be received in the future: (Select all that apply). Please add checkmark next to the correct answer(s). 1 A. PMT for payment. 2 B. RATE for interest percent for each period. 3 C. NPER for number of periods. 4 D. PV for present value. 5 E. FV for future value. 275A The format of an IF statement is: Please add checkmark next to the correct answer(s). 1 A. Logical test, value if true, value if false. 2 B. Logical test, nested test, value if true. 3 C. Logical test, value if false, value if true. 4 D. Logical test 1, logical test 2, value if false, value if true. An IF statement that would confirm that every cell in a column has a negative number in it is formulated as: Please add checkmark next to the correct answer(s). C.=IF(B4>0, "Yes", "No") and then copy this formula relatively through the column. 4 D. =IF(B4