City Guilds Model Questions Vol1 2021 Information Technology Question 33
Practice objective / multiple choice question 33 from the 2021 City Guilds Model Questions Vol1 Information Technology examination.
The following data are entered in a spreadsheet (columns A-C): | A (Month) | B (Units Sold) | C (Unit Price, ₦) | |-----------|----------------|-------------------| | Jan | 120 | 15 | | Feb | 150 | 14 | | Mar | 130 | 16 | | Apr | 80 | 15 | | May | 160 | 13 | | Jun | 140 | 14 | In column D the monthly revenue is calculated as \( \text{Units Sold} \times \text{Unit Price} \). (a) Compute the overall average monthly revenue. (b) Excluding any month whose revenue is less than 75 % of the overall average, compute the average revenue of the remaining months. Give the final average revenue (rounded to the nearest whole naira).
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2021 Information Technology Question 33. It is one of the objective questions from the 2021 City Guilds Model Questions Vol1 Information Technology examination.
Difficulty level: Medium .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.