Case AC 10-2 Stella Maroon owns the Stellar boutique in Malibu. Every month she must reconcile her inventory and take note of customer purchasing trends. One of her Paris suppliers is insisting that a blue cashmere shawl is going to be the latest trend over the next three months. Stella has some doubts, and would like to see some additional boutique sales reports to see if her clients are indeed trending towards shawls. She asks if you could assist her in creating these reports. What is a valid option selection for Stella's new report?
A) Stella can only select the Avg function.
B) The Min and Max functions cannot be selected simultaneously.
C) Stella can select the Avg, Sum, Min and Max functions simultaneously.
D) If Stella selects the Avg function, she must also select the Sum function.

Question

Quizplus · Accepted Answer

Stella should select the Avg, Sum, Min and Max functions simultaneously to get a comprehensive view of the purchasing trends. The Avg function will give the average number of items purchased, the Sum function will give the total number of items purchased, the Min function will show the minimum number of items purchased, and the Max function will show the maximum number of items purchased. This will allow Stella to see if there is a consistent trend towards purchasing shawls, and if so, what the range of purchases looks like.

Case AC 10-2 Stella Maroon Owns the Stellar Boutique in Malibu