Neco 2022 Data Processing Question 37
Practice objective / multiple choice question 37 from the 2022 Neco Data Processing examination.
A spreadsheet records the monthly sales (units) of four products P1, P2, P3 and P4 for the first six months of the year. The sales figures are shown below. The column "Total" is intended to contain the sum of the four product sales for that month, but in one month the total was entered incorrectly as the product of the four sales instead of their sum. Month | P1 | P2 | P3 | P4 | Total Jan | 120 | 80 | 150 | 200 | (550) Feb | 130 | 90 | 160 | 210 | (590) Mar | 140 | 85 | 155 | 205 | (585) Apr | 150 | 95 | 165 | 215 | (625) May | 160 | 100 | 170 | 220 | (650) Jun | 170 | 105 | 175 | 225 | (702843750) Identify the month in which the total is incorrect, compute the correct total for that month, and give the corrected yearly total (sum of the six monthly totals).
Answer Options
About This Question
This is Neco 2022 Data Processing Question 37. 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.