City Guilds Model Questions Vol1 2019 Information Technology Question 22
Practice objective / multiple choice question 22 from the 2019 City Guilds Model Questions Vol1 Information Technology examination.
In a spreadsheet, cell A1 contains the sales figure for year 1, which is \(\text{₦}150{,}000\). For each subsequent year (cells A2 to A5), the sales grow by a rate that depends on the previous year's sales: if the previous year's sales exceed \(\text{₦}200{,}000\), the growth rate is \(8\%\); otherwise it is \(12\%\). Using this rule, what is the sales figure for year 5 (cell A5)? Give your answer rounded to the nearest naira.
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2019 Information Technology Question 22. It is one of the objective questions from the 2019 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.