Question 5The company gives a 1% discount on any Extra Large or larger orders. In the “Discount” column, create a 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):1 pointVLOOKUP formulaHLOOKUP formulaNested IF formulaA single IF formula (without additional formulae)

enter a formula to determine any discount that should be applied. If the payment method in column F was Rewards, the customer should receive the discount shown in B42, otherwise the formula should return a zero. Use the named range for cell B42, not the cell address, in this formula.

You want to offer a new customer a 5 percent discount on the customer's first order. If there are three items on the invoice, how will you apply the discount?Select an answer:Total the invoice items, and then enter Discount 5% below the total.Subtotal the invoice items, and then enter Discount 5% below the subtotal.Enter Discount 5 below the last item on the invoice.Enter Discount 5% below the last item on the invoice.

You need to create a field that provides the value "over" or "under" for sales, depending on whether the amount is greater than or equal to 15,000. Which type of function can you write to create this data?Select an answer:logical functions, such as IF, CONDITIONAL COLUMN, or IIFlookup functions, such as XLOOKUP, VLOOKUP, or HLOOKUPstring functions, such as CONCAT, MERGE, or REPLACE

Given an order amount, write an R script that applies a 10% discount if the order amount is more than $20. Print the final amount after discount, or the original amount if no discount is applied.

A single discount equivalent to the discount series of 20%, 10% and 5% is?