COPY AND PASTE THIS EXACT SPREADSHEET BELOW INTO EXCEL THE CELL NUMBERS WILL BECOME CLEAR AS IT IS IN EXCEL

1. Use the SC3 Data workbook below and save the workbook as SC3 AstroCoffee.
2. Enter the following order information: Order #: 45676 Order Date: use a function that displays the current date
3. Enter the following Billing Information: Edwina Copeland 4270 Heron Way Portland, OR 97225 503-779-1873 edwina.copeland@hmail.com
4. For the Shipping Information, create formulas using cell references to display the corresponding information from the Billing Information section. For example, the Customer cell will display the name of the customer in cell C11.
5. In the range B19:E22, enter the following item orders:

   Item #	Description	Qty	Unit Price
   K56	Dark Mocha K-Cups (12 pack)	1	10.99
   G03	Decaf Dark Roast Ground (1 lb.)	3	12.99
   B07	Dark Roast Whole Bean (1 lb.)	2	13.99
   K52	Chai Latte K-Cups (12 pack)	3	12.99

6. In cell F19, enter an IF function that tests whether the order quantity in cell D19 is greater than 0 (zero). lf it is, return the value of the Qty (in D19) multiplied by the Unit Price (in E19); otherwise, return no text by entering .
7. Copy/fill this formula into the other cells in the range F19:F25. Hint: be sure to copy the formula to all of the Item Total cells, even if it is a blank row. You want the worksheet to be prepared for orders with more items in the future.
8. In cell F26, calculate the sum of all of the Item Total cells.
9. In cell F27, use an IF function to calculate the discount amount for this order based on the customers status (which is found in F16). If the customers status is Preferred, the discount amount will be the Order Subtotal times the discount percentage found in cell B29; otherwise the discount amount will be 0 (zero). Hint: You will need to use a formula for the Value if True argument.
10. Calculate the Discounted Total for this order in cell F28. Hint: Use a simple subtraction formula.
11. In cell F29, use an IF function to display the correct Shipping Charge, based on the amount of the Discounted Total. If the Discounted Total is greater than or equal to the Free Shipping Minimum found in cell B28, the Shipping Charge is 0 (zero); otherwise, the Shipping Charge is 5% of the Discounted Total. Hint: You will need to use a formula for the Value if False to calculate what 5% of the Discounted Total will be.
12. Calculate the Invoice Total in cell F31. Hint: This will be the total of the Discounted Total and the Shipping Charge.
13. Review the worksheet in Print Preview. Make any changes needed to make the worksheet print on one page.

AstroCoffee Company 2058 Hope Street, Suite 570 Portland, OR 97209 support@astrocoffee.com www.astrocoffee.com Order #: 45676 Order Date: Shipping Information Customer: Address: Billing Information Customer: Edina Copeland Address: 4270 Heron Way Portland, OR 97225 Phone: 503-779-1873 Email: edina.copeland@hotmail.com Status: Preferred Item # Description K56 Dark Mocha K-Cups (12 pack) G03 Decaf Dark Roast-Ground (1 lb.) B07 Dark Roast - Whole Bean(1 lb.) K52 Chai Latte K-Cups (12 pack) Qty Unit Price Item Total 1 $ 10.99 12.99 3 13.99 N 3 12.99 Special Offers $200 Free Shipping Minimum 10% Preferred Customer Discount Order Subtotal Discount Discounted Total Shipping Charge Invoice Total AstroCoffee Company 2058 Hope Street, Suite 570 Portland, OR 97209 support@astrocoffee.com www.astrocoffee.com Order #: 45676 Order Date: Shipping Information Customer: Address: Billing Information Customer: Edina Copeland Address: 4270 Heron Way Portland, OR 97225 Phone: 503-779-1873 Email: edina.copeland@hotmail.com Status: Preferred Item # Description K56 Dark Mocha K-Cups (12 pack) G03 Decaf Dark Roast-Ground (1 lb.) B07 Dark Roast - Whole Bean(1 lb.) K52 Chai Latte K-Cups (12 pack) Qty Unit Price Item Total 1 $ 10.99 12.99 3 13.99 N 3 12.99 Special Offers $200 Free Shipping Minimum 10% Preferred Customer Discount Order Subtotal Discount Discounted Total Shipping Charge Invoice Total