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.

Using cell references, enter a formula in cell B6 to calculate monthly payments for the loan described in this worksheet. Omit the optional arguments. Use a negative value for the Pv argument.

Enter a formula in cell B10 to return a value of 35000 if the Net Profit After Tax (cell B9) is greater than or equal to 470000 or 100 if it is not.

Write a function called calcDiscount() to calculate and return the discount amount when thefollowing are passed as the parameters.• If the inpatient is a senior citizen, value Y will be passed to the function and otherwise,value N will be passed.• If the inpatient is a loyalty member of the hospital, value Y will be passed to the functionand otherwise, value N will be passed

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)

A cash discount is provided on:Question 2Answera.Salesb.Prompt paymentc.Cash purchasesd.Purchases