ICDL Exam ICDL-Excel Topic 1 Question 37 Discussion

Actual exam question for ICDL's ICDL L4 Excel exam

Question #: 37
Topic #: 1

Which formula would display 10% in cell C3 if the customer order quantity is over 300, and 0% if not.

A=IF(C3>300,10%,0%)

B=IF (B3>300, 10%, 0%)

C=IF (B3>300, 0%, 10%)

D=IF (B3<300, 10%, 0%)

Show Suggested Answer

Suggested Answer: B

by Natalie at May 05, 2022, 02:44 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!