Question: 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.!!Using MS Excel, find the following for the given table. Plus, write

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 SUM

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!