Neco 2023 Computer Studies Question 11
Practice objective / multiple choice question 11 from the 2023 Neco Computer Studies examination.
In a spreadsheet, cells A2:A6 contain quantities 12, 7, 15, 9, 20 respectively and cells B2:B6 contain unit prices 250, 340, 180, 410, 150 respectively. Column C computes the total price for each row as (C = A \times B). Column D applies a discount using the formula (D = \text{IF}(C>3000,\;0.9\times C,\;C)\). What is the sum of the values in D2:D6?
Answer Options
About This Question
This is Neco 2023 Computer Studies Question 11. It is one of the objective questions from the 2023 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.