Answered step by step
Verified Expert Solution
Link Copied!

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. image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: John J. Wild, Ken W. Shaw

2010 Edition

9789813155497, 73379581, 9813155493, 978-0073379586

Students also viewed these Accounting questions

Question

If so, what would you do?

Answered: 1 week ago