If Functions Quickstove ships worldwide and this is but a sample of shipments to
ID: 2334688 • Letter: I
Question
If Functions Quickstove ships worldwide and this is but a sample of shipments to the Western United States. When multiple quantities of an item are in the same order, quantity discounts on that item are offered. Customers are charged sales tax on all shipments within Utah where Quickstove is located as well as on shipments to Oregon where they have another facility. Sales tax is not charged on shipments to other states. Task # Points Task Description Use an IF function in Cell G15 to calculate the Net Price. There is a discount of 2% applied to the Unit Price in E15 if 2 or more items are ordered and a discount of 5% applied if 10 or more are ordered. Rerer o he appropriate discounts in cells E D EL and E 2 or our F unction arguments use a sou e and relative references when appropriate. 1 6 1Reuse your formula in cell G15 and paste it down to complete the "Net Price" column of the table. 32 Multiply the "Quantity" by the "Net Price" to get the "Sale Amt in Cell H15 1Reuse your formula in cell H15 and paste it down to complete the "Sale Amt column 4 Use an IF function in Cell 115 to calculate the Tax. There is a tax of 5% applied on shipments to Utah, 6% applied on shipments to Oregon, but no tax on shipments to other states. Refer to the appropriate tax rates in cells B10, B11 and B12 for your IF function arguments. Use absolute and relative references when appropriate. 6 3 Reuse your formula in cell 115 and paste it down to complete the "Tax" column 1 Calculate the Invoice "Total" in cell J15 8 2Reuse your formula in cell 315 and paste it down to complete the "Total" column 6 Use the SUM function to calculate the worksheet totals in cells I9, I10 and I11Explanation / Answer
Ordered ID Ship To Product ID Product Name Unit Price Quantity Net Price Sale Amount Tax Total 1003 AZ 100 QuickStove $17.55 4 17.19 68.76 68.76 1004 WA 100 QuickStove $17.55 5 17.19 85.95 85.95 1007 NV 100 QuickStove $17.55 7 17.19 120.33 120.33 1011 UT 100 QuickStove $17.55 7 17.19 120.33 6.02 126.35 1027 CA 100 QuickStove $17.55 1 17.19 17.19 17.19 1041 MT 102 Replacement Fuel Cells $4.00 1 4 4 4 1042 CA 104 Quick Stove Can $34.99 2 34.29 68.58 68.58 1050 OR 104 Quick Stove Can $34.99 8 34.29 274.32 16.46 290.78 1058 UT 104 Quick Stove Can $34.99 8 34.29 274.32 13.72 288.04 1059 AZ 102 Replacement Fuel Cells $4.00 4 3.92 15.68 15.68 1060 WA 104 Quick Stove Can $34.99 2 34.29 68.58 68.58 1062 UT 102 Replacement Fuel Cells $4.00 16 3.8 60.8 3.04 63.12 1073 CO 104 Quick Stove Can $34.99 1 34.29 34.29 34.29 1074 CO 102 Replacement Fuel Cells $4.00 5 3.92 19.6 19.6 1088 WA 102 Replacement Fuel Cells $4.00 1 3.92 3.92 3.92