Neco 2021 Computer Studies Question 28
Practice objective / multiple choice question 28 from the 2021 Neco Computer Studies examination.
A spreadsheet records monthly sales (in thousands of Naira) for six months in column B as follows: B2=12, B3=18, B4=25, B5=9, B6=30, B7=22. Column C contains the commission for each month calculated with the formula:\n\n`=IF(SUM($B$2:B2)<60,0.05*B2,IF(SUM($B$2:B2)<120,0.07*B2,0.10*B2))`\n\nWhat is the total commission paid for the six months (sum of C2:C7)?
Answer Options
About This Question
This is Neco 2021 Computer Studies Question 28. 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.