CSUF Excel Lesson 5 Quiz ISDS 361 A Skordi
Solution - -https://youtu.be/a76X5xgY_ik
-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
Solution - -https://youtu.be/a76X5xgY_ik
-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
