ICDL Exam ICDL-Excel Topic 1 Question 21 Discussion

Actual exam question for ICDL's ICDL L4 Excel exam

Question #: 21
Topic #: 1

Which formula would display 7% in cell D8 if the customer's order value is over 10,000 and would display 0% if not.

A=IF (D7=10,000,7%,0%)

B=IF (D8>10000,7%,0%)

C=IF (D7>10000,7%,0%)

D=IF(D7<10000, 7%, 0%)

Show Suggested Answer

Suggested Answer: C

by Antione at May 08, 2022, 11:29 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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