Neco 2022 Computer Studies Question 12

Practice objective / multiple choice question 12 from the 2022 Neco Computer Studies examination.

Neco 2022 Computer Studies Objective / Multiple Choice Hard Difficulty
Question 12 NECO • 2022 • COMPUTER_STUDIES • objective

A spreadsheet records the monthly sales (in thousands of naira) of a shop for a year as follows: 120, 150, 130, 160, 140, 155, 165, 170, 145, 150, 158, 162. The user creates a formula to compute the average monthly sales and then applies conditional formatting to highlight every month whose sales exceed the average. If each highlighted month will generate a separate paragraph in a Word mail‑merge document, (a) how many paragraphs will be produced, and (b) what is the combined sales of the highlighted months? Provide the answer as "x months, y".

Answer Options

Correct Answer A. 6 months, 970000
B. 6 months, 950000
C. 7 months, 970000
D. 5 months, 970000
Correct Answer
A
Correct Option:
6 months, 970000

About This Question

This is Neco 2022 Computer Studies Question 12. It is one of the objective questions from the 2022 Neco Computer Studies 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