Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
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. 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)
please help this has to do with excel spreadsheets equations.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started