Write a formula in cell C13 in the Pricing worksheet to determine the total cost of making copies for this order (275 copies). Write the formula so that it works when copied into cells C14:C15.
The delivery charges used in the Delivery worksheet are as follows:
• For orders under $10, there is a $6 delivery fee.
• For orders at least $10 but less than $40, there is a $7.50 delivery fee.
• For orders 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 format, as shown here:
