Neco 2020 Computer Studies Question 18
Practice objective / multiple choice question 18 from the 2020 Neco Computer Studies examination.
In a spreadsheet, column A contains quantities, column B unit prices, and column C calculates the total price for each item with the formula \(=A\_i*B\_i\). A discount of 10\% is applied to any item whose total price exceeds 5,000. Write the formula for column D that gives the final payable amount for each item after applying the discount. Then, using the following data rows, compute the overall amount payable for all three items:\n- Row 1: quantity 20, unit price 150\n- Row 2: quantity 35, unit price 80\n- Row 3: quantity 50, unit price 120
Answer Options
About This Question
This is Neco 2020 Computer Studies Question 18. It is one of the objective questions from the 2020 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.