City Guilds Model Questions Vol1 2021 Information Technology Question 3
Practice objective / multiple choice question 3 from the 2021 City Guilds Model Questions Vol1 Information Technology examination.
In a spreadsheet the monthly sales (in units) for three products over the first six months are entered as follows:\n\nProduct X: 120, 135, 150, 165, 180, 210\nProduct Y: 200, 190, 210, 220, 230, 240\nProduct Z: 80, 85, 90, 95, 100, 110\n\n(a) Write a formula that computes the average monthly growth rate of Product X using the expression \(((\text{last}\,/\,\text{first})^{1/5})-1\).\n(b) Using the growth rate from (a), predict the sales for the seventh month (July) for Product X.\n(c) Does the predicted July sales exceed 150 % of the average of the first‑month sales of all three products? Answer Yes or No.
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2021 Information Technology Question 3. 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.