CSUF Excel Lesson 5 Quiz ISDS 361 A Skordi Latest Update Graded A+

CSUF Excel Lesson 5 Quiz ISDS 361 A Skordi Latest Update Graded A+ Solution The best 3D reference function to sum up the quantity of Sweatshirts Standard on the Focused Products spreadsheets is _______________________. Select one: a. =Chapman C4 + Harbor C4 + Placentia C4 b. =C4 + C4 + C4 c. =SUM(Focused Products Sheets + C4) d. =SUM('Focused Products-Chapman:Focused Products-Placentia'!C4) d. =SUM('Focused Products-Chapman:Focused Products-Placentia'!C4) On the Focused Products Summary sheet, the quantity of Baseball Hats in inventory is ____. Select one: a. 63 b. 21 c. 54 d. 18 c. 54 On the Focused Products Summary sheet the quantity of Mugs is ________. Select one: a. 57 b. 100 c. 63 d. 32 d. 32 On the Focused Products Summary sheet, the Total quantity in inventory is _____. Select one: a. 412 b. 1001 c. 567 d. 217 a. 412 The category of products that fell below the minimum inventory limit on the Summary sheet is __________. Select one: a. Shorts b. None fall below c. Sweatshirts - Premium d. Mugs a. Shorts The total number of spreadsheets in this workbook is _____________. Select one: a. 6 b. 3 c. 4 d. 7 d. 7 The Total Retail Value of all the inventory on the Focused Products Harbor sheet is ______. Select one: a. $5,690.32 b. $3,762.00 c. $18,279.00 d. $11,212.00 b. $3,762.00 The Quantity of Mugs on the Focused Products Chapman Sheet is ____. Select one: a. 18 b. 1 c. 32 d. 3 b. 1