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

CSUF Excel Lesson 3 Quiz ISDS 361A Skordi Questions and Answers Already Passed Solution The Total Income for the year is ____________. Select one: a. $420,341.00 b. $32,916.00 c. $409,381.00 d. $543,123.00 A. $420,341.00 The Total for the year's profit/loss is _____________. Select one: a. $288,949.07 b. $420,341.00 c. $9,328.20 d. $131,391.93 D. $131,391.93 Under Option 1, the value for February's Total Expenses is ________________. Select one: a. $7,906.00 b. $24,074.25 c. $8,916.75 d. $22,469.30 B. $24,074.25 Under Option 1, the value for January's Profit/Loss is ______________. Select one: a. $19,910.80 b. $7,906.00 c. $21,333.00 d. $29,239.00 B. $7,906.00 Under Option 1, the value of the year's Profit/Loss is _______________. Select one: a. $309,418.12 b. $110,922.88 c. $131,391.93 d. $321,699.55 B. $110,922.88 Under Option 2, the value for February's Total Expenses is ______________. Select one: a. $29,239.00 b. $22,186.32 c. $25,037.22 d. $21,333.00 C. $25,037.22 Under Option 2, the value of the year's Total Profit/Loss is _______________. Select one: a. $98,641.45 b. $110,922.88 c. $321,699.55 d. $288,949.07 A. $98,641.45 The Best function for March's Bonuses Expense category is ______________. Select one: a. =SUM(D7*B30) b. =IF(D7>=$B$29, $B$30 * D7, 0) c. =IF($B$29, $B$30 * D7, 0) d. =IF(C7 >=$B$29, $B$30*C7, 0) B. =IF(D7>=$B$29, $B$30 * D7, 0) The Bonus amount for March is _____________. Select one: a. $361.98 b. $3,500.00 c. $0.00 d. $350.01 A. $361.98 The Bonus amount for February is _____________. Select one: a. $79.50 b. $284.44