Neco 2022 Data Processing Question 37

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

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

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

Correct Answer A. June; correct total = 675; corrected yearly total = 3675
B. May; correct total = 665; corrected yearly total = 3665
C. June; correct total = 680; corrected yearly total = 3680
D. June; correct total = 675; corrected yearly total = 3680
Correct Answer
A
Correct Option:
June; correct total = 675; corrected yearly total = 3675

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.

Unlock Full Access Available for Android & Windows
Chat with Support