Answered step by step
Verified Expert Solution
Link Copied!

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.!!image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Finance A Practical Perspective

Authors: Adrian Buckley

1st Edition

0273731866, 9780273731863

More Books

Students also viewed these Accounting questions

Question

For financial reporting purposes, how should inventory be measured?

Answered: 1 week ago

Question

=+What about SRI funds? Why, or why not?

Answered: 1 week ago