1. Using your newly created "Expanded Order Type" column, calculate the total "Sales" for all orders of "Medium" type (rounded to 2 decimal places). Hint: The SUMIF() function is useful here.
2. The company gives a 1% discount on any Extra Large or larger orders. In the "Discount" column, Write the formula that returns 0.01 if the "Expanded Order Type" is Extra Large, XX Large, or XXX Large, and returns 0 otherwise. You can accomplish this by using a (select all that apply):
3. Create the formula from the previous question and copy the formula down to all the rows. How many orders will have a discount applied?Hint: The COUNTIF() function is useful here.
4. The "Sales with Discount" can be calculated by applying the discount to the original "Sales" entry:

Sales with Discount = Sales - (Sales * Discount)

or

Sales with Discount = Sales * (1 - Discount)

Write the formula in the "Sales with Discount" column and copy it down to all the rows. What is the impact of the discount on total sales in 2012? In other words, what is the difference between the sum of the "Sales" and the sum of the "Sales with Discount" (rounded to 2 decimal places)?

5) Currently, customers are responsible for paying the shipping costs. The sales team suggests that customers really dislike paying shipping costs, and that offering "free shipping" instead of the 1% discount would likely increase sales. Write the formula for the "Sales with Free Shipping" column that subtracts the "Shipping Cost" from the "Sales" only if the "Expanded Order Type" is Extra Large, XX Large, or XXX Large. Copy the formula down to all the rows. What would total 2012 sales have been if the company had offered free shipping instead of the 1% discount (rounded to 2 decimal places)?