Book: Succeeding in Business with Microsoft Excel 2013 A problem solving Approac

Question

Book: Succeeding in Business with Microsoft Excel 2013 A problem solving Approach

Page 349

Conceptual Review

17. The delivery charges used in delivery worksheet are as follows:

1.for order under $10,there is $6 delivery fee.

2. for order at least $10, but less than $40, there is a $7.50 delivery fee

3. for order over $40, delivery is free of charge.

Create a lookup table in the delivery worksheet, so that you can use a lookup function to calculate the delivery cost for each order. Organize the table in a horizontal forma, as shown here:

1 A B C D 2 Delivery Charges: 3 4

Explanation / Answer

this is look up table according to given information

A B C 1 >$10 order Delivery Charges:$6 2 order >=10$ Delivery Charges: $7.50 order <$40 3 order>$40 Free Delivery

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.