Neco 2021 Computer Studies Question 18
Practice objective / multiple choice question 18 from the 2021 Neco Computer Studies examination.
In a spreadsheet, column B contains the unit price and column C the quantity sold. Write the formula for cell D2 that computes total sales applying a 10 % discount on the unit price when the quantity is at least 100, otherwise no discount. Then, using the data below, calculate the sum of total sales for rows 2 to 6. Row 2: Unit Price 250, Quantity 80 Row 3: Unit Price 150, Quantity 120 Row 4: Unit Price 300, Quantity 50 Row 5: Unit Price 200, Quantity 200 Row 6: Unit Price 400, Quantity 30
Answer Options
About This Question
This is Neco 2021 Computer Studies Question 18. It is one of the objective questions from the 2021 Neco Computer Studies examination.
Difficulty level: Hard .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.