Neco 2019 Data Processing Question 34

Practice objective / multiple choice question 34 from the 2019 Neco Data Processing examination.

Neco 2019 Data Processing Objective / Multiple Choice Hard Difficulty
Question 34 NECO • 2019 • DATA_PROCESSING • objective

A company records its monthly sales (in thousands of naira) for the first six months of the year as follows: Jan 120, Feb 150, Mar 130, Apr 160, May 140, Jun 110. The spreadsheet currently uses the formula \(=SUM(B2:B7)\) to total the sales. The manager wants the average monthly sales over the first seven months to be at least \(145\) thousand. Determine the minimum sales figure that must be entered for July (in thousands) so that the average meets the target. Also give the spreadsheet formula that would compute this required July figure directly from the existing data.

Answer Options

A. Minimum July sales = 210 (thousand); formula = 7*145 - SUM(B2:B7) + 5
B. Minimum July sales = 195 (thousand); formula = 7*145 - SUM(B2:B6)
Correct Answer C. Minimum July sales = 205 (thousand); formula = 7*145 - SUM(B2:B7)
D. Minimum July sales = 200 (thousand); formula = 7*145 - (SUM(B2:B7) - 5)
Correct Answer
C
Correct Option:
Minimum July sales = 205 (thousand); formula = 7*145 - SUM(B2:B7)

About This Question

This is Neco 2019 Data Processing Question 34. It is one of the objective questions from the 2019 Neco Data Processing examination.

Difficulty level: Hard .

View More Neco 2019 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