City Guilds Model Questions Vol1 2022 Information Technology Question 25
Practice objective / multiple choice question 25 from the 2022 City Guilds Model Questions Vol1 Information Technology examination.
In a spreadsheet, column A lists months 1 to 12. Column B records the sales (in Naira) for each month. The sales for the first six months are: Jan 80 000, Feb 95 000, Mar 110 000, Apr 105 000, May 120 000, Jun 130 000; the remaining months are currently 0. Column C contains the cumulative sales up to that month, using the formula \(=SUM($B$1:B_n)\) for row n. The company's annual sales target is 1 200 000 Naira. What is the cumulative sales after June, and what average monthly sales must be achieved in the remaining six months to meet the target? Give the average to the nearest Naira.
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2022 Information Technology Question 25. It is one of the objective questions from the 2022 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.