Microsoft Excel (MO-210) Certification

Access More Questions

As indicated in column E2, Company A is considering four possible projects and will approve them if the IRR is 10% or above. What is the formula in cell C2 that produces the outcomes displayed below and can be duplicated down to cells C3 through C5?

=IF(B2>=E$2,"Accept","Reject") =IF(B2>=$E$2,"Accept","Reject") =IF(B2>=$E2,"Accept","Reject") =IF(B2>=E2,"Accept","Reject")

Correct Answer:

=IF(B2>=$E$2,"Accept","Reject")

Access more questions from this quiz

Continue to Microsoft Excel (MO-210) Certification for more practice questions and the full quiz experience.

Access More Questions