Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using MS Excel, find the following for the given table. Plus, write formulas on the answer.!! Discount Delivery ? ? Level ? Date Fruit 11/1/2018
Using MS Excel, find the following for the given table. Plus, write formulas on the answer.!!
Discount Delivery ? ? Level ? Date Fruit 11/1/2018 Banana 11/3/2018 Apple 11/4/2018 Banana 11/7/2018 Banana 11/9/2018 Cherry 11/12/2014 Cherry 11/18/2018 Apple 11/20/2018 Grape 11/25/2018 Cherry 11/26/2018 Banana 11/29/2018 Grape 11/30/2018 Grape Count ? Totals Sales of the month Qty Unit price SUM 5 $2.00 ? 2 $1.00 10 $5.00 7 $2.00 3 $5.00 4 $1.00 5 $1.00 1 $7.00 6 $5.00 8 $2.00 3 $7.00 2 $7.00 Banana Apple Grape Cherry Average | Max Min Total Qty Total SUM ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 1. SUM (Qty * Unit price). 2. Count (for Fruits use function COUNTA). 3. Totals (sum values for Qty. Unit price. SUM). 4. Discount (if the SUM >$25 then Discount is 10% of the SUM). 5. Delivery (for Apple and Banana is FREE, otherwise 5% of the SUM). 6. Level (if the Qty between 5 to 10 then the Level is HIGH, otherwise is space). 7. Count FREE (use function COUNTIF). 8. Count "HIGH" (use function COUNTIF). 9. Total Qty (use function SUMIF). 10.Total SUM (use function SUMIF). 11.Average, Max and Min for Total Qty and Total SUMStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started