Neco 2018 Computer Studies Question 19
Practice objective / multiple choice question 19 from the 2018 Neco Computer Studies examination.
In a spreadsheet, cells A2:A6 contain sales amounts 1200, 2500, 4800, 7500 and 11000 respectively. The commission rates are: up to 2000 → 5 %; 2001-5000 → 7 %; above 5000 → 10 %. (a) Write a formula for cell B2 that can be copied down to compute the commission for each sale using nested IF. (b) Calculate the total commission payable for the five sales.
Answer Options
About This Question
This is Neco 2018 Computer Studies Question 19. It is one of the objective questions from the 2018 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.