Gce Model Questions Vol1 2021 Computer Studies Question 6
Practice objective / multiple choice question 6 from the 2021 Gce Model Questions Vol1 Computer Studies examination.
In a spreadsheet, cells B2:D5 contain monthly sales (in naira) for products A, B and C. The total sales for each product are calculated in row 6 using the formula \(=SUM(B2:B5)\) for product A, \(=SUM(C2:C5)\) for product B and \(=SUM(D2:D5)\) for product C. Cell B7 (commission for product A) contains \(=IF(B6>5000, B6*0.08, B6*0.05)\). Cells C7 and D7 calculate commission using a VLOOKUP: \(=C6*VLOOKUP(C6,$G$1:$H$3,2,TRUE)\) and \(=D6*VLOOKUP(D6,$G$1:$H$3,2,TRUE)\) respectively, where the lookup table in G1:H3 is: \(\begin{array}{c|c} \text{Threshold (\pounds)} & \text{Rate}\\\hline 0 & 0.04\\ 3000 & 0.06\\ 6000 & 0.09\\ \end{array}\) The overall commission is in cell E7 with the formula \(=B7+C7+D7\). The sales data are: - January: A 1200, B 2500, C 1800 - February: A 1500, B 3200, C 2100 - March: A 1700, B 2900, C 2400 - April: A 1900, B 3400, C 2600 What is the overall commission (in naira) displayed in E7?
Answer Options
About This Question
This is Gce Model Questions Vol1 2021 Computer Studies Question 6. It is one of the objective questions from the 2021 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.