CSUF Excel Lesson 4 Quiz ISDS 361A Skordi Questions and Answers Already Passed

CSUF Excel Lesson 4 Quiz ISDS 361A Skordi Questions and Answers Already Passed Solution The complete value in cell B13 is _____________. Select one: a. $628,384.00 b. $121,616.50 c. $628,383. d. $3,000.00 c. $628,383. The complete value in cell B17 is ____________. Select one: a. $703,383. b. $750,000 c. $1,255,000 d. $703,384.01 a. $703,383. The complete value in cell D13 is ________________ Select one: a. $3,222.55 b. $3,000.00 c. $3,566.29 d. $3,566.29 b. $3,000.00 The following function would calculate monthly payment based upon the values (cells in your worksheet). Select one: a. =PMT(D6/D6, D5 *D4, -B7) b. =PMT(D6/D4, D5, -B7) c. =SUM(B7/D5*D6) d. =B7/D5*B8 b. =PMT(D6/D4, D5, -B7) The monthly payment calculated using the values given is _____________. Select one: a. $3,000.00 b. $27,000.02 c. $39,035.32 d. $3,222.55 d. $3,222.55 The rounded value in cell B17 is __________. Select one: a. $3,000.00 b. 703383. c. $3,566.29 d. $703,384 d. $703,384 Using the Payment Options results, the monthly payment for 10 years at 6.5% interest is ________. Select one: a. 7,664 b. 6,834 c. 3,000 d. 3,223 a. 7,664 Using the Payment Options results, the monthly payment for 30 years at 3.5% interest is _________________. Select one: a. $4,491 b. $3,379 c. $3,031 d. $7,837 c. $3,031