EXCEL SPREADSHEETS.

Need urgent help.

Write a formula to find the discounted price of an item. Assume cell B2 has the original full price. The percentage by which the price is being reduced is in cell B3. O=B2B3 O =B3-(B3-B2) O=B2-B2 B3 O=B3-B3B3 Write a formula to calculate the monthly payment for a loan where the purchase price is in cell B1, the down payment is in cell B2, the APR is in B3, and the number of payments is in B4. O = PMT(B3/12,B4,B1-B2) O=PMT(B2/12,B4,B1) O =PMT(B2*12,B4/12,B1-B2) O =PMT(B3/12,B4 12.B) If the formula =SUM(A1:A10) is filled/copied from cell A11 through to E11, what formula will appear in cell E11? O =SUM(A1:E11) O ESUM(E1:E10) O =SUM(E 1:E11) 0 =SUM(A1:A10) Write the function that will check your grade percentage (in A15) to see if it is at least as high as the percentage required to pass (in D15), display Passing. But if not, display Not Passing. =IF(A15>=D15"Passing" Not Passing") O=IF(A15