Question: please help this has to do with excel spreadsheets equations. Write a formula to find the discounted price of an item. Assume cell B2 has

please help this has to do with excel spreadsheets equations.  please help this has to do with excel spreadsheets equations. 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=B2 B3 O=B3-(B3B2) O=B2-B2 B3
=B3-B3 B3 Question 5 2 pts Write the formula that will be

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=B2 B3 O=B3-(B3B2) O=B2-B2 B3 =B3-B3 B3 Question 5 2 pts Write the formula that will be entered in Cell E12, if the formula =$A$1*C11 is copied from Cell E11 to E12. =$A$1'C11 O =$A$12'C12 O =$A$13 E12 O =$A$1'C12 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. =-PMT(B3/12,B4,B1-B2) O =PMT(B2/12,B4,B1) O =PMT(B2 12,34/12,B1-B2) O=PMT(B3/12,B4 12,B) Question 7 2 pts If the formula =SUM(A1:A10) is filled/copied from cell A11 through to E11, what formula will appear in cell E11? SUM(A1:E11) =SUM(E1:10) SUM(E1:E11) =SUM(A1:A10) Question 8 2 pts 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. O = F(A15>=D15,"Passing":"Not Passing") O=IF(A15=B11,810/B4,B5) O = F(A10>=B11,811/B5,B11/B4) Question 10 2 pts Write the function that will check cell A10. If A10 is greater than or equal to B10, it will compute and display B10/B4. But if not, it will compute and display B10/B5. =IF(A10>=B10,B10/B4,B10/B5) O=IF(A10>=B10, B10/B5,B10/B4) =IF(A10>=B10,B10/B4,B5) O=IF(A10>=B10,B10/A10,B10/A10)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!