Gce Model Questions Vol1 2019 Computer Studies Question 12
Practice objective / multiple choice question 12 from the 2019 Gce Model Questions Vol1 Computer Studies examination.
A small shop records sales in a spreadsheet. Cells A1‑A5 contain the quantities sold: 12, 7, 5, 9, 3. Cells B1‑B5 contain the unit prices (in naira): 250, 480, 150, 320, 210. Column C uses the formula `=A1*B1` (filled down) to calculate line totals. Column D uses the formula `=IF(C1>2000,0.10*C1,IF(C1>1000,0.05*C1,0))` (filled down) to calculate a discount for each line. Column E contains the net amount with the formula `=C1-D1` (filled down). Cell E6 contains `=SUM(E1:E5)`. What numeric value will appear in E6?
Answer Options
About This Question
This is Gce Model Questions Vol1 2019 Computer Studies Question 12. It is one of the objective questions from the 2019 Gce Model Questions Vol1 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.