Gce Model Questions Vol1 2017 Computer Studies Question 20

Practice objective / multiple choice question 20 from the 2017 Gce Model Questions Vol1 Computer Studies examination.

Gce Model Questions Vol1 2017 Computer Studies Objective / Multiple Choice Hard Difficulty
Question 20 GCE_MODEL_QUESTIONS_VOL1 • 2017 • COMPUTER_STUDIES • objective

In a spreadsheet, column A contains product codes, column B the unit price (in naira), and column C the quantity sold. A discount of \(10\%\) is applied to the total sales of a product if the quantity sold exceeds 100 units; otherwise no discount is given.\n\n(a) Write a single formula that could be placed in cell D2 to calculate the net revenue for that row, using the IF function and appropriate arithmetic.\n(b) Using your formula, calculate the net revenue for a product with code "P102" where the unit price is \(\text{₦}250\) and the quantity sold is 120 units.

Answer Options

A. Formula: =IF(C2>100,B2*(C2-10),B2*C2); Result: 27500
B. Formula: =IF(C2>100,B2*C2,B2*C2*0.9); Result: 30000
Correct Answer C. Formula: =IF(C2>100,B2*C2*0.9,B2*C2); Result: 27000
D. Formula: =IF(C2>100,B2*C2*0.85,B2*C2); Result: 25500
Correct Answer
C
Correct Option:
Formula: =IF(C2>100,B2*C2*0.9,B2*C2); Result: 27000

About This Question

This is Gce Model Questions Vol1 2017 Computer Studies Question 20. It is one of the objective questions from the 2017 Gce Model Questions Vol1 Computer Studies examination.

Difficulty level: Hard .

View More Gce Model Questions Vol1 2017 Computer Studies Questions More Gce Model Questions Vol1 Practice Questions Back to Questions

Master the Exam!

You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.

Unlock Full Access Available for Android & Windows
Chat with Support