Neco 2022 Data Processing Question 49

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

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

A spreadsheet records monthly sales (in thousands of naira) for three products over six months as follows:\n\nMonth | A | B | C\n---|---|---|---\nJan | 120 | 80 | 50\nFeb | 135 | 85 | 55\nMar | 150 | 90 | 60\nApr | 165 | 95 | 70\nMay | 180 | 100 | 85\nJun | 210 | 110 | 100\n\nUsing spreadsheet formulas, compute: (i) the overall percentage growth in total sales from January to June, (ii) the weighted‑average growth rate of the three products where each product's growth is weighted by its January sales, and (iii) which product contributed the greatest absolute increase in sales over the period. Provide the three results.

Answer Options

Correct Answer A. Overall growth = 68 %; weighted‑average growth = 68 %; product A contributed the most.
B. Overall growth = 68 %; weighted‑average growth = 70 %; product A contributed the most.
C. Overall growth = 70 %; weighted‑average growth = 68 %; product C contributed the most.
D. Overall growth = 65 %; weighted‑average growth = 66 %; product B contributed the most.
Correct Answer
A
Correct Option:
Overall growth = 68 %; weighted‑average growth = 68 %; product A contributed the most.

About This Question

This is Neco 2022 Data Processing Question 49. It is one of the objective questions from the 2022 Neco Data Processing examination.

Difficulty level: Hard .

View More Neco 2022 Data Processing Questions More Neco Practice Questions Back to Questions

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