Neco 2017 Data Processing Question 32
Practice objective / multiple choice question 32 from the 2017 Neco Data Processing examination.
A spreadsheet records monthly sales (in thousand Naira) of three products for a year as follows:\n\n\begin{tabular}{c|ccc}\nMonth & Product A & Product B & Product C \\ \hline\nJan & 120 & 80 & 200 \\\nFeb & 130 & 85 & 190 \\\nMar & 115 & 90 & 195 \\\nApr & 140 & 95 & 205 \\\nMay & 150 & 100 & 210 \\\nJun & 160 & 105 & 215 \\\nJul & 155 & 110 & 220 \\\nAug & 165 & 115 & 225 \\\nSep & 170 & 120 & 230 \\\nOct & 175 & 125 & 235 \\\nNov & 180 & 130 & 240 \\\nDec & 190 & 135 & 245 \\n\end{tabular}\n\nUsing spreadsheet formulas, determine (i) the contribution percentage of each product to the total annual sales, and (ii) which product experienced a month‑over‑month growth exceeding \(20\%\) at any point, stating the product name and the month.
Answer Options
About This Question
This is Neco 2017 Data Processing Question 32. It is one of the objective questions from the 2017 Neco Data Processing examination.
Difficulty level: Hard .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.