Neco 2022 Data Processing Question 25

Practice objective / multiple choice question 25 from the 2022 Neco Data Processing examination.

Neco 2022 Data Processing Objective / Multiple Choice Hard Difficulty
Question 25 NECO • 2022 • DATA_PROCESSING • objective

A spreadsheet records monthly sales (in units) for three products over six months as follows:\n\n\begin{tabular}{c|cccccc}\nMonth & Jan & Feb & Mar & Apr & May & Jun \\ \hline\nProduct A & 120 & 150 & 130 & 160 & 140 & 155 \\nProduct B & 80 & 95 & 85 & 90 & 100 & 110 \\nProduct C & 200 & 210 & 190 & 205 & 195 & 215 \\n\end{tabular}\n\n(a) What is the total sales for the six‑month period?\n(b) Which product contributes more than \(40\%\) of the total sales?\n(c) Using the formula \(\frac{S_{last}-S_{first}}{S_{first}}\times100\%\), where \(S_{first}\) and \(S_{last}\) are the sales of the product identified in part (b) in January and June respectively, compute its average monthly growth rate (in %).

Answer Options

A. Total sales = 2630 units; product = C; growth = 8.2\\%
B. Total sales = 2700 units; product = A; growth = 7.5\\%
C. Total sales = 2600 units; product = B; growth = 6.8\\%
Correct Answer D. Total sales = 2630 units; product = C; growth = 7.5\%
Correct Answer
D
Correct Option:
Total sales = 2630 units; product = C; growth = 7.5\%

About This Question

This is Neco 2022 Data Processing Question 25. It is one of the objective questions from the 2022 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.

Unlock Full Access Available for Android & Windows
Chat with Support