City Guilds Model Questions Vol1 2019 Information Technology Question 32
Practice objective / multiple choice question 32 from the 2019 City Guilds Model Questions Vol1 Information Technology examination.
In a spreadsheet, column A contains the monthly sales figures (in naira) for five consecutive months: \(12\,000\), \(15\,000\), \(18\,000\), \(21\,000\) and \(24\,000\). Column B contains the corresponding monthly cost figures: \(9\,500\), \(9\,500\), \(11\,000\), \(13\,000\) and \(15\,000\). In cell C2 the analyst enters the formula \(= (A2-B2)/A2\) to obtain the profit‑margin as a decimal and copies it down to C6. The analyst then wishes to know the average profit‑margin (as a percentage, rounded to one decimal place) for those months whose profit‑margin exceeds \(30\%\). Determine this average percentage.
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2019 Information Technology Question 32. 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.